MySQL
Available when using an authoring Data Collector version 3.22.0 or later.
To create a MySQL connection, the MySQL Binary Log stage library,
streamsets-datacollector-mysql-binlog-lib
, must be installed on the
selected authoring Data Collector.
For a description of the MySQL connection properties, see MySQL Connection Properties.
Engine | Stages |
---|---|
Data Collector 3.22.0 or later | MySQL Binary Log origin |
Transformer 3.19.0 or later | MySQL JDBC Table origin |
MySQL Connection Properties
JDBC Property | Description |
---|---|
JDBC Connection String | JDBC connection string to connect. Use the following
format:
The database name and additional parameters are optional. For example, the following JDBC connection strings are all valid:
|
Use Credentials |
Enables entering credentials on the Credentials tab. Use when you do not include credentials in the JDBC connection string. |
When using credentials, configure the following properties on the Credentials tab:
Credentials Property | Description |
---|---|
Username | MySQL username. The required
permissions and privileges depend on where you intend to use the
connection:
|
Password | MySQL password. Tip: To secure sensitive
information, you can use credential stores or runtime resources.
|