Devart Forums

Currently the company I work for is using Informatica cloud to move data between SQL Server 2012 and Salesforce.

As the person who inherited this Applinked process and who does not like Informatica cloud, what is the best way to use SSIS to push and pull data from Salesforce?

I've done a little bit of google research so I have a feeling I'll need a connector. Is there a specific connector that is better or more highly recommended?

Thank

Devart SSIS Data Flow Components for Salesforce allow you to integrate Salesforce contacts, accounts, opportunities, leads, users, attachments, tasks, and other objects with other cloud applications and databases via SQL Server Integration Services (SSIS). They include optimized Salesforce Source, Salesforce Destination, and Salesforce Lookup components and provide their own Salesforce Connection Manager with lots of Salesforce-specific connectivity features.
https://www.devart.com/ssis/salesforce.html

There is no need to install special components for the SQL Server, standard components are used.
See also Devart SSIS Data Flow Components documentation. (Examples from the documentation refer exactly to Salesforce).

Alternatively, you can try our cloud solution: https://skyvia.com/