Hello anonymous user,
Welcome to Microsoft Q&A platform.
From the error message ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
, it looks like the connection details are incorrect.
ODBC Database connection properties looks like below (In this example I’m connecting Azure SQL database via ODBC connection).
From Azure portal, you can get the ODBC connection string which contains all the details which you need to fill in the ODBC Database in Azure Data Catalog.
Steps to register a data source in Azure Data Catalog:
Step1: Go to the Azure Data Catalog home page and select Publish Data.
Step2: Select Launch Application to download, install, and run the registration tool on your computer.
Step3: On the Welcome page, select Sign in and enter your credentials.
Step4: On the Microsoft Azure Data Catalog page, select ODBC Database and Next.
Step5: Enter the ODBC Database connection properties for your database sample in Azure SQL Database and select CONNECT.
Driver: ODBC Driver 13 for SQL Server
Connection String: Server=tcp:chepra.database.windows.net,1433
Database: chepra
User: chepra
Password: {your_password_here}
Step6: Register the metadata of your data asset. In this example, you register Customers objects from the sample namespace:
You had registered objects from the database sample for Azure SQL Database so that they can be easily discovered by users across your organization.
Reference: Tutorial: Register data assets in Azure Data Catalog
Hope this helps. Do let us know if you any further queries.
----------------------------------------------------------------------------------------
Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.