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).
Regards,
Chaitanya Golla
*This post is locked for comments