How to Install MongoDB Bi Connector on Debian Linux?

MongoDB is a highly scalable and flexible database, which is completely open-source. Technically, speaking it is NoSQL based database that does not rely upon the traditional method of using rows and tables like other databases, it uses documents and collections to manage data. It came around in the mid-2000s and from then on, it has been a popular choice among all data enthusiasts.

Features of MongoDB

1. It contains collections and documents, which makes a very flexible database system.
2. It supports Adhoc queries.
3. It has replica sets that ensure smooth working even if one replica set fails.
4. It can run on multiple servers, thus balancing the excess load.
5. Indexing can be done, to improve the performance of the searches made.
6. It has highly scalable, it can be scaled up or down based on the needs.
7. Data is stored in JSON format which makes it easy to store and retrieve that data.

The MongoDB Bi connector is short for (Business intelligence connector), it uses SQL to help visualize, report and graph MongoDB data taking the help of business intelligence tools such as Tableau and Power BI. The traditional Business intelligence tools take the use of tabular data which is not capable of understanding the sophisticated 3D data of MongoDB, this is where the Bi connector comes in very handy. The Bi connector acts as a bridge between local and hosted instances of MongoDB.

Steps to Install MongoDB Bi Connector

Before installing the bi connector the only prerequisite is to check for OpenSSL on our system, let’s check that first, this is essential for the secure transmission of data by the bi connector.

openssl  version -a

In case OpenSSL Is not installed, get it by using the apt package manager.

sudo apt install openssl

Step 1: Installing Bi connector from the official MongoDB site.

The Bi connector is among the many tools which can be downloaded from the MongoDB website. The link to the site is,

https://www.mongodb.com/try/download/bi-connector

Select your system (Debian in our case) and download the tar file.

Step 2: Extract the tar file. After the download is finished, extract the tar file with the below command:

tar -xvzf mongodb-bi-linux-{arch}-{platform}-{version}.tgz (general command)

tar -xvzf mongodb-bi-linux-x86_64_debian11-v2.14.5.tgz (In our case)

Step 3: Install the programs in the bin directory to a directory located in the system’s path. Now we have to add the directory where our package is installed into the PATH variable of our system. Use the below command:

sudo install -m755 bin/mongo* /usr/local/bin/

Now the Bi connector is installed on the system.