Business Central

Getting Started

Get started by creating a profile and replicate your Business Central instance to your MySQL or SQL Server database.

Follow the Steps below for initial setup guidelines.

Steps to Start DBSync Replication process:

Log in to your DBSync Business Central CRM Replication instance using your credentials.
Get started by clicking on the Add App to create a profile for configuring replication.
Select the option ‘Dynamics365crm’ as shown in the image above
Enter a desired profile name and click Save.
A new profile will now be created.
Click on the profile name.
You will be redirected to set up your Microsoft instance.

Business Central CRM Setup

Enter the endpoint URL of your desired profile
Click on Connect to Business Central CRM for instant web authentication. and the following steps would be witnessed:

A pop-up asking for your Business Central CRM credentials will appear on the screen
Provide the login credential and click Log In
The User Name and Organization ID fields are automatically populated
Click 'test connection' to verify you are connected to the application
Click Save

Configure Database

Click the Database tab from the top navigation toolbar.
Select the type of database to which you wish to replicate the Business Central CRM instance linked in the previous step.
To start with, the database credentials of the user are required such as Host, Port, Username, Password, Database Name, and Schema.
Based on all the details entered by the user, the URL field gets auto-filled.
Click Save
A pop-up confirming the Connection is Saved will appear on the screen
Click Test Connection
A pop-up confirming the connection is established will appear on the screen.
Click Next
You will be redirected to configure Business Central CRM objects

Advance Settings:

This Tab primarily focuses on 3 advanced settings:

Click the checkbox next to download as local files to download into your local system
The URL for download file directory is provided
Click the checkbox next to Keep Multiple Version of Files this will assist in keeping multiple version of the files when downloading (Will rename older version before downloading new ones)

2. Prefix settings:

Include a prefix if required and enter the prefix details in the table below which will get populated into the database.

Sync Business Central CRM objects to database

Ensure you are connected to your Dynamic365 CRM instance
Ensure you have configured the database
Once a user has connected to Business Central CRM then objects will get synced and it will show on the objects tab.
Select any " Business Central CRM objects" to sync into the database objects table section as shown below.

Select the object fields you want to sync into the database from the "Available Fields" section and use the "exclude fields" section to filter out fields you don't want to sync into the database.
Click the RUN button and select the Clean Copy command to get an exact copy of your Business Central CRM-selected objects.
Choose any of the 2 functions to perform:

Run Process

Actions Performed

Clean Copy

Inserts a clean copy of Business Central CRM object records into respective database tables & columns.

Source to DB

Performs incremental sync from Business Central CRM to the database based on the changes/edits made in the Business Central CRM

To set up your instance follow the steps below:

Enter the endpoint URL of your desired profile
Click the blue icon Connect to Business Central CRM
A pop-up asking for your Business Central CRM credentials will appear on the screen
Provide the login credential and click Log In
The User Name and Organization ID fields are automatically populated
Click 'Test Connection' to verify you are connected to the application
Click Next
You will be redirected to configure your Database.

This completes your Source Setup. Proceed to Target Setup

Last updated 3 months ago