Progress DataDirect’s MySQL ODBC and JDBC Drivers offer a high-performing, secure, and reliable connectivity solution, for ODBC and JDBC applications to access MySQL data. If you want to use our ODBC and JDBC MySQL Driver with the Tableau Desktop application, Progress DataDirect has you covered. This tutorial will teach you how to configure the DataDirect MySQL ODBC and JDBC driver within Tableau Desktop to create reports. These steps can also configure any ODBC and JDBC connection with Tableau.
This tutorial assumes that you have the MySQL ODBC driver installed, and a data source configured. If you have not yet done these steps, please follow these instructions.
1. After the DataDirect MySQL ODBC driver has been installed, open ODBC Administrator to configure the connection and click on “Add”.
2. Choose the “DataDirect X.X MySQL Wire Protocol” and click on “Finish.”
3. The ODBC MySQL Wire Protocol Driver Setup window will pop up.
Enter your credentials, click “Apply” and then “Test Connect.”
4. The Logon dialog will pop up. Provide logon credentials and click on “OK.”
5. A dialog box will confirm that the connection is established.
1. Start Tableau and select the “Other Databases (ODBC)” option.
2. In the pop-up window select the “DSN” radial button, choose the data source previously configured to connect to MySQL in the dropdown, and click on “Connect.”
3. The Logon Dialog will reappear. Enter your password and click on “OK.”
4. The string extras will appear in the designated box. Enter any additional parameters required to connect to your MySQL data source, such as a username and password, and select “Sign In.”
1. After the driver has been downloaded:
2. After you have completed the installation, you can find the Progress DataDirect MySQL jar file.
1. To get started, copy db2.jar from the Progress installation location to Tableau’s driver location.
2. Open Tableau and create a new data source.
The connection string will look something like this:
1. Select “Sign In” and the Tableau configuration screen should now appear.
2. In the database dropdown menu choose the data source.
3. You can use Tableau's schema and table drop-down list to browse and select your data, or you can execute SQL statements by clicking on the "New Custom SQL" option.
4. A popup dialogue box will appear to edit custom SQL.
5. Once Tableau can access your relevant data, you can easily create reports like those shown below: