Preface – This post is part of “WebSphere Cast Iron Cloud Integration with Salesforce.com” series.
Today I will post how you can use WebSphere Cast Iron for integrating MySQL with Salesforce. Toady, in this example, I will fetch records from MySQL Table and then create the Salesforce object based on that record. So READY, STEADY and GO!!
Note: I have used http://www.freemysqlhosting.net/ for creating free MySQL Database.
Below is the object structure –
Before we start implementing the above requirement, let’s create the Endpoints first.
Endpoint – FTP:
Endpoint – Salesforce:
So all set. Now we will configure the integration by putting activities inside the Orchestration.
Activity# 1: Database – Get Inserted Rows:
In this activity, I will fetch the inserted rows from the database. Below are the configuration details –
Activity# 2: Add If – Else Condition:
The requirement is – if the Airport Name is blank, then terminate the process, else do an upsert into Salesforce.com
The configuration is displayed below –
Activity# 3: Salesforce Upsert Objects:
Below are the configuration details for this step –
We are done. The final Orchestration looks like –
Test the Integration –
It’s time to test the configuration. First we need to start the orchestration and we can do that from Orchestration | Start Orchestration.
After 5 seconds, if we see our Salesforce Airport object, we will be able to see that two records being created as shown below –
If you follow the steps mentioned in this post, you will be able to configure this integration very easily.
Please let me know if you need any details. Thanks.