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):
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.
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.