As a transitional step, this site will temporarily be made Read-Only from July 8th until the new community launch. During this time, you can still search and read articles and discussions.

While the community is read-only, if you have questions or issues requiring TIBCO review/response, please access the new TIBCO Community and select "Ask A Question."

You will need to register or log in or register to engage in the new community.

Analyzing MongoDB data in TIBCO Spotfire®

Last updated:
12:33am Jul 03, 2017

Overview

There are two ways of accessing MongoDB data from TIBCO Spotfire®.

  • Using the TIBCO ODBC driver for MongoDB that comes with TIBCO Spotfire®.
  • Using TIBCO Spotfire’s MySQL connector.

Using the TIBCO ODBC driver for MongoDB

  1. Download the TIBCO ODBC driver for MongoDB here.
  2. Follow the instructions for how to connect Spotfire to ODBC data sources here.

Connect to MongoDB using Spotfire’s MySQL connector

Your MongoDB Enterprise, 3.2 or later, license includes the MongoDB Connector for BI.

This connector allows you to define a relational table on top of your MongoDB data and expose it as a MySQL compatible data source.

To get started with the MongoDB Connector for BI please see its web page here.

Running the MongoDB Connector for BI as a service

The MongoDB Connector for BI runs as an application process. To allow it to run as a service process and thus serving multiple users and allowing it to, for example, restart automatically on failure, you can wrap it in a service manager like NSSM.

Using TIBCO Spotfire's MySQL connector

Once you have configured the MongoDB Connector for BI, see TIBCO Spotfire’s documentation on how to use the Oracle MySQL connector here.