Share via

Register multiple CSV and Excel Files

Marc Bastien 1 Reputation point
2020-10-05T12:15:05.057+00:00

Hi, thanks in advance for your help.

We're having a large number of CSV and Excel Files containing (Meta)Data. The metadata information of these files should go into Data Catalog as well. I have found the option to create ODBC Connections to each of them (did not suceed on anyone still), but once this would work, a lot of effort would have to be spent.

First: can anyone share an example how a single file could be registered using ODBC?
This is from my test:
30129-odbc-driver.png

In Register Dialog:
30176-dc-register.png

Result:
30137-dc-result.png

Second: Is there an option, to register files directly?

Thanks a lot!

Azure Data Catalog
Azure Data Catalog

An Azure service that serves as a system of registration and system of discovery for enterprise data assets.

0 comments No comments

1 answer

Sort by: Most helpful
  1. HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
    2020-10-06T20:42:23.967+00:00

    Hello @Marc Bastien ,
    Thanks for the question and also for using this forum.

    As per the document it does not look like that excel and csv file are supported data source from registration tool.
    https://learn.microsoft.com/en-us/azure/data-catalog/data-catalog-dsr.

    You may try out the WEB UI or the API to get this working .

    Thanks
    Himanshu

    Was this answer helpful?


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.