Dynamics CRM SSIS Integration - Cozyroc SSIS library.

Dyn 365 / Dynamics CRM SSIS components for Data integration

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 Dynamics CRM. 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 Dynamics CRM integration package consists of four main parts:

Dynamics CRM Connection Manager - Stores the credentials and functionality for connecting to an on premise or in-the-cloud Dynamics CRM server.

• Well documented API for use by user-defined scripts.
• Independent from the hard-coded Microsoft Dynamics CRM SDK.

Dynamics CRM Source component - Retrieves data from a Dynamics CRM entity.

Video demonstration of Dynamics CRM Source component

• Input type can be either an entity or a FetchXml statement.
• The source can be dynamically modified at runtime using an SSIS expression.

Dynamics CRM Destination component - Inserts or updates data in Dynamics CRM entity.

Video demonstration of Dynamics CRM Destination component

• Supports four entity actions: Create, Update, Delete or Upsert
• Provides information about records with errors as well as the GUID assigned for new records created.
• Configurable parameters for Upsert action specify how to handle multiple matches and what keys to use to identify existing records.
• Phenomenal performance: a customer used our component to migrate 40 Million records in 10.5 Hours “in a precise and timely manner.”

Unique technology which allows user-defined reusable scripts for additional Dynamics CRM integration scenarios. COZYROC currently provides the following free reusable scripts:

• Dynamics CRM Access Teams Destination
• Dynamics CRM Assign Destination
• Dynamics CRM Association Destination
• Dynamics CRM Attributes Source
• Dynamics CRM Audit Logs Query
• Dynamics CRM Bulk Delete Task
• Dynamics CRM Convert
• Dynamics CRM Entity Changes Source
• Dynamics CRM Entity Source
• Dynamics CRM Execute Workflow Destination
• Dynamics CRM Incident State Destination
• Dynamics CRM Lookup Transformation
• Dynamics CRM Merge Destination
• Dynamics CRM Opportunity State Destination
• Dynamics CRM OptionSet
• Dynamics CRM Qualify Lead Destination
• Dynamics CRM Quote To Sales Order
• Dynamics CRM Relationship Destination
• Dynamics CRM Route Destination
• Dynamics CRM Team Members Destination
• Dynamics CRM User Access Destination

The COZYROC SSIS+ library 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 Dynamics CRM adapters. You can create processes where the addition or deletion of Dynamics CRM entity attributes doesn't necessitate modification of existing SSIS packages. This powerful feature requires no programming skills to use and greatly simplifies your maintenance efforts.

• [ ] Support Dynamics 365, Premise, Live, Hosted deployments.
• [ ] Support 2016, 2015, 2013, 2011, 4.0 and 3.0 systems.
• [ ] Uses only standard Dynamics CRM SOAP web services API.
• [ ] Unique reusable script technology for complimentary functionality and flexibility.

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