The MongoDB BI Connector enables us to create SQL queries for MongoDB data. Relational BI solutions such as Tableau, MicroStrategy, and Qlik may be used to view and report on our MongoDB Enterprise data. The BI connector acts as a bridge between a MongoDB reporting tool and an instance, converting queries and data. It contains no SQL data and links our MongoDB cluster to business intelligence tools.
Installing BI Connector on Windows
Step 1: To begin, go to https://www.mongodb.com/download-center and download the MongoDB connector for BI.
Step 2: Now, run the MongoDB BI connector.msi file that you downloaded. To install the files, follow the installation prompts.
Step 3: Accept the License Agreement and click Next.
Step 4: Select the location where you want to install the BI Connector. If you don’t have a reason to modify it, leave it alone and click Next.
Step 5: Click on the Install button.
Now you can run the BI Connector.