x

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 '09 at 03:48 AM in Default

Sreejith gravatar image

Sreejith
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 '09 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 '11 at 08:53 PM

SSISGuy gravatar image

SSISGuy
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 '10 at 05:56 PM

CozyRoc gravatar image

CozyRoc
1

(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 '11 at 07:47 AM

ericm gravatar image

ericm
1

(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

Thanks.

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

answered May 02 '12 at 07:04 PM

kingswaysoft gravatar image

kingswaysoft
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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x899

asked: Dec 30 '09 at 03:48 AM

Seen: 4451 times

Last Updated: Sep 18 '12 at 08:56 AM