Connecting MongoDB Atlas BI Connector to Bold BI via ODBC in Linux

Connecting MongoDB Atlas BI Connector to Bold BI via ODBC involves a series of steps. This article will guide you through the process.

Step 1: Install the MongoDB ODBC Driver

The first step is to install the MongoDB ODBC driver. This driver allows Bold BI to connect to your MongoDB Atlas database. You can download the MongoDB ODBC Driver from here based on your deployment.

Once the driver is downloaded, extract it and copy the .so files to /usr/local/lib/

sudo cp libmdbodbcw.so /usr/local/lib
sudo cp libmdbodbca.so /usr/local/lib

Step 2: Configure the ODBC Data Source

Once the driver is installed, you need to configure the ODBC data source. This involves specifying the details of your MongoDB Atlas database, such as the server name, database name, and authentication details.

odbcinst.ini file is a system information file that contains information about ODBC drivers available to all users. Edit this file using an editor and add the below information,

sudo nano /etc/odbcinst.ini

odbc. ini file contains information about DSN’s available to all users. Edit this file using an editor and add the below information,

sudo nano /etc/odbc.ini

Here you should input the SERVER, PORT and DATABASE of your Atlas BI connector and the USER and PASSWORD of your Atlas user. Refer the below image to find the connection details of your cluster.

Refer, Create-system-DSN for available parameters.

Step 3: Test the ODBC Connection

Install unixODBC with your preferred package manager, https://www.mongodb.com/docs/bi-connector/current/tutorial/create-system-dsn/#install-unixodbc

sudo apt-get install unixodbc

Then test the connection, https://www.mongodb.com/docs/bi-connector/current/tutorial/create-system-dsn/#test-with-iusql

iusql -v MongoDBODBCA

On successful connection you should be able to see the below message,

Step 4: Connect Bold BI to the ODBC Data Source

After configuring the ODBC data source, you can connect Bold BI to it. This involves specifying the ODBC data source name in Bold BI ODBC connector and providing any necessary authentication details.

Step 5: Import Data into Bold BI

Once Bold BI is connected to the ODBC data source, you can import data from your MongoDB Atlas database into Bold BI. This involves selecting the tables and fields you want to import and specifying any necessary data transformations.

Step 6: Create Dashboards and Reports

After importing the data, you can use Bold BI’s dashboard and report creation features to visualize and analyze your data.

Conclusion

Connecting MongoDB Atlas BI Connector to Bold BI via ODBC allows you to leverage the powerful data visualization and analysis features of Bold BI with your MongoDB Atlas data. By following these steps, you can easily set up this connection and start creating insightful dashboards and reports.

References

• How to Connect MongoDB Atlas using MongoDB data connector in Bold BI?
• MongoDB Atlas
• ODBC Driver for MongoDB
• MongoDB BI connector installation