Imports data from a MySQL database. import-from-mysql

This adaptor allows users to set up a connection to a database, set a query, and extract data from the database into a Data-flo datatable.



hostname: The hostname (.e.g localhost) or the IP address (e.g. "") of the database server.

port: The port of the database server. If unspecified, defaults to 3306.

database: The name of the database.

username: The username to connect to the database.

password: The password to connect to the database. TIP: when binding, consider treating the value as secret.

query: The SQL query reading from the database (e.g. "SELECT * from table WHERE ...").


data: A datatable containing the imported data

Last updated