Overview
Data flow transformation, performing lookup against Dynamics CRM service.
Setup
The script has the following parameters:
- CrmConnection - selects COZYROC Dynamics CRM connection.
- Entity - selects Dynamics CRM entity.
- KeyAttribute - selects one or more entity key attributes. After you select the attributes, you have to map your input columns to the key attributes in the Mappings tab.
- ValueAttribute - selects one or more lookup value attributes.
- UseCache - specify whether you want to use in-memory caching. Default is false.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.
Dynamics_CRM_Lookup_Transformation.jsKnowledge Base
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.