SSIS and SalesForce.com

Can any one help in extracting data from SalesForce.com. I alse 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?

more ▼

asked Dec 30, 2009 at 03:48 AM in Default

Sreejith gravatar image

32 1 1 1

(comments are locked)
10|1200 characters needed characters left

8 answers: sort voted first

CozyRoc has a SalesForce connector. Reviews of their other SSIS products have been uniformly positive. I don't know of any Google Analytics interfaces. Look for extensions to SSIS here: http://ssisctc.codeplex.com/

more ▼

answered Dec 30, 2009 at 04:25 AM

Todd McDermid gravatar image

Todd McDermid
391 2

(comments are locked)
10|1200 characters needed characters left

Have you tried TaskFactory from Pragmaticworks? They have [SSIS SalesForce Source][1] and [SSIS SalesForce Destination][1] too.

[1]: http://pragmaticworks.com/products/Business-Intelligence/taskfactory/ssis-tasks-xml-sftp-zip-upsert.aspx
more ▼

answered Jan 17, 2011 at 08:53 PM

SSISGuy gravatar image

52 1 1 1

(comments are locked)
10|1200 characters needed characters left

You can download script for retrieving data in SSIS from Google Analytics from http://www.cozyroc.com/script/google-gdata-source.

more ▼

answered Jan 26, 2010 at 05:56 PM

CozyRoc gravatar image


(comments are locked)
10|1200 characters needed characters left
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.
more ▼

answered Aug 04, 2011 at 07:47 AM

ericm gravatar image


(comments are locked)
10|1200 characters needed characters left

For data integration with Saleforce, our company has just released a product called SSIS Integration Toolkit for Salesforce, which is available for download at http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-salesforce


[1]: http://www.kingswaysoft.com/products/ssis-integration-toolkit-for-salesforce
more ▼

answered May 02, 2012 at 07:04 PM

kingswaysoft gravatar image

0 1

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 30, 2009 at 03:48 AM

Seen: 4977 times

Last Updated: Sep 18, 2012 at 08:56 AM