The Salesforce SSIS Integration Package, developed by COZYROC, offers a high-performance, user-friendly solution for integrating Salesforce with SQL Server

This integration ensures data synchronization and management, simplifying the integration of Salesforce contacts, accounts, opportunities, and more with popular cloud applications and any database supported by SSIS

The Salesforce integration package consists of:

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.

Input type can be either an object or a SOQL statement.
The source can be dynamically modified at runtime using an SSIS expression.
Supports retrieval of deleted and archived records.

Salesforce Destination Component

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.

Knowledge Base

The COZYROC SSIS+ components suite also includes Data Flow Task Plus.

Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's Salesforce adapters.

Salesforce data integration with SQL Server

Автор: COZYROC