MySQL Connection


Connection to a MySQL Server.

Main Settings


The host name (DNS name) or the IP address of the server on which the database is located.


The TCP/IP port number used by the database.

User Name:

User name for the connection to the database.


Password for the connection to the database.


Name, schema, or instance of the relational database.

Advanced Settings:
Fetch Mode:

For a MySQL database, you can adjust the fetch mode as follows:

  • Buffered (default): the query result is returned with buffering. In this case, no parallel queries to the same MySQL Server are possible.
  • Full: MySQL returns the query result in one block. This is potentially slower, with higher memory consumption. It should only be set if the connection is used in several components that are processed in parallel during a load, e.g. several MySQL extracts that are joined in a transform, an extract, and a load on the same MySQL connection or when using parallel jobs.

Additional JDBC parameters can be set in advanced settings.

Note: in MySQL Server, the timeout parameter (wait_timeout) has to be set sufficiently high to avoid errors during the execution of long-running jobs (e.g. “Communications link failure” error).