Video: Informatica Data Loader

September 21st, 2009

I’ve been digging into a number of free or low cost Salesforce data loader offerings lately so I thought I’d put together some videos with overviews of the services.

I’m starting out with Informatica’s Data Loader and want to eventually demo DemandTools, DBAmp/Pro, Talend Open Studio and Apatar.

Note: It may be easier to watch this video directly at YouTube as you can adjust the size of the video.

Categories: Salesforce

12 Comments

Luke "AlwaysThinkin" C September 21st, 2009
Great series! I’m eager to hear about all 5 since I’m in the middle of my own investigations for a data syncing tool.
Mike G September 21st, 2009
You might want to investigate extending the Salesforce data loader from the command line (http://wiki.developerforce.com/index.php/Using_Data_Loader_from_the_command_line). This will be more powerful after Winter ’10 goes into production and you can use batch apex! You can’t do any transformations since its basically the data loader engine but I created an MS Excel macro that does that for me. I believe you can even log into a SQL/Oracle database.
jeffdonthemic September 21st, 2009
Great idea Mike! I’m certainly excited about the bulk API.
Salesforce Data Loader Demo « In(tegrate) the Clouds September 22nd, 2009
[...] On Demand, SaaS Integration, Salesforce data loader, Salesforce integration Check out this Salesforce data loader demo from Jeff Douglas, a senior technical consultant from [...]
apexsutherland September 22nd, 2009
Jeff have you evaluated Jitterbit? I think it’s similar to Apatar but with a slightly larger community of users. I would be very interested to see a comparison of the integration experience with Salesforce.com.

Thanks for this demo, it’s very helpful!
jeffdonthemic September 22nd, 2009
Never seen nor heard of Jitterbit but I’ll definitely check it out! Thanks for the tip Alex!
Mike G September 25th, 2009
I’ve tried using Jitterbit, Apatar, and recently Talend. I have to say Talend, by far, has the easiest learning curve. It also has better documentation. I just started using Talend 2 days ago and have almost migrated my entire ETL process. It also seems to have the best integration with Salesforce considering its open source. What took me 2 hours to process manually using multiple spreadsheets and Excel macros takes Talend about 33000 msec.
apexsutherland September 28th, 2009
Thanks for the tip about Talend Mike, I didn’t know anything about them! I’ll definitely check out their solution…
jeffdonthemic September 28th, 2009
Alex, one of my buddies at Appirio did a great article on our tech blog: http://techblog.appirio.com/2009/08/using-talend-to-export-data-from.html
apexsutherland September 28th, 2009
Very interesting, thanks for the link. Did he ever get around to doing a “Part 2″? I couldn’t find any other posts about it.
jeffdonthemic September 28th, 2009
No… not as of now but I’m probably going to be doing a video in a couple of weeks.
Jack Dermody October 14th, 2009
Jeff,

Nice still your at it… I have been working on this solution for a few weeks on and off.

I have it down to two, Jitterbit & Talend. Jitterbit is easier to use while Talend.

I really want see how these preform under a bit of pressure.

Will have more later…

Check out
http://it.toolbox.com/blogs/open-etl-tools/pentaho-talend-and-jitterbit-comparison-31925
for a start