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.
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.
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.