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.