Connect MongoDB using Oracle MySQL Connector in TIBCO Spotfire

Connect MongoDB using Oracle MySQL Connector in TIBCO Spotfire

In order to connect MongoDB using Oracle MySQL connector, MongoDB connector for BI needs to be installed. More details on download and installation can be known from MongoDB docs
Using MongoDB connector for BI, you can only connect to a process called 'mongodbsqld' which accepts incoming requests from TIBCO Spotfire client and proxies those requests to a MongoDB server i.e mongod process. Assuming MongoDB server is already running, below are the complete steps in case of a on-premise MongoDB server:

1) Download and install MongoDB ODBC driver for BI connector on machine where Spotfire client is installed

2) Download and install MongoDB Connector for BI which contains mongosqld process in the installation folder.

3) Run mongosqld process present under <MongoDB connector for BI install folder>\Connector for BI\<version>\bin as administrator. By default mongosqld process assumes that MongoDB server is running on same machine as that process is running i.e it tries to connect to MongoDB server on 127.0.0.1:27017. And mongosqld by default listens on 127.0.0.1:3307 for clients like Spotfire to connect.

If 'mongosqld', MongoDB instance(mongod process), Spotfire client are all running on different machines, use following command in command prompt to start mongosqld process:

mongosqld --mongo-uri mongodb://<ip_of_mongodb_server>:<mongodb_port> --addr <ip_of_machine_where_mongosqld_is_running>:<port_clients_should_connect_on>

eg: mongosqld --mongo-uri mongodb://10.97.37.130:27017 --addr 10.107.165.56:3307

4) Now launch TBCO Spotfire Analyst, Connect To -> Oracle MySQL -> Enter server ip -> select MongoDB connector for BI from Database system drop down -> Enter other required details and connect.

Note: Server must be the IP or servername of the machine where mongosqld is running and include port. Based on the example in step (3), server will be 10.107.165.56:3307

If you are using MongoDB atlas i.e if it is hosted, port might differ, more details to connect to Atlas can be found here Doc: Connector for Oracle MySQL

• https://docs.tibco.com/pub/spotfire/general/drivers/index.htm?&_ga=2.67753045.597147800.1585764327-1040135310.1578077470#t=data_sources%2Fconnector_oracle_mysql.htm%23bc-6&rhtocid=_2_39

Wiki: Analyze Data using MongoDB

• https://community.tibco.com/wiki/analyzing-mongodb-data-tibco-spotfire

External: MongoDB Connector mongosqld process for BI

• https://docs.mongodb.com/bi-connector/current/

External: 'mongosqld' process

• https://docs.mongodb.com/bi-connector/master/reference/mongosqld/#bin.mongosqld

External: Atlas connection

• https://docs.atlas.mongodb.com/connect-to-cluster/#connect-to-your-cluster