This article provides information about configuring MySQL repository connection

To create a new repository connection

Click Options
Click  Plus
Enter connection name
Select type
Enter username and password
Click ODBC manager and create new ODBC DSN
Select newly created DSN
Make sure that connection actually works

MySQL Create

MySQL ODBC settings

MySQL1

MySQL2

MySQL3

MySQL5

MySQL6

MySQL7

Note:
It is recommended to increase max_allowed_packet. The server's default max_allowed_packet value is 1MB. 
You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns).
For example, to set the variable to 16MB, start the server like this: shell> mysqld --max_allowed_packet=16M
You can also use an option file to set max_allowed_packet. For example, to set the size for the server to 16MB,
add the following lines in an option file: [mysqld] max_allowed_packet=16M

Videos

Download Free Trial Learn More About Our ETL Software

We have 111 guests and one member online