Salesforce and DB2 integration with Cast Iron

Below is a short tutorial on how to integrate Salesforce with IBM DB2 using Cast Iron.

1. Define your SalesForce Endpoint by providing the following information (you must be a registered member of Salesforce):

• Username
• Password

Ste 2: Test the connection and make sure that it is successful.

Step 3: Define the DB2 Endpoint by providing the following information:

• DB2 Hostname
• DB2 Port Number
• DB2 Username
• DB2 Password
• PackageCollection: 100 (this can be any value)

Step 4: Test your DB2 connection to make sure it successfully connects to DB2

Step 5: Create you Orchestration flow

Step 6: Select the Salesforce Endpoint in Step 1 as the Endpoint for the ‘Poll Updated Activities’ Activity

Step 7: Select the Salesforce table that you want to poll.

In this instance in the Account Table the Name field was selected and will be used to update into DB2.

Step 8: Create the Ouput Map that will be the Input to the DB2 Activity

Step 9: On the Insert Rows activity select the DB2 Endpoint created in Step 3. Select the table that you want to insert the new row.

Step 10: Select the field of the DB2 Endpoint to insert the Salesforce data.

Step 11: Map the output from the Salesforce Poll Update Object activity to the input of the DB2 insert row activity.

Step 12: Validate the flow and run the flow

What will happen is when any update or new entry is added in the Accounts Salesforce browser and new row entry will be added to the DB2 database.