Onboarding Data from Dynamics 365 for Finance and Operations

Creating a Dynamics 365 for Finance and Operations Source

For creating an Dynamics 365 for Finance and Operations source, see $link[page,321304,auto$]. Ensure that the Source Type selected is Dynamics 365 for Finance and Operations.

To enable OAuth, see $link[page,321304,Enabling OAuth for CDATA Drivers,enabling-oauth-for-cdata-drivers].

Embedded OAuth Parameter Settings

You can connect to the CDATA driver without setting any connection properties for your user credentials.

Set the following embedded OAuth parameter:

Custom OAuth Parameter Settings

Set the following parameters to authenticate with the credentials for a Custom OAuth app:

Dynamics 365 for Finance and Operations Configurations

Once the settings are saved, you can test the connection.

Configuring a Dynamics 365 for Finance and Operations Table

For configuring a Dynamics 365 for Finance and Operations Table, see $link[page,321304,Configuring a Table,configuring-a-table].

Establishing a Connection

To create a JDBC URL, see Establishing a Connection.

Data Model

The tables and views supported by the source are described in the Data Model.

JDBC Connection Parameters

For the list of JDBC connection parameters, see Connection Parameters.