Category: mysql

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.Use Case:Below is the object structure -MySQL table looks like  – Implementation: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.comThe 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 -COOL!!!If you follow the steps mentioned in this...