ADF Copy Dataverse tables to csv - generate table column metadata

HSever 136 Reputation points
2022-05-06T03:17:49.663+00:00

I need to export few tables from Dataverse-Oracle. For this, I plan to run ADF copy data for each Dataverse table to csv(in blob storage), another team import to Oracle since no connection between the source-destination databases.
Requirement is to generate source table metadata, to make it simple for team importing data to create tables on destination database). Is there a way to generate source table metadata from ADF? Or I can only script table metadata from Dataverse? Or there is another functionality in ADF (eg: using data flow instead of copy data) that will allow to script source table metadata?

Thank you for your input!!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,084 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2022-05-09T09:53:36.12+00:00

    Hi @HSever ,

    Thank you for posting query in Microsoft Q&A Platform.

    If you I understand you query better, then you are trying to look for a way to get dataverse table metadata. If correct me if I am wrong.

    Usually GetMetadata activity helps to get get Meta data information. But for Dataverse tables at this moment GetMetaData activity will not support. Clik here to know about support activities for Dataverse.

    You can consider making API call to query table definitions in Dataverse. Click here to more about API. In ADF, we can use Web activity to make this API calls. Click here to know more about web activity. Also consider checking this video for web activity.

    Hope this helps. Please let us know if any queries. Thank you.

    ------------

    Please consider hitting Accept Answer. Accepted answers help community as well.