Skip to main content

Notifications

Announcements

No record found.

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

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.

1.Publish.jpg

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.

2.VendGroup.jpg

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

3.PublishJob.jpg

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

4.PublishMsg.jpg

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

5.VendGroupPublish.jpg

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

6.StagingInDB.jpg

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.

7.DataInStaging.jpg

 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). 

8.CompareSourceNames.jpg

Regards,

Chaitanya Golla

Comments

*This post is locked for comments