Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Export to Data Lake an...
Finance forum
Unanswered

Export to Data Lake and CDMUtil. I am exporting Entities but no files appear under the Entities folder

Posted on by 47

Hi,

I have installed the Export to data lake add-in to a sandbox F&O environment and am exporting tables to the data lake successfully. I have a question about exporting entities to the lake. I can see all of the tables that make up my Entity are being exported to the Lake however I am unable to find any manifest files for the entity itself.

My main goal is to use the CDMUtil to create a view of the Entity in my Synapse serverless database. I thought that I had used the config file in CDMUtil with the entity option but I am unable to see my Vendors V2 entity in the database. Any help would be greatly appreciated.

Many Thanks,

Ravi

  • Waller Walker Profile Picture
    Waller Walker 345 on at
    RE: Export to Data Lake and CDMUtil. I am exporting Entities but no files appear under the Entities folder

    Following on Mariano Gracia's answer, notice that in the folder tree for tables you get CSVs, but for Entities you only get JSON files; these JSON files will contain the Entity SQL VIEW definition from AxDB.

    This happens due to how F&O exports data to the lake; it directly exports the physical tables in its database. This also means that any X++ calculated fields will not be available on the lake; either for tables or Entities (will throw an error if you're using CDMUtil to create the views in Synapse).

  • RE: Export to Data Lake and CDMUtil. I am exporting Entities but no files appear under the Entities folder

    Yes, the cdmutil is able to create a view for the entity, take a look to this tech-talk where they explain this part you're looking for:

    community.dynamics.com/.../export-to-azure-data-lake-overview-december-14-15-2021

  • Data Chappie Profile Picture
    Data Chappie 47 on at
    RE: Export to Data Lake and CDMUtil. I am exporting Entities but no files appear under the Entities folder

    Hi Mariano, thanks for responding. I am aware that the tables are exported and not the Entity but I was hoping that by exporting  the Entity it would also generate a json file that defined the flattened Entity/Table . I thought that the CDMUtil utility was able to create a View for the Entity in the Synapse Serverless SQL database. Or was I mistaken, is this not an available option? Cheers Ravi

  • RE: Export to Data Lake and CDMUtil. I am exporting Entities but no files appear under the Entities folder

    When you select entities to be exported, what the system does is to export the tables related to that entity, so you won't find the VendVendorsV2Entity in the data lake, what you'll find is for example the VendTable and DirPartyTable tables among others

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans