New OCBC connection in Azure Data Catalog

Question

I have a working ODBC connection to Oracle DB in my laptop and trying to configure the same into Azure Data Catalog. ODBC connection is defined as System DSN in ODBC configuration. I have not found any good documentation what to fill in the necessary fields Driver, Connection String, Database, (User & Password are known...)

When trying to guess right values for those fields and after pressing Connect button I'm only getting error message:
Connection test failed

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

How this should work and have I missed something?

JS

Answer 1

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.

Answer 2

From TNSNAMES.ORA: # MYDB environment MYDB.world = (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=OFF)(FAILOVER=ON) (ADDRESS=(PROTOCOL=tcp)(HOST=mydbserver1.mydomain.com)(PORT=1521)) (ADDRESS=(PROTOCOL=tcp)(HOST=mydbserver2.mydomain.com)(PORT=1521)) ) (CONNECT_DATA= (SERVICE_NAME= mydbenv_service.world)) ) ![28235-image.png][1] ![28295-image.png][2] ![28198-image.png][3] ![28210-image.png][4] [1]: /api/attachments/28235-image.png?platform=QnA [2]: /api/attachments/28295-image.png?platform=QnA [3]: /api/attachments/28198-image.png?platform=QnA [4]: /api/attachments/28210-image.png?platform=QnA