Use this connection to communicate between MongoDB® and Minitab Connect. Unlike relational database connectors such as MySQL
and MSSQL, the Mongo connector stores nested, flexible documents. Because of this, the Mongo
connector looks to the first document in a collection to define the schema.
Set up a new connection
Complete the following steps to set up a connection in Minitab Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Mongo and select the connector from the results.
- Enter a Name that identifies the connection. Under Beacon, specify which beacon you want the connection to go through if you have multiple beacons. Usually, the default works best.
- Under Setup [1 of 2], enter a Hostname, Username, Password, and Port number for the connection.
- Enter the Database from which you want to pull data. Leave this field blank to select the database from a list on the next page. Then select Next.
- Select a Database if you did not specify one on the previous page. Then select Save
.
After you save the connection, Connect displays options to import data into a new table. Start at step 4 of the following section for more information on importing data to create a table.
Create a table with data from a connection
Complete the following steps to import data from Mongo and create a new table in Connect.
- From the Home screen, select the Add button under Tables.
- In Datasets, enter Mongo and select the connector from the results.
- Under Connection, select the Mongo connection that you previously set up. If you have not previously set up a connection, select New Connection and follow the steps in the previous section.
- On the left panel, enter a Name that identifies the table and select a Folder to save the table.
- Select the Collection that contains the data. Then select Next.
- In Fields, enter text to filter the list. Then select the table fields that you want to import and select Next.
- From Query Configuration, select how you want to
filter your fields.
- Basic Filtering
- Select Add Filter and select the field you want to filter. Next, define the filter. Select an expression and a value. For example, suppose you want a list of documents where the meta field contains the text "abc".
- Use the expression, meta, contains, abc. Select the
button on the last selection box to open the SQL dialog box
for more complicated filters. Note
The Mongo connector can only filter top level properties.
- Advanced Options (JSON)
- Select to query MongoDB Collections against specific MongoDB filtering JSON queries. In Filter Array (JSON), enter a JSON array that Connect executes as a MongoDB filter query.
- Select Return BSON objects as JSON to preserve BSON objects in JSON format. Do not select this option if you want Connect to extract the data values directly.
- Select Save
. If you go to the
Prep Tool and select Run
, Minitab Connect
displays the imported data. Note
If no data appears after you select Run, select Reset Config
.
When you save the import, Connect creates a flow with the settings that you selected. For more
information on how to schedule a flow and add more data processes to clean data, go
to Overview of the Flow tool
.
Export a file
Complete the following steps to export data from a Minitab Connect table.
- Open the Outputs tab of the Flow Tool
.
- Select the plus sign
beside
Export to add a new export. - Under Export, select New Export. If you select One Time Download, Connect downloads the file to your computer and does not create an export.
- Enter a Name for the export.
- Under View, select a saved view of the table. If you select None, Connect exports all the data from the table. For more information on saved views, go to Example of creating a data view.
- Under Delivery, select Connection.
- Under Connection, select the connection that you previously set up.
You can specify the file type and file name along with other options. Select Save to add the export to the list of exports in the Outputs tab. Select
Run
to run the export.
