MS Dynamics 365 BC Source Connector

The MS Dynamics 365 BC source connector in DataSync lets you retrieve business data from Microsoft Dynamics 365 Business Central using the available API endpoints for loading or synchronizing in your data warehouse. After creating all required source connections, configure your destination source to complete the connection setup.

Configure access in Microsoft Dynamics 365 BC

Assign user permissions

1. Log in to Dynamic 365 Business Central.
2. Click the magnifying glass in the upper‑right corner.
3. In the search bar, enter Users.
4. Select Users under Administration. A list of all users appears.
5. Select the user account you want to use for the DataSync connection.
6. In User Permission Sets, assign the authorizations required for the connection. Changes are saved automatically.

Register an application in Azure Portal

1. Log in to the Azure Portal as an administrator.
2. Under Azure services, select More services.
3. In the search bar, enter App registrations and select it.
4. Click + New registration.
5. Enter a name for the application, select supported account types, and optionally add a redirect URL.
6. Return to the App registrations page and select your new registration.
7. In the left navigation pane, select API permissions and add the permissions needed for your application. Grant admin consent if required.
8. In the left navigation pane, select Certificates & secrets and create a new client secret.
   • Important: The client secret can only be copied once — store it securely for later use.

Create a source connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Source Connections, click New.
4. Select MS Dynamics 365 BC.
5. In the Connection Properties panel, enter the connection properties.
6. Copy the Callback URL from the Connection Properties panel.
7. Log back in to the Azure Portal.
8. Under Azure services, select More services and search for App registrations.
9. Select your app. In the navigation pane, click Manage Authentication.
10. Add a Web platform configuration and paste the Callback URL.
11. (Optional) In the Additional Connection Properties panel, select Add property and enter the parameters for each property.
12. In the Advanced Settings panel, configure the settings, including the Tracking Type and other values according to your requirements.
13. Click Save.
14. You will be redirected to the sign‑in screen to authenticate. After logging in, the callback should complete successfully.

Parameters

Connection properties

Parameter	Description
Description	Unique name for the connection. Example: MS Dynamics 365 BC
Organization URL	URL for the Microsoft Dynamics 365 Business Central API endpoint. Business Central supports several endpoints: Common Service, Web Service, or custom APIs. By default, specifying https://businesscentral.dynamics.com/ resolves to a Common Service Production endpoint unless otherwise set via EndpointType.
Company	Name of your company, exactly as it appears in the API settings. In the API context, this acts as a schema and should be defined. Example: CRONUS International Ltd.
Directory (tenant) ID	Azure Active Directory tenant ID. Found in the overview of the app registration. Example: 72f988bf-86f1-41af-91ab-2d7cd011db47
Authentication Mode	Mode for authenticating to Business Central: OAuth2 – Standard OAuth 2.0 flow. Basic – Username/password authentication (not supported for cloud version).
Callback URL	URL automatically generated by DataSync that must be added in Azure AD.
Client ID	Application (client) ID from the app registration overview. Example: d4a1b6e2-1234-5678-90ab-9d09c9ebfabc
Client Secret	Secret value created in Azure Portal. Example: P@ssw0rdValue123
Username	Account username used for Basic authentication. Example: DOMAIN\user1
Access Key	API access key generated in Business Central for the specified user account. Example: MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC...
Verbosity	1 – Log queries, row counts, execution start/end, errors. 2 – Includes level 1 plus cache queries, HTTP headers. 3 – Includes level 2 plus request/response bodies. 4 – Includes level 3 plus transport-level communication. 5 – Includes level 4 plus all interface commands.
Enable Pooling	Connection pooling option for performance.
Pool idle timeout	Maximum idle time for connections before returning them to the pool, in seconds.
Max Pool Size	Maximum number of connections allowed in the pool.
Pool wait time	Maximum wait time for connection allocation before error is thrown, in seconds.

Common Service endpoints

Common Service endpoints provide access to core business data such as accounts, sales orders, and invoices.

Environment	URL
Production	https://api.businesscentral.dynamics.com/v2.0/{environment name}/api/v2.0 https://api.businesscentral.dynamics.com/v1.0/api/v2.0 https://api.businesscentral.dynamics.com/v2.0/sandbox/api/v2.0
Testing	https://api.businesscentral.dynamics.com/v2.0/{tenant id}/{environment name}/api/v2.0 https://api.businesscentral.dynamics.com/v1.0/{tenant id}/api/v2.0 https://api.businesscentral.dynamics.com/v2.0/{tenant id}/sandbox/api/v2.0

note

Your Tenant ID is the Azure AD directory ID where the Business Central app is hosted. Find it in Azure Portal. Go in Azure Active Directory, then Overview. Environment names can be found at:
https://businesscentral.dynamics.com/{tenant id}/admin

Web Service endpoints

Web Service endpoints include anything custom exposed in Business Central (KPIs, reports, entities, or feeds). To view available Web Services, open Business Central, click the magnifying glass, and search for Web Services.

Environment	URL
Production	https://api.businesscentral.dynamics.com/v1.0/ODataV4/
Testing	https://api.businesscentral.dynamics.com/v1.0/{tenant id}/ODataV4/

Custom API endpoints

To connect to a custom API, set OrganizationUrl to your custom base URL in the following format:
https://api.businesscentral.dynamics.com/v2.0/{tenant}/api/{API publisher}/{API group}/{API version}

Additional connection properties

Additional connection string properties not specified in the Connection Properties panel. For each property added, you can choose Visible or Encrypted. Selecting Encrypted hides the value from the interface and stores it encrypted in the back end, such as when defining passwords.

Property	Value
EndpointType	Endpoint type that the OrganizationUrl resolves to. Possible values: CSProduction – Common Service Production endpoint CSTesting – Common Service Testing endpoint WSProduction – Web Services Production endpoint WSTesting – Web Services Testing endpoint

Advanced settings

Advanced settings control how the MS Dynamics 365 BC connector tracks changes, handles regional and time configuration, and processes data batches during extraction. These options allow fine‑tuning for performance and accuracy, and should be configured according to your system environment and operational requirements.

Setting	Description
Tracking Type	Method for tracking changes: None or Date.
Region	Region setting for the connector, if required by your setup.
Time Zone	Time zone matching the MS Dynamics 365 BC application server.
Time Offset	Refresh offset in seconds to compensate for timing issues in record selection. Minimum value is 0; maximum is 3600 seconds.
Batch Size	Quantity of records processed in each batch during extraction. Larger batch sizes increase memory usage but can improve performance up to a point. The default value is 2000 and the maximum should not exceed 10000 records. Adjust according to your network speed and disk performance; in most cases the default (2000) works best.

Example