Video: Talend Open Studio

December 2nd, 2009

So I’m back on the ETL intro bandwagon with Talend Open Studio. Talend is essentially an EAI tool with connectors to numerous backend systems (SAP, Oracle, SQL Server, Salesforce.com, XML, etc) that generates Java code that is executed to perform the actual job. One cool feature is that you can create a jar of all of the jobs and deploy it to a computer running Java. This code can then be executed to run on a schedule basis to perform migrations.

This video shows how to create a job in Talend that extracts records from SQL Server and pushes them into Salesforce.com. Another great feature of Talend (I didn’t have time to show it) is that you can perform transformations during the job. For instance, how many times have you received a spreadsheet of accounts and their associated contacts to import? With the Data Loader you have to import the accounts and then add the account ids to the contacts before uploading them. With Talend, you can write a transformation that does this look up for you automatically.

One of my fellow Appirians, Ward Loving, did a great tutorial on setting up Talend on the Appirio Tech Blog.

Categories: Salesforce

1 Comment

Jack Dermody February 1st, 2010
Hi Jeff,
How are things? It nice to see your flying the flag for Talend.
Last November we came Certified Talend Partner of Talend. We are finding Talend very useful in solving life’s little problems be it in open source product or there commercial offering.

We have been using the version 4 which is just in beta and they have done some serious upgrades with there salesforce components. Including Error handling has been improved as well as sign on once..

On top of that they have brought out MDM (Master Data Management) which is very powerful integration tool offering functionality which is normally reserved for the big boys, at big boys prices.

There is a few things to sort out at the start to get the Enterprise and Partner WSDLs working properly, but Talend were very helpful.