Connector Dialog for MongoDB

Enter values into the dialog box to connect and fetch data from your MongoDB data source.

Options

Field

Description

URL

URL to connect to the MongoDB data source.

IP Version

The IP version to apply for the MongoDB connection. Values supported include:

  • Autodetect

  • IPv4

  • IPv6

If IPv6 is selected, the machine in which Monarch is installed should also support IPv6.

Username

A valid User ID required to log-on to the data source.

Password

A valid Password required to log-on to the data source. This password must match the User ID above.

Connect

Click this button after you have specified the URL, Username, and Password. You can select a Database and Collection after you have successfully logged-on.

Database

The name of the database to connect to.

Collection

The table to open.

Table  of Columns

Displays the columns that are generated after you select the Generate Columns button.

Once displayed, you can modify the following:

  • Name

  • JsonPath

  • Type

  • Structure

  • Column Count

  • Enable value

Displaying Array Values

To display the values of an array type column, you need to do the following:

  1. Select Column-Expanded Array from the Structure drop-down.

  2. Set the Column Count value to the number of array values you want to include.

Generate Columns

Instructs the application to query the database for the first few records and attempt to build a table schema from the available information.

Add Column

Adds a new column to the columns indicated in the JSON list box. The necessary information for each column added must be supplied. Ideally, the column is named the same as its JSON path for clarity and uniformity.

Query Options

Allows you to load, and then select, the tables from your database by entering a SQL Statement.

If you already selected Tables and Views, this box is updated to show the corresponding  SELECT * FROM TABLE query.

If you want to define the query, enter the SELECT and/or EXEC statements to execute.

Note:

Currently, only Select and Exec statements are allowed. To minimize security risks and prevent SQL Injection attacks, the following are currently not allowed:

  • Comment characters ( -- )

  • Semi-colons ( ; )

In cases you need to use a series of SQL statements with or without comments, we recommend you use stored procedures to contain these statements. The stored procedure can then be executed from the form.

Refer to http://docs.mongodb.org/manual/tutorial/query-documents/ for more information on the Query Documents feature of the MongoDB Connection dialog.

Preview Data

Click to fetch data using the credentials and criteria you have specified. 10 records are displayed to allow you to verify that you are selecting the correct data.

OK/CANCEL

Select OK to establish the connection and fetch data or Cancel to close the dialog. 

The state of the OK and PREVIEW buttons provides a handy status about the state of your connection:

  • The OK and PREVIEW DATA buttons are enabled as soon as the required fields have been entered and verified. This usually means a connection to the data source has been established and a table has been selected.

  • The OK button is disabled when an update is made that can lead to an invalid result (e.g. the User Name or Password is not valid, or the the SQL statement in the Query tab is invalid). In such cases, use  PREVIEW DATA to validate that data can be retrieved. If this fails verify your connection information or query until data can be retrieved.

 

 

 

© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support