Bring Your Own Database(BYOD) in D365FO - Export data

Hi,

In my previous post, I explained about the data entity publishing to the target Azure database. In this post, I will explain about exporting the data from D365FO. For demo purpose, I considered vendor groups entity. 

Step 1:  Before proceeding further we need to confirm whether the intended entity is published or not. In my case vendor groups entity is published.

Also, we need to check the record count and before export to have a picture of data in D365FO.In my case, there are 5 vendor groups.

Step 2: Navigate to the Data management workspace, click on the export tile and create a new data project by selecting the Target data format as ExportDB. I named the data project name to be Vend Group BYOD Export(as shown below).  

Step 3: Click on the export button to initiate the export process and an infolog appears stating "Data export job scheduled. Please refresh the form to view current status". 

Step 3: Once the export is completed, we can see the records being exported(the count is 5) and the status of the operation.

Note: BYOD configured data project exports data (using data entity) only from the legal entity where the data project is fired.

Step 5: We need to query the staging table in the target database to check the authenticity of the data. On querying, staging table seems to have 5 records and thus matching the count.

Step 6: Right now we performed the full push i.e exported all the records from Vendor group table but also we can perform Incremental push i.e if we add (or) delete any records from vendor group table and on triggering the export process BYOD syncs the data and record count in D365FO and in the target database. To illustrate the process, I delete the vendor group 40 and added new vendor group 60(as shown below) in D365FO.

Step 7: Triggered the export process again and now it shows that export happened for only two records.

Step 8: Queried the staging table VendVendGroupStaging created in the target database and could see the data and record count is matching with D365FO.

Likewise, we can export the data from D365FO using BYOD feature for the configured data entity.

Regards,

Chaitanya Golla