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 database connection you want to use. Your choices vary depending on what connections are defined in the NoSQL Connection Management in the Tools menu of Enterprise Designer. If you want to make a new database connection, or modify or delete an existing database connection, click Manage. Connection name Enter a name for the connection. The name can be anything you choose. NoSQL database Select the appropriate database type. Username Enter the username to connect to the database. Note: For Couchbase, username is not mandatory. You can enter any username. The connection will be successful as long as you use the correct password that you supplied when creating the bucket. 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. Note: While the term Database is used in the user interface, Couchbase calls it a bucket.
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 Table. Note: For Couchbase the 'table/view drop down' and 'create table' 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.