Platform > Companion tools > Paxata Data Prep > Connect to data sources for Data Prep > MySQL Connector

MySQL Connector for Data Prep¶

User Persona: Data Prep Admin or Data Source Admin

Note

This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.

Configure Data Prep¶

The ability to connect to MySQL is part of the Data Prep JDBC Connector. This topic provides details specific to setting up a connection to MySQL. See also the JDBC Connector Documentation to configure the connection.

Example JDBC URI:¶

jdbc:mysql://yourMysqlSubdomain.yourMysqlDomain.com:yourMysqlPort/yourDatabaseName

Technical Specs¶

Driver Specs¶

MySQL Database driver name & version:
- Driver classname: com.mysql.jdbc.Driver
- Version: mysql-connector-java-5.1.39-bin
Supported IBM DB2 Database versions:
- For supported versions, see: https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-versions.html [dev.mysql.com]

Driver Documentation¶

General Driver Documentation: https://dev.mysql.com/doc/connector-j/5.1/en/ [ibm.com]

MySQL Connector for Data Prep¶

Configure Data Prep¶

Example JDBC URI:¶

Technical Specs¶

Driver Specs¶

Driver Documentation¶

Was this page helpful?

Great! Let us know what you found helpful.

What can we do to improve the content?