Skip to main content

MS Dynamics 365 BC Source Connector

The MS Dynamics 365 BC source connector lets DataSync retrieve business data from Microsoft Dynamics 365 Business Central using its available API endpoints and load it into your data warehouse. Setup involves two parts that reference each other: you register an app in the Azure Portal grant DataSync access, then create a source connection in DataSync using the credentials from that app. It helps to keep both the Azure Portal and DataSync open side by side while you work through the steps.

DataSync supports two authentication modes for this connector: OAuth 2.0 and Basic. OAuth 2.0 is recommended and required for cloud deployments.

After creating all required source connections, configure your destination connection to finalize the setup.

Step 1: Set up access in Azure and Business Central​

Assign user permissions​

  1. Log in to Dynamic 365 Business Central.
  2. Select the magnifying glass in the upper‑right corner.
  3. Search for Users.
  4. Select Users under Administration.
  5. Select the user account you want to use for the DataSync connection.
  6. In User Permission Sets, assign the permissions 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. Search for App registrations and select it.
  4. Click New registration.
  5. Enter a name for the application and select the supported account types.
  6. (Optional) Add a redirect URL.
  7. Return to the App registrations page and select your new registration.
  8. In the left navigation pane, select API permissions and add the permissions your application needs.
  9. Grant admin consent if required.
  10. In the left navigation pane, select Certificates & secrets and create a new client secret.
important

The secret value is shown only once. Copy and store it securely before leaving the page.

Step 2: Create the source connection in DataSync​

Set up the connection​

  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. Enter all required connection properties.
  6. Copy the Callback URL from the Connection Properties panel.

Add the callback URL in Azure Portal​

  1. Log in to the Azure Portal.
  2. Under Azure services, select More services.
  3. Search for App registrations.
  4. Select your app and select Authentication in the navigation pane.
  5. Add a Web platform configuration and paste the Callback URL.
  6. Click Save.

Authenticate and authorize​

  1. (Optional) In the Additional Connection Properties panel, click Add property and enter any extra parameters you need.
  2. Configure the advanced settings to match your environment, including Tracking Type.
  3. Click Save. You will be redirected to the Microsoft sign-in screen.
  4. Log in to complete authentication.

Connection properties​

PropertyWhat to enter
DescriptionUnique name for the connection. Example: MS Dynamics 365 BC
Organization URLAPI endpoint URL for Business Central. By default, specifying https://businesscentral.dynamics.com/ resolves to a Common Service Production endpoint unless otherwise set via EndpointType.
CompanyName of your company exactly as it appears in the API settings. Example: CRONUS International Ltd.
Directory (tenant) IDAzure Active Directory tenant ID. Found in the overview of the app registration in Azure Portal. Example: 72f988bf-86f1-41af-91ab-2d7cd011db47
Authentication ModeOAuth2 for standard OAuth 2.0 flow (Required for cloud deployments) or Basic for username and password authentication.
Callback URLOAuth only URL automatically generated by DataSync. Must be added to your app registration in Azure Portal.
Client IDOAuth only Application client ID from the app registration overview in Azure Portal. Example: d4a1b6e2-1234-5678-90ab-9d09c9ebfabc
Client SecretOAuth only Secret value created in the Azure Portal. Example: P@ssw0rdValue123
UsernameBasic only Login account. Example: DOMAIN\user1
Access KeyBasic only API access key generated in Business Central for the specified user account. Example: MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC
VerbosityControls how much detail the connector writes to the log. Each level includes everything from the level below it, plus additional detail.

  • 1 logs queries, row counts, execution start and end times, and errors.
  • 2 adds cache queries and HTTP headers.
  • 3 adds request and response bodies.
  • 4 adds transport-level communication.
  • 5 adds all interface commands.
Enable PoolingEnables connection pooling, which keeps a set of database connections open and reuses them across extractions instead of opening a new connection each time. This reduces overhead and improves performance when multiple extractions run at the same time.
Pool idle timeoutTime in seconds a connection can stay idle before returning to the pool.
Max Pool SizeMaximum number of connections allowed in the pool at the same time.
Pool wait timeTime in seconds DataSync waits for an available connection before throwing an error.

Endpoint types​

The Organization URL you enter depends on the type of endpoint you want to connect to. Select the tab that matches your setup.

Common Service​

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

EnvironmentURL
Productionhttps://api.businesscentral.dynamics.com/v2.0/{environment name}/api/v2.0
Productionhttps://api.businesscentral.dynamics.com/v1.0/api/v2.0
Production (sandbox)https://api.businesscentral.dynamics.com/v2.0/sandbox/api/v2.0
Testinghttps://api.businesscentral.dynamics.com/v2.0/{tenant id}/{environment name}/api/v2.0
Testinghttps://api.businesscentral.dynamics.com/v1.0/{tenant id}/api/v2.0
Testing (sandbox)https://api.businesscentral.dynamics.com/v2.0/{tenant id}/sandbox/api/v2.0
note

Your Tenant ID is the Azure AD directory ID where Business Central is hosted. Find it in the Azure Portal under Azure Active Directory then Overview. Environment names are available at https://businesscentral.dynamics.com/{tenant id}/admin.

Additional connection properties​

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

PropertyWhat to enter
EndpointTypeEndpoint 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​

These settings control how the connector tracks data changes, handles time and regional configuration, and processes records during extraction. Configure them to match your MS Dynamics 365 BC environment so that results stay accurate and consistent.

SettingWhat to select
Tracking TypeMethod for tracking data changes: None or Date.
RegionRegion setting for the connector, if required by your setup.
Time ZoneTime zone matching your MS Dynamics 365 BC environment.
Time OffsetRefresh offset in seconds to compensate for timing issues in record selection. Minimum 0, maximum 3600.
Batch SizeNumber of records processed per batch during extraction. Larger batches can improve performance but use more memory. Default is 2000, maximum is 10000. Adjust based on your network speed and disk performance. The default works well in most cases.

Basic authentication example setup​

MS Dynamics 365 BC Basic authentication source connection in DataSync
Completed MS Dynamics 365 BC source connection in DataSync using Basic authentication, with all properties and settings filled in.

OAuth authentication example setup​

MS Dynamics 365 BC OAuth authentication source connection in DataSync
Completed MS Dynamics 365 BC source connection in DataSync using OAuth 2.0 authentication, with all properties and settings filled in.