Salesforce data integration with SQL Server

Salesforce Connection Manager

• Stores the credentials and functionality for connecting to Salesforce service.
• Well documented API for use by user-defined scripts.

Salesforce Source Component

• Retrieves data from a Salesforce object.

• Inserts or updates data in a Salesforce object.
• Supports four entity actions: Create, Update, Delete or Upsert.
• Provides information about records with errors as well as the unique identifier assigned for new records created.
• The destination can be dynamically modified at runtime using an SSIS expression.

File Transfer Task

• Allows working with Salesforce Files (download, upload, etc.)

Features:

• Support both regular SOAP and bulk REST API.
• Unique technology which allows user-defined reusable scripts for additional Salesforce integration scenarios.

COZYROC’s Salesforce SSIS data integration package facilitates seamless data flows between Salesforce and SQL Server maintaining data integrity across all platforms.

• Free developer license. It is free for download test and development within Visual Studio
• Support for SQL Server 2012 - 2022
  
• A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud
  
• One-time migrations and data transfers are completely FREE
  
• The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-box SSIS components.
  
• An easy-to-use solution designed for Developers, Solution Architects, Application Integrators, Consultants and DBAs looking to effortlessly integrate Salesforce with SQL Server, popular cloud applications and any database supported by SSIS.