The steps below assume that your organization has already registered an application for Terminus Data Studio integration in Azure. Microsoft’s instructions for registering an application can be found here.
Note: Terminus Data Studio does not support an integration with an on-premise deployment of MS Dynamics; however, organizations using an on-premise CRM may instead be eligible for our List-Based Data Studio configuration.
This document outlines the steps for integrating Terminus Data Studio with your Microsoft Dynamics 365 instance. Note: This integration requires an Azure/Dynamics 365 Admin user.
Customers who integrate their Data Studio instance with Microsoft Dynamics can access the following app pages:
Dynamics-integrated customers can also use their Data Studio lists as an audience source in their Terminus Engage (advertising) instance. There is currently no direct integration available between the Terminus Engage platform and Dynamics.
Steps To Integrate
Step 1 - Add the Data Studio Redirect URIs to your Dynamics 365 Azure account.
a. Log in to: https://portal.office.com/AdminPortal/Home.
b. Navigate to the Admin centers menu on the left hand navigation and click on Azure Active Directory. This will load the Azure Active Directory admin center console.
c. From the Azure Active Directory admin center console click on Azure Active Directory under Favorites in the left hand navigation pane.
d. Click on App registrations in the navigation panel.
e. Click on your own organization’s application* in the All applications list ('Test' in this example). *See 'Prerequisite' section at the start of document for more information.
f. Click on the Redirect URIs section.
g. On this page add the following url (with a Type of "Web"):
h. Click Save in the bottom of the screen when done.
Step 2 - Connect Terminus Data Studio with Microsoft Dynamics (aka "OAuth")
a. Log in to home.terminusplatform.com/ using your email/username and password.
b. Navigate to the Data Studio product.
c. Copy/paste the following link into the browser: studio.terminusplatform.com/dynamics/
d. Enter the requested information, which is:
Box 1 is your Office 365 Organization Name.
If you do not already know your organization name, you can find it using Microsoft's instructions here.
Only type your organization-name value (e.g., "terminus") in this field for Box 1.
Box 2 is your Dynamics instance's Discovery Service Endpoint URL. Find your Discovery Service Endpoint URL by logging in as an Admin to Dynamics 365 and navigating to:
Settings > Customizations > Developer Resources.
The “Endpoint Address” under "Discovery Web API" will contain the URL we need. See this page for more detailed instructions. Otherwise, you can also determine the Discovery Service Endpoint URL from Microsoft's documented list here. Use the appropriate URL for your location.
e. Once you've populated both boxes with the correct identifiers, hit ‘Connect to Dynamics’. And now you're done! Terminus will automatically be notified of the successful connection and will begin syncing your CRM data to Data Studio. If your organization is onboarding and it is the first time connecting, then it may take up to 3 business days for Dynamics365 data to appear in Data Studio.
If you have questions at any point in the process outlined above, please reach out to your Terminus Onboarding Specialist or support through the Terminus Support Portal for assistance.