Synchronize Salesforce with SQL Server using SSIS

  • dataintegration

    Mr or Mrs. 500

    Points: 510

    Comments posted to this topic are about the item Synchronize Salesforce with SQL Server using SSIS

  • paultormey

    Mr or Mrs. 500

    Points: 561

    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

    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

    SSC Veteran

    Points: 293

    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

    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

    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

    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

    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

    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?

  • This was removed by the editor as SPAM

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

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