Navigation

Connect from Spotfire Cloud

This tutorial demonstrates how to connect to MongoDB Connector for BI using Spotfire Cloud.

Prerequisites

Connect from Spotfire Cloud

1

Start the Spotfire Application

2

Add Data Connection

  1. From the File menu, select the Add Data Tables item.

  2. In the Add Data Tables dialog, click the Add dropdown menu in the upper right corner. Select Database at the bottom of the menu.

    Screenshot of the Spotfire Add Data Tables dialog
  3. In the Open Database dialog, select Odbc Data Provider, then click Configure.

    Screenshot of the Spotfire Open Database dialog
  4. In the Configure Data Source Connection dialog, select your DSN from the dropdown menu labelled System or user data source.

    Screenshot of the Spotfire Configure Data dialog
  5. Fill in your MongoDB username and password and click OK.

    Screenshot of the Spotfire Configure Data dialog
  6. The Open Database dialog should now display a connection string for your DSN. Click OK.

    Screenshot of the Spotfire Open Database dialog
3

Specify Tables and Columns

  1. Select the data you would like to work with from the available fields.

    Screenshot of the Spotfire Specify Tables dialog
  2. Give this data connection a name in the Data source name text box.

    Note

    The name you use here is only for the Spotfire application’s use. It does not change the name of your ODBC System DSN.

  3. Click OK.

  4. The Add Data Tables dialog should now list your connection as ready for import.

    Screenshot of the Data Connection Wizard option
  5. Click OK.

You are now ready to add visualizations and analyze your data.