Reference
No results for 'undefined'
    Powered by Algolia

    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

    Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
    Contents