Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use this connection to access data in MySQL Batch Source and MySQL Sink.

Configuration

Property

Macro Enabled?

Description

Name

No

Required. Name of the connection. Connection names must be unique in a namespace.

Description

No

Optional. Description of the connection. Connection names can only include letters, numbers, underscores, and hyphens.

JDBC Driver Name

No

Required. Select the JDBC driver name to use.

Host

Yes

Required. Host name or IP address of the database server to connect to.

Default is localhost.

Port

Yes

Required. Port number of the database server to connect to. 

Default is 3306.

Username

Yes

User identity for connecting to the specified database. Required for databases that need authentication. Optional for databases that do not require authentication.

Password

Yes

Password to use to connect to the specified database.

Connection Arguments

Yes

Optional. A list of arbitrary string tag/value pairs as connection arguments. These arguments will be passed to the JDBC driver, as connection arguments, for JDBC drivers that may need additional configurations. This is a semicolon-separated list of key-value pairs, where each pair is separated by a equals ‘=’ and specifies the key and value for the argument. For example, ‘key1=value1;key2=value’ specifies that the connection will be given arguments ‘key1’ mapped to ‘value1’ and the argument ‘key2’ mapped to ‘value2’.

...