Connect MongoDB using Oracle MySQL Connector in TIBCO Spotfire
Article ID: KB0075521
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 10.3 and Higher |
Description
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.
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.
Issue/Introduction
This article describes the configuration changes required to connect MongoDB using Oracle MySQL connector in TIBCO Spotfire.
Resolution
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
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
Additional Information
Doc: Connector for Oracle MySQL
Wiki: Analyze Data using MongoDB
External: MongoDB Connector mongosqld process for BI
External: 'mongosqld' process
External: Atlas connection
Feedback
Yes
No
Powered by
