Bring Your Own Database(BYOD) in D365FO - Setup

Hi,

BYOD(Bring Your Own Database) is a feature in D365FO that helps us to push the data (either in full or incremental mode) to the external database that is hosted on the cloud. Data export is done with the help of data entities and replica of staging table is created in the target database. In this post, I would discuss the steps involved in the setup and connection enablement with the Azure platform from D365FO.

Step 1: I have a (basic) database by name d365DB hosted in the Azure platform to which I want to push data from D365FO.

Step 2: Navigate to the data management workspace and click on tile "Configure entity export to database".

Step 3: Click on New button to create a new BYOD data source and provide the values for Source name and description. I defined the source name to be ExportDB. Click on the edit button to configure it further.

Step 4: We need to use the ODBC connection details(along with the password) of the target database to establish a connection to it from D365FO. Launch Azure portal (https://portal.azure.com) and select the ODBC connection string of the database(as shown below).

Step 5:  Supply the value in the connection string field and click on validate button to test the connection. If the connection is established we receive info message stating "Tests completed successfully!" 

Step 6: This completes the setup and configuration of BYOD. 

Note: Please don't enable the option "Create clustered column store indexes" as in order to use this feature target database should be of a premium type.

Regards,

Chaitanya Golla