https://store-images.s-microsoft.com/image/apps.32252.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.bee2bc29-b0fb-44d6-a527-878349c9c55f

Salesforce data integration with SQL Server

COZYROC

Salesforce data integration with SQL Server

COZYROC

Salesforce Source and Destination components for data integration between Salesforce and SQL Server

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.
  • 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.
  • 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

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

You can create processes where the addition or deletion of Salesforce object fields doesn't necessitate modification of existing SSIS packages. This powerful feature requires no programming skills to use and greatly simplifies your maintenance efforts.

https://store-images.s-microsoft.com/image/apps.2862.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.64ad09a3-5577-430e-83fc-e5a4ff430201
/staticstorage/08216c2/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.2862.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.64ad09a3-5577-430e-83fc-e5a4ff430201
/staticstorage/08216c2/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.3409.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.b801da58-df6c-445c-af1c-32b0ce5f0520
/staticstorage/08216c2/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.40588.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.d30bb978-3b73-405d-99eb-dde00eebb6aa
/staticstorage/08216c2/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.987.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.fb3e2701-c442-427f-b77c-57a49d416c91
https://store-images.s-microsoft.com/image/apps.21550.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.035582b1-c936-4c1e-8656-5ca54890038e
https://store-images.s-microsoft.com/image/apps.22680.6e6a3323-0974-46d8-8cf7-32273e3e1600.9c7904dd-a57f-4884-bf2e-e45fa4f2cb7b.06bf56a2-8a1c-4e6b-a5ed-77662f382214