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.

Advertisements

2 Comments on “Salesforce and DB2 integration with Cast Iron

  1. Hi.
    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).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: