Knowledge Base
Creating a Dynamics CRM Bulk Data Source
Browse Common Categories
- 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
- Connecting to Dynamics 365 Customer Engagement using an OAuth Token
- Using a Relationship
- Using a List Option Lookup
- Using a Multi Lookup
- Using an Entity Reference
- Using an Activity Party
- Using an Entity 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
- 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
- Using an Activity Party
- Using an Entity Lookup
Creating a Dynamics CRM Bulk Data Source
-
On the left side options column expand Data Sources, expand Bulk Sources, and click on Query.
-
On the Query Data Sources page click Create Bulk Query button.
-
On the New Query Data Source page click the Microsoft Dynamics CRM Query Data Source button.
-
The page to configure the Dynamics CRM query data source opens.
- Enter a Name for the query.
- Connection – select the Dynamics CRM connection to be used from the dropdown list.
- Organization – select the CRM organization to be used from the dropdown list.
- 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 Validate. If the validation is successful, the Edit Query button becomes active.
-
Click Edit Query – opens the Query Builder to create a new query or edit an existing query.
- After the query has been created click on Save Query to return to the Dynamics CRM Sales Query Data Source window.
- IMPORTANT: In Order to save the data query 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 Edit Query, Save, and Preview buttons will become active.
- Click Save to save the query source.
Support