Onboarding Data from Dynamics 365 Business Central

Creating a Dynamics 365 Business Central Source

For creating a Dynamic 365 Business Central source, see Configuring Additional Connectors. Ensure that the Source Type selected is Dynamic 365 Business Central.

Dynamics 365 Business Central Configurations

Field

Description

Fetch Data Using

The mechanism through which Infoworks fetches data from the database.

Connection URL

The connection URL through which Infoworks connects to the database.

Username

The username for the connection to the database.

Password

The password for the username provided.

Source Schema

The schema in the database to be crawled. The schema value is case sensitive.

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

Configuring a Dynamics 365 Business Central Table

For configuring a Dynamic 365 Business Central Table, see 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.