Connector Dialog for MongoDB

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

To display the values of an array type column:

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.

Notes:

• To minimize security risks and prevent SQL Injection attacks:

  • Only Select, Exec, and/or With statements are allowed.

  • The following are NOT allowed:

    • Comment characters ( -- )

    • Semi-colons ( ; )

• In cases where 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 connector dialog.

Preview Data

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