Configuring a Connection
The connector comes with a connection builder which allows you to build and test your connection settings outside of Tableau. It also allows you to create a connection string, which can be used to provide options not listed in the connection dialog in Tableau.
Configuring a Connection Builder
There are two ways to access the connection builder:
- On Windows, there will be a shortcut called Connection Builder in the start menu, under the CData Dynamics 365 Finance and Operations Tableau Data Connector folder.
- The connection builder can also be started by going to the driver install directory and running the .jar file in the lib directory.
In the connection builder, you can set values for connection properties and click the Test Connection button to validate that they work. You can also use the Copy to Clipboard button to save the connection string for use with Tableau.
Connecting to Dynamics 365 Finance and Operations
To authenticate to the Dynamics 365 Finance and Operations source, you should first set the OrganizationUrl to the URL of the organization you are connecting to, such as https://[organization].crm.dynamics.com.
Authenticating using Azure AD
Azure AD is a connection type that goes through OAuth. Set your AuthScheme to AzureAD and see Using OAuth Authentication for an authentication guide.
Authenticating using Azure Service Principal
Azure Service Principal is a connection type that goes through OAuth. Set your AuthScheme to AzureServicePrincipal and see Using Azure Service Principal Authentication for an authentication guide.
Authenticating using MSI Authentication
If you are running Dynamics 365 Finance and Operations on an Azure VM, you can leverage Managed Service Identity (MSI) credentials to connect:
- AuthScheme: Set this to AzureMSI.
The MSI credentials will then be automatically obtained for authentication.
See Getting Data for the next step, which includes authenticating to the Dynamics 365 Finance and Operations APIs.