Bring Your Own Database(BYOD) in D365FO - Data entity Publish

Chaitanya Golla

17,225

Like ( 0 )

Report

Hi,

In my previous post, I explained about the process involved in setting up the Azure database through BYOD feature. We need to publish data entities for data push. In this post, I want to explain the process to publish the data entity for data push. For the demo purpose, I have selected vendor groups entity.

Step 1: Navigate to the data entity publish page(Path: Data Management workspace > Configure data entity> Publish) and before publishing the entities, mark the checkbox "Show published only" to view the list of published data entities.

Step 2: If the required data entity is not listed, unmark the checkbox "Show published only" and select the Vendor groups entity. Click on publish button.

Step 3: Info message is displayed stating "Publish Job has been scheduled"(as shown below).

Step 4: We receive an info message stating "Successfully published entity Vendor groups to ExportDB".

Step 5: Click on refresh to check the Published status of Vendor groups entity changed to Yes.

Step 6: As the entity is published, we can see that the staging table(VendVendorGroupStaging) is created in the d365DB database(as shown below).

Step 7: Currently only data entity is published but the staging table in the target database does not have data. The same thing can be confirmed by firing a select query on the table. After completing this step, we successfully published the data entity to the target database.

Step 8: Also we can have a side-by-side comparison of staging table definition in D365FO and in the target database by clicking on button Compare source names(on Publish page).