Synchronize Salesforce with SQL Server using SSIS

Question

Synchronize Salesforce with SQL Server using SSIS

dataintegration

Mr or Mrs. 500

Points: 510
More actions
September 29, 2014 at 9:54 pm

#297045

Comments posted to this topic are about the item Synchronize Salesforce with SQL Server using SSIS
January 10, 2018 at 6:44 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

paultormey Mr or Mrs. 500 Points: 571 More actions · Answer 1

Hi eric,

Out of interest, how does using RSSBus compare on reliability and performance when using a SQL Linked Server definition to link SQL Server and Salesforce?

mtassin SSC-Insane Points: 23099 More actions · Answer 2

Do you have any comparisons to either CozyRoc or Pragmatic Works' Salesforce Adapters?

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

rgarrett 82118 Old Hand Points: 344 More actions · Answer 3

I have not had any experience with using RSSBus. At my organization, we went with DBAmp and I built my packages to work around that. It uses a linked server and it's own API to query and sync the data with SalesForce.

The package I developed keeps a local copy of the pertinent tables synchronized with SalesForce every 4 hours. Some tables are updated more often based on specific needs. The only time there are issues is when the schema is changed on a table. When this occurs, I have to schedule a full pull down of the table to capture the changes. The package will still continue to run and capture changes to the data but ignore the schema changes until the full pull down of the table occurs.

If anyone else has had experiences with other tools, I'd like to hear about them.

dataintegration Mr or Mrs. 500 Points: 510 More actions · Answer 4

The choice between direct connectivity and replication just depends on your business requirements. The linked server approach directly proxies queries to Salesforce data (ODBC) for reporting etc. This is good for accessing real-time data, however queries (especially inserts, if done incorrectly) can suffer significant performance issues. On the other hand, Data replication is not affected by speed and availability of Salesforce.

If you prefer direct access to Salesforce from BI & Reporting, RSSBus provides drivers for ODBC, JDBC, ADO.NET etc.

dataintegration Mr or Mrs. 500 Points: 510 More actions · Answer 5

Hi Mark,

I don't have performance metrics that I can share that would compare these SSIS components. That said, RSSBus offers free trials so that you can fully evaluate any of the SSIS components and compare them in your own environment.

RSSBus focuses on building drivers for direct data integration through standard interfaces (ODBC/ JDBC/ ADO.NET, SSIS, BizTalk, etc.) You won’t find the breadth of offerings with any other company on the market.

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 6

I am using 'Pragmatic Task factory' tasks/adapters to Synchronize the Salesforce data with SQL Server data. It is very cool.

Thanks

tfendt Ten Centuries Points: 1235 More actions · Answer 7

Great article, I will give this a try! I am currently using Data Loader to export to csv once an hour then I have a SSIS package to take the CSV and import to a local DB.

Edit-- Just realized this is a paid component so I will stick with the free data loader tool.

dylaughin SSC Enthusiast Points: 111 More actions · Answer 8

Regarding "Step 3: Create a new connection manager, of the Salesforce type and configure the Salesforce credentials."

I do not have a connection of the Salesforce type listed.

Why is this?