Notes on MongoDB BI Connector

25 November,2019 by Jack Vamvas

These are my notes on installing the MongoDB BI Connector. 

The MongoDB Connector for Business Intelligence (BI) supports users to generate SQL queries against MongoDB databases. Typical client programs include Qlik,Tableau and Excel 

Details will depend on the overall architecture required. Typically I install MongoDB Connector on a dedicated server - to support wider usage

==Place the executable in /usr/bin
mongodrdl mongosqld mongotranslate

==Place the cfg file in /usr/bin/mongobi
mongosqld.conf

===To start it from the command line
mongosqld --mongo-uri "mongodb://MY_SERVER:27017" --auth --mongo-username MY_USER --mongo-password MY_PASSWORD --mongo-authenticationSource MY_AUTH_DB

===To start mongosqld with a configuration file (see example of basic configuration below )
mongosqld --config <pathToConfigFile>/mongosqld.conf
mongosqld --config /usr/bin/mongobi/mongosqld.conf

===To install and run mongosqld as a system service, run the following commands on RHEL 6 :
sudo mongosqld install --config <path>/mongosqld.conf
sudo service mongosql start
To enable the service so it starts automatically at boot time, run the following :
sudo chkconfig mongosql on

==Alternative to service setup is to add the command line in the /etc/rc.local file
mongosqld --config /usr/bin/mongobi/mongosqld.conf

===Example of configuration file . This example maps to all the collections in a database
systemLog:
logAppend: false
path: "/var/log/mongosqld.log"
verbosity: 2

security:
enabled: true

mongodb:
net:
uri: "MY_MONGODB_SERVER:27017"
auth:
username: "MY_USER"
password: "MY_PASSWORD"
source: "MY_AUTH_DB"
net:
bindIp: SERVER_HOSTING_BI_CONNECTOR
port: 3307

schema:
sample:
namespaces: "DB1.*"


processManagement:
service:
name: mongosqld
displayName: mongosqld
description: "BI Connector SQL proxy server"

 

 

Use this link for the official MongoDB documentation MongoDB Connector for BI 


Author: Jack Vamvas (http://www.dba-ninja.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Notes on MongoDB BI Connector


dba-ninja.com