My client would like some help setting up a MySQL query. However, he's running into a dialog box that prompts him to install the MySQL client. Does this need to be installed locally or on the machine that hosts Workflow? Additionally, is there any kind of documentation that details how to implement a MySQL database?
Question
Question
MySQL Queries
Answer
To start, please download and install the version 3.51.30 MySQL ODBC driver located athttp://dev.mysql.com/downloads/connector/odbc/5.1.html#downloads; be sure to select 3.51.30 from the “Select Version” dropdown on that page.
Once the 3.51.30 driver is installed on the Workflow server, open the ODBC Data Source Admin and add the data source under the “System DSN” tab, making sure to use the 3.51 version:
In the Workflow Designer, select your Query Data activity, go to the Properties pane on the right, and then select “Manage Data Sources…” from the dropdown under Data Source.
Click “Add” on the following menu.
In the Configure Data Source Wizard, choose “Windows ODBC”.
On the next menu, select the data source driver that you configured earlier from the dropdown and hit next.
On the final menu, choose Server Authentication, enter the appropriate MySQL username and password, and click finish. With this done, you should be able to go back to your Query Data activity and select your new data source from the Data Source dropdown. All your tables should then appear under Query Criteria.