Read Database

Summary

Reads data from a MySQL or PostgreSQL database. Provide connection details and a query to get data.

Properties

The following table lists the Read Database block properties and describes the input for each property.

Property
Description
HostThe database host name (the location of the server)
PortThe port number on which the database communicates
Database NameThe name of the database instance
UserThe username to connect with
PasswordThe password for the username to connect with
Database VendorThe database vendor MySQL or PostgreSQL
ParametersDatabase-vendor specific key-value parameters (optional). For example, maxRows 5 limits the maximum number of returned rows to 5 (MySQL-specific)
QueryThe SQL query to send. For example, if the input parameter name is "query", enter ${@query[0]}, which means that the SQL query to use is located at the 0th row of the input-parameter frame

Sample MySQL settings

Property
Value
Hostmysql-db.example.com
Port3306
Database Nameemployees
Userroot
Passwordpassword
Database Vendormysql
Parameterskey: maxRows value: 5
Queryselect * from employees where employee_id=${@id[0]}

Sample PostgreSQL settings

Property
Value
Hostpostgresql-db.example.com
Port5432
Database Nameemployees
Userjohn
Passwordpostgres
Database Vendorpostgresql
Parameterskey: connectTimeout value: 5
QuerySELECT * FROM employees WHERE employee_id=${@id[0]}

Sample flow

Contents