Query NoSQL DB

The Query NoSQL DB stage allows lookups of required data from a NoSQL database. The stage supports MongoDB databases.

General Tab

Field Name Description
Connection Select the database connection you want to use.

The available connections are the ones defined in Enterprise Designer, at Tools > NoSQL DB Connection Management.

To create a new database connection, or modify or delete an existing database connection, click Manage. The NoSQL DB Connection Management window opens, the fields in which are:
Connection name
Enter a name for the connection of your choice.
NoSQL database
Select the NoSQL database for which you are creating the connection.
Username
Enter the username to connect to the database.
Password
Enter the password to connect to the database.
Hostname
Specify the hostname on which the database runs.
Port
Specify the port to use to connect to the database.
Database
Specify the database from which the data is to be retrieved.
Table/View Specifies the collection or view in the database that you want to query.
Note: In a MongoDB database, a table/view is called a collection.
Schema File Click the Browse button (...) to select a JSON Schema file. This file is optional. Fields in the fields tab can be regenerated either using the schema file or database table/view.

To clear the selected file path, click Clear.

Note: Fields will always be generated using the schema file if one is selected.
Where Enter the where clause to define the criteria for the lookup.

For a list of the supported operators in the WHERE clause, see http://docs.mongodb.org/manual/reference/operator/query/.
Preview Displays the records from the selected table or view.
Note: Clicking Preview fetches the first 50 records from the selected database, without applying the filter criteria specified in the Where field.
Expand All Expands the items in the preview tree.
Collapse All Collapses the items in the preview tree.

Fields Tab

The Fields tab allows you to select the data that you want to pass to the next stage. For more information, see Defining Fields - Query NoSQL DB.