Query NoSQL DB
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 .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:
|
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 |
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.