Write to NoSQL DB
The Write to NoSQL DB writes the output of a dataflow to a NoSQL
database. The stage supports MongoDB and Couchbase database (version 5.x and
above).
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 Spectrum 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 Connections page of Spectrum 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.