Salesforce SSIS integration components - Cozyroc SSIS suite

Introducing the COZYROC SSIS+ library with support for integration and migration of Salesforce data. The Salesforce components are third-party plug-ins for Microsoft SSIS. Available on the market since 2009, COZYROC makes it easy to integrate or migrate data to and from Salesforce and will preserve the integrity of your data by always using the SOAP-based and REST-based APIs. You can use any application, service or database supported by SQL Server Integration Services (SSIS) or Cozyroc’s toolkit as the source or destination for Salesforce.

The toolkit is easy to use and follows the same guidelines and principles used by the standard out-of-the-box SSIS components. In addition, COZYROC also provides short and informative demonstration videos, providing step-by-step instructions on how to get started.

The Salesforce SSIS integration package consists of four main parts:

Salesforce Connection Manager - Stores the credentials and functionality for connecting to a Salesforce server.

• 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.
• Provides the ability to retrieve deleted records 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.

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

COZYROC currently provides the following free reusable scripts:

• Time Zone Transformation script - Convert date/time to another time zone.
• Salesforce Fields Source script - Retrieve Salesforce object fields metadata.
• Salesforce Get Deleted Source script - Retrieve Salesforce object deleted record identifiers.
• Salesforce Get Updated Source script - Retrieve Salesforce object updated record identifiers.
• Salesforce Lookup Transformation script - Lookup against Salesforce service.
• Salesforce Object Source script - Retrieve Salesforce objects metadata.
• Salesforce Bulk Result Transformation script - Retrieve information about records sent for processing in bulk-mode.

Free for download and development within Visual Studio

✔️ Free developer license.

✔️ Support for SQL Server 2012 - 2022

✔️ COZYROC SSIS+ suite includes more than 270 tasks and SSIS components for ETL and Data Integration

✔️ 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 COZYROC SSIS+ components suite also includes:

The powerful and elegant Data Flow Task Plus, not found in any other competitive product on the market. Data Flow Task Plus allows creation of Dynamic data flows at runtime and can be used with COZYROC's REST adapters.

Check the SSIS Data Flow Task demo video in our Youtube channel.

See also:

• COZYROC SSIS REST framework video. With the COZYROC SSIS REST framework you can connect to any Web service and consume any Web API. Free for download and development https://www.cozyroc.com/ssis/rest

• COZYROC SORT Plus SSIS component video. With COZYROC’s Sort Plus SSIS component, you can sort ANY amount of data and any number of records. Free for download and development https://www.cozyroc.com/ssis/sort

• For a full compatibility list and more information about the COZYROC SSIS+ Components, please visit the COZYROC website

Try COZYROC Cloud for free. The COZYROC.Cloud hosted service allows you to Lift & Shift legacy SSIS workloads to the cloud in a breeze at a very affordable price which includes a license for the COZYROC SSIS+ suite.

Get in touch with us:

• For support or any questions connect with us