Category: cast iron

Use Case 3 – WebSphere Cast Iron Integration – MySQL and Salesforce.com

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

Read More

Use Case 2 – WebSphere Cast Iron Cloud Integration – Fetch CSV File from FTP Server and Insert Data into Salesforce.com

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 FTP with Salesforce. Toady, in this example, I will fetch a CSV file present in a FTP server, read that file and then create the Salesforce object based on that record. Finally I will send the response also. So let’s not waste time here and get straight into the business.Use Case:Below is the object structure -Below is the CSV File(All_Airports.csv) I would like to read and load from FTP server.Once done, the final requirement is to create Salesforce records based on the data present in the CSV file.Implementation:Before we start implementing the above requirement, let’s create the Endpoints first.Endpoint – FTP:Endpoint – Salesforce:Endpoint – HTTP:Create a default HTTP endpoint with port number 80.Now we will create the Flat File Schema as shown below. This flat file schema will be used to read to CSV file present in the FTP server.So all set. Now we will configure the integration by putting activities inside the Orchestration.Activity# 1: HTTP Receive Request:Below you will find all the configuration details related to Receive Request activity.Activity# 2: FTP Get File: This activity will fetch the CSV file from the FTP Server. The configuration of this activity is displayed below -Activity# 3: Transform Read Flat File:Activity# 4: Salesforce.com Create Objects:In this...

Read More

Use Case 1 – WebSphere Cast Iron Cloud Integration – HTTP Receive and Send

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 a simple HTTP Receive and Send integration. Though this post is nothing to do with Integration with Salesforce.com, but still I would like to make this post so that you can understand how easy it is to configure WebSphere Cast Iron.I will use Cast Iron Design Studio to do the configuration.Step 1:Create a project with name “HTML_2_HTML_Integration” and save it. Click on File | New | New Project [Local]..Step 2:You should see a screen like that once you click on the ok button.Step 3:Now drag and drop activity “Receive Request” from right hand side to the Orchestration. The screen should look like -Step 4:Now let’s configure Receive Request -Configure Pick Endpoint – Click on Pick EndPoint and then the New.. button to create a new EndPoint. The screen should look like –  Here you can choose the port number and UserName/Password for your HTTP connection. For the simplicity, I am just choosing the default values i.e. post 80 and no UserName/Password. Configure URL – Click on Configure and provide a name which will be appended after Hostname. I have given a name “HelloWorld”. Choose POST as the HTTP method and check “Requires a Reply” at the button. It should look like -Configure Map Outputs – This is...

Read More

Quick Introduction of WebSphere Cast Iron

Preface – This post is part of “WebSphere Cast Iron Cloud Integration with Salesforce.com” series.What is WebSphere Cast Iron -WebSphere Cast Iron provides customers a platform so that they can integrate cloud based applications from leading SaaS providers with on-premise applications. IBM acquired Cast Iron system in the year of 2010.WebSphere Cast Iron Live is a multi-tenant, cloud based platform for Integration cloud application with other cloud applications/on-premise applications. WebSphere Cast Iron is available in three different packages -In an appliance – WebSphere Cast Iron DataPower XH40 is a self-contained physical appliance.In the mode of Virtual Machine – WebSphere Cast Iron Hypervisor Edition.In cloud – WebSphere Cast Iron Live.Refer Wikipedia to know more about WebSphere Cast IronHow to get access in WebSphere Cast Iron -You can try WebSphere Cast Iron Live for 30 days without any cost. Click here to get the WebSphere Cast Iron Live free for 30 days.Cast Iron Solution Guides -Please have a look at the below Solutions guides. Integrating Two Cloud Services with IBM WebSphere Cast Iron Live Redbook: http://www.redbooks.ibm.com/abstracts/TIPS0962.htmlGetting Started with IBM WebSphere Cast Iron Cloud Integration http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/sg248004.html?OpenIn my next post, I will start with first Use Case i.e. WebSphere Cast Iron Cloud Integration – HTTP Receive and Send.I will really appreciate if you provide your feedback....

Read More
Loading