Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at docs.hitachivantara.com

 

Hitachi Vantara Lumada and Pentaho Documentation

CouchDB Input

Parent article

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.

AEL Considerations

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.

Options

Enter the following information in the transformation step fields:

OptionDescription
Step NameSpecify 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 IPSpecify the host name for the connection to your database.
PortSpecify the port number for the connection to your database.
DatabaseSpecify the name of the incoming database.
Design documentIdentify the source design document. Design documents are a special type of CouchDB document that contains application code. See CouchDB Design Documents for more information.
View nameIdentify the source CouchDB view. See CouchDB Views for more information.
Authentication userSpecify the username required to access the database.
Authentication passwordSpecify the password required to access the database.

Metadata injection support

All fields of this step support metadata injection. You can use this step with ETL metadata injection to pass metadata to your transformation at runtime.