Write to NoSQL DB
The Write to NoSQL DB writes the output of a dataflow to a NoSQL
database. The stage supports the MongoDB and Couchbase database types.
Note: Significant
performance improvements can be achieved by using multiple runtime instances of Write to
NoSQLDB. To specify multiple runtime instances, click the Runtime
button.
General Tab
Fields | Description |
---|---|
Connection |
Select the required database connection from the dropdown list. The options displayed are based on the connections defined in Management Console. To add a new connection, see Connecting to NoSQL. To modify an existing connection, select and open it from the list of connections on the Data Sources page of Management Console, make the required updates, and click the Save button. |
Table/View | Specify the name of the collection you want to write to. You can create a new collection in the NoSQL database by entering a collection name in the Table/View drop box and clicking Create. Note: For Couchbase the 'table/view drop
down' and 'create' button is disabled, as we write to a bucket instead of a view. In
addition, the Preview button is also disabled. |
Ignore NULL Values | If this option is enabled, any field that has a NULL value, is ignored. Note: If you do not enable this option, any field that has a NULL value will be also written to the database. |
Preview | Displays the records from the selected table. Note: For MongoDB data sources, clicking
Preview shows the filtered records, if one or more
where clauses have been entered in the Where field.
If no where clause has been entered, the preview displays all the records.Note: For
Couchbase data sources, clicking Preview also displays the added
_id field containing the key. If the record already has an
_id field, then the added _id field overwrites the
pre-existing one at the time of previewing the fields. |
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 write to the database. For more information, see Defining Fields in a NoSQL Database.