How to add DSN to Microsoft Excel to connect to MongoDB database?

Question

I am trying to connect MongoDB database in Excel through BI Connector. Following are the things I have setup.

• Installed BI connector tool.
• Installed iODBC and ODBC drivers for my current MacOS version.
• I have mongsqld running in local. It shows the last log mapped schema for 1 namespace:
• I am able to connect to MongoDB from my local MongoDB Atlas client(for verification if database connectivity is working fine).
• While adding DSN in MS Excel I get options
  1. MongoDB ANSI ODBC 1.4.5
  2. MongoDB Unicode ODBC 1.4.5
• I have tried selecting both options as it is just a matter of performance.
• I have added the variables of SERVER, PORT, DATABASE, UID and PWS in the dialog where we add the DSN.
• Below is the error I am getting. How do I figure out what is wrong?

Answer 1

Hi,

Please check whether the link is helpful to you: https://www.mongodb.com/docs/bi-connector/current/tutorial/create-system-dsn/

Besides, this issue may be related to the file permission of odbcinst.in, you may try the commands in: https://github.com/openlink/iODBC/issues/34 to have a test.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---