December 29, 2009 at 11:51 pm
Can any one help in extracting data from SalesForce.com. I also need to use Google Analytics API to extract data from Google Analytics.I am planning to use SSIS (SQL 2005) does any one know of connectors for Salesforce.com or Google Analytics?
Thanks
Sreejith
January 1, 2010 at 11:43 am
Two that I know of
That uses linked servers and stored procedures to replicate your SF database locally - we tried it but had mixed success especially with large tables
CozyRoc suite of SSIS extensions contains an SF connector - have used the CozyRoc tools for other things (like SFTP connectors) and found them very good but can't comment on the SF connector specifically.
Kind Regards, Will
August 4, 2011 at 8:37 am
Take a look at the Salesforce ADO.NET Data Provider - http://www.rssbus.com/ado/salesforce/ . There is a sample article at http://www.rssbus.com/kb/articles/ado-ssistask.rst that demonstrates using the ADO.NET providers in SSIS.
August 4, 2011 at 9:48 am
Thanks for the feedback. Actually I did find the right tool. We bought cast iron (now part of IBM) and helped us with real time integration using messaging functionality.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply