• Knowledge Base
  • SmartConnect
  • Creating a Dynamics 365 Sales Bulk Data Source

Creating a Dynamics 365 Sales Bulk Data Source

Published: Sep 12, 2018

Creating a Dynamics 365 Sales Bulk Data Source

Published: Sep 12, 2018
  1. On the left side options column expand Data Sources and click on Realtime Triggers.

  2. On the Realtime Triggers page click Create Realtime Trigger button.

  3. On the New Realtime Trigger page click the Dynamics 365 Sales Real-Time Data Source button.

  4. The Dynamics 365 Sales Real-Time Data Source page opens.

  5. Enter a Description for the data source.
  6. Connection – select the connection to be used from the dropdown list.
  7. Click the Validate button – this will verify the Connection is successful and enable the Organization and Entity fields.
  8. Organization – after the connection is selected, the Organization field becomes active. Select the organization to be used from the dropdown list.
  9. Entity – from the dropdown list select the CRM entity to be updated.
  10. Trigger On Column Change – select the column(s) that will cause the trigger to run when changed.
  11. Log Action – use this option to what, if anything, should be logged when the trigger runs. The options are:
    1. Always Save
    2. Save Failures
    3. Save Successes
    4. None
  12. 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.
  13. Click Save – this will save the data source and enable the Edit Query button if the user needs to edit the query.
  14. Edit Query – opens the Query Builder to edit the query.
  15. After the query has been created click on Save Query to return to the Dynamics 365 Sales Real-Time Data Source window.
  16. 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 Edit Query, Save, and Preview buttons will become active.
  17. Click Save to save the change data source.
  18. Register button – this button will become active after an Integration Process (mapping) is created that uses the data source. After the Integration Process is created, the user will need to go back to the data source in order to do the registration.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.

Get support
Reset Filters