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.
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.
I’m trying to insert row from sales force to DB2 .Mapping objects and fields are done successfully.When I do the orchestration the secure connector status is running and never says it has deployed or not.Do you have any idea.I’m using cast iron express(trial).
Hi Kumar, where are you deploying your flow to:
1. Virtual Cast Iron Appliance
2. Physical Appliance
3. Omni Cloud (AWS Cast Iron instance)
Maybe look at this tutorial for some assistance:
Check Step 3: Run the integration