The CouchDB Input step retrieves all documents from a view in a design document for a specified CouchDB database. The resulting
output is a single string-type field named
JSON. The field contains a row for each received document. See the CouchDB guide for more information on CouchDB, design documents, and views.
When using the CouchDB Input step with the Adaptive Execution Layer, the following factor affects performance and results:
- Spark processes null values differently than the Pentaho engine. You will need to adjust your transformation to successfully process null values according to Spark's processing rules.
Enter the following information in the transformation step fields:
|Specify the unique name of the CouchDB Input step on the canvas. You can customize the name or leave it as the default.
|Host name or IP
|Specify the host name for the connection to your database.
|Specify the port number for the connection to your database.
|Specify the name of the incoming database.
|Identify the source design document. Design documents are a special type of CouchDB document that contains application code. See CouchDB Design Documents for more information.
|Identify the source CouchDB view. See CouchDB Views for more information.
|Specify the username required to access the database.
|Specify the password required to access the database.