We want to create Lake database entity tables using Synapse Industry Database Templates and map from D365 F&O Dataverse tables created using synapse link for Dataverse.

Suraj Surendran 60 Reputation points
2024-05-24T06:41:34.3933333+00:00

Using Azure synapse link , Table's where created from D365 data. How to create data entity views for the same

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,555 questions
{count} votes

Accepted answer
  1. Harishga 4,880 Reputation points Microsoft Vendor
    2024-05-27T05:23:54.8266667+00:00

    Hi @Suraj Surendran

    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    To create data entity views for tables that were created from D365 data using Azure Synapse Link for Dataverse, you need to connect Dataverse to Synapse Workspace using Azure Synapse Link.

    Once you have connected Dataverse to Synapse Workspace, you can manage the Dataverse tables included in the Azure Synapse Link. In your Azure Synapse workspace, create a user-defined schema within Synapse SQL. This schema will be used to store the views that you will create.

    Finally, run a Create View Script to specify a view name, column names, Dataverse database name under the new schema, and the exported table name to create your view. This will allow you to create data entity views for the tables that were created from D365 data using Azure Synapse Link for Dataverse.

    To use Synapse Industry Database Templates to create Lake database entity tables, you need to access Synapse Workspace from your Azure Synapse Analytics workspace, select the Knowledge center, and then Browse gallery.

    Choose the industry-specific database template that suits your needs, such as Retail, Finance, and Healthcare. Navigate to the database canvas to explore the tables available in the template.

    You can use the tools provided on the canvas to add tables to your lake database and configure it according to your requirements.

    These steps will help you through the process of creating views for your Dataverse tables in Azure Synapse Analytics and utilizing database templates to create a structured lake database.

    For detailed instructions and prerequisites, refer to the official Microsoft documentation provided in the links.
    https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-create-view
    https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-synapse

    https://learn.microsoft.com/en-us/azure/synapse-analytics/database-designer/create-lake-database-from-lake-database-templates

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments No comments

0 additional answers

Sort by: Most helpful