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

Sagar Gopale 0 Reputation points
2024-03-19T09:45:39.9233333+00:00

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?Screenshot 2024-03-19 at 2.55.21 PM
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,653 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 7,315 Reputation points Microsoft Vendor
    2024-03-20T02:36:44.1366667+00:00

    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.