Knowledge Base
Creating a Dynamics CRM Change Data Source
Browse Common Categories
- Using a Restriction
- Adding a Run Map Task
- Adding an Email Task
- Defining Remaining Options
- Using a Custom Rolling Column
- Using a Translation
- Using a Date Calculation
- Using a Calculation
- Performing the Field Mapping
- Determining Source Grouping
- Defining an Integration Target
- Defining an Integration Source
- Populating the Integration Details
- Using a MultiList Option Lookup
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Lookup
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics CRM
- Setting up a Dynamics CRM Connection
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Using a Relationship
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using an Odata Field Lookup
- Creating a Dynamics 365 Business Central Change Data Source
- Creating a Dynamics 365 Business Central Real-time Data Source
- Setting up a Dynamics 365 Business Central Connection
- Connecting to Dynamics 365 Business Central using an OAuth Token
- Using a Page Field Lookup
- Using a Page Key Field Lookup
- Setting up an Integration to Dynamics 365 Business Central
- Creating a Dynamics 365 Business Central Bulk Data Source
- Using an Activity Party
- Using an Entity Lookup
- Connecting to Dynamics 365 Customer Engagement using an OAuth Token
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Setting up an Integration to Dynamics 365 Sales
- Creating a Dynamics 365 Sales Real-Time Data Source
- Creating a Dynamics 365 Sales Change Data Source
- Creating a Dynamics 365 Sales Bulk Data Source
- Setting up a Dynamics 365 Sales Connection
- Using an Entity Reference
- Using a MultiList Option Lookup
- Using an Activity Party
- Using an Entity Lookup
- Setting up an Integration to Dynamics CRM
- Creating a Dynamics CRM Real-Time Data Source
- Creating a Dynamics CRM Change Data Source
- Creating a Dynamics CRM Bulk Data Source
- Setting up a Dynamics CRM Connection
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
Creating a Dynamics CRM Change Data Source
- On the left side options column expand Data Sources, expand Change Triggers, and click on Trigger.
- On the Change Triggers page click the Create Change Trigger button.
- On the New Query Data Source page click the Microsoft CRM Change Data Source button.
- The Microsoft CRM Change Data Source page opens.
- Enter a Description for the data source.
- Connection – Select the connection to be used from the dropdown list.
- Click the Validate button – This will verify the Connection is successful and enable the Organization and Entity fields.
- Organization – After the connection is validated, the Organization field becomes active. Select the organization to be used from the dropdown list, the default organization setup on the connection will automatically be selected.
- Entity – From the dropdown list select the CRM entity to be used.
- Trigger On Column Change – Select the column(s) that will cause the trigger to run when changed.
- Return Option Set Labels – Option sets within CRM have a value (held in the database) and a label (shown to the end user). Default queries to CRM return the value for option sets rather than the label. The return option sets as label checkbox on CRM data sources will return the label linked to the option set instead of the value.
- Click Save – This will save the data source and enable the Edit Query button if the user needs to edit the query.
- Edit Query – Opens the Query Builder to edit the query.
- After the query has been created click on Save Query to return to the Microsoft CRM Change Data Source window.
- IMPORTANT: In Order to save the data change source at this point, the user must click on Validate and have the validation return a successful message. Once the successful message is returned the Save button will become active.
- Click Save to save the change data source.
Support