Working with BulkSample Project

The BulkSample project gives you a quick overview of how to use the Salesforce Bulk API Palette of the TIBCO ActiveMatrix BusinessWorks Plug-in for Salesforce.com.

Procedure

  1. Start TIBCO Business Studio.
  2. Click File > Import.
  3. In the Import window, expand the General folder and select the Existing Studio Projects into Workspace item. Click Next.
  4. Click Browse next to the Select archive file field to locate the samples. Click Finish.
    The sample project is located in the TIBCO_HOME\bw\palettes\salesforce\version_number\samples\BulkSample directory.
  5. Change the values in the User Name and Password fields in the Connection Configuration panel of the Salesforce Connection shared resource.
  6. In this project, five processes are created. Configure these processes as explained below:
    • BulkInsertJson Process

      This process inserts records for the contact sObject using JSON format and queries the record using Bulk Query. You should provide the file IBCO_HOME\bw\palettes\salesforce\version_number\samples\BulkSample\sampleDataJson.json in BulkInsert activity and create a file test.json on your system and provide that location in the Output File of Insertgetresult activity.

    • BulkUpdateRow Process

      This process updates the record inserted by the above process by using the Update operation of the Bulk Operation activity with ROW format.

    • BulkUpsertRow Process

      This process upserts the record inserted by the above process by using the Upsert operation of the Bulk Operation activity with ROW format. You should create a file test.xml on your system and provide that location in the Output File on General tab of Upsertgetresult activity.

    • BulkUpsertXML Process

      This process updates the inserted records and inserts a new record by using the Upsert operation of the Bulk Operation activity. You should create a file sampledata.xml on your system and provide that location in the Output File of Upsertgetresult activity.

    • BulkDeleteCSV Process

      Using the Bulk Operation activity's Delete operation, this process deletes the records that were inserted in the BulkInsertJson and BulkUpsertXML processes. You should create a file deletedata.csv on your system and provide that location in the Output File on General tab of Upsertgetresult activity.

  7. Test and run the processes in the project, in the order they are listed above.