This section contains details for MySQL connections.General information
| Field | Description |
|---|---|
| Data source | MySQL |
| Supported versions | 8.0.30 |
| Connection string | jdbc:mysql:// |
| Packaged? |
|
| Certified? |
|
| Supported features | |
Estimate job |
|
Analyze data |
|
Schedule |
|
| Processing capabilities | |
Pushdown |
|
Spark agent |
|
Yarn agent |
|
Parallel JDBC |
|
| Java Platform version compatibility | |
JDK 8 |
|
JDK 11 |
|
Yes
No
Minimum user permissions
In order to bring your MySQL data into Collibra Data Quality & Observability, you need the following permissions.
- Read access on MySQL tables.
- ROLE_ADMIN assigned to your user in Collibra DQ.
Recommended and required connection properties
| Required | Connection Property | Type | Value |
|---|---|---|---|
| Name | Text | The unique name of your connection. Ensure that there are no spaces in your connection name. |
| Connection URL | String | The connection string path of your MySQL connection. When referring to the example below, replace the value between the { } in the Example |
| Driver Name | String | The driver class name of your MySQL connection.
|
| Port | Integer | The port number to establish a connection to the datasource. The default port is |
| Source Name | String | N/A |
| Target Agent | Option | The Agent that submits your Spark job for processing. |
| Auth Type | Option | The method to authenticate your connection. Note The configuration requirements are different depending on the Auth Type you select. See Authentication for more details on available authentication types. |
| Driver Properties | String | The configurable driver properties for your connection. Multiple properties must be comma delimited. For example, abc=123,test=true |
Authentication
This data source supports the following authentication type:
Username/Password
| Required | Field | Description |
|---|---|---|
| Username | The username of your MySQL account. |
| Password | The password of your MySQL account. |