Download the new OpenLink MySQL ODBC Driver version 8.0 Installer Package from our Download Page.
 Download a Free Evaluation License from the same Download Page, or purchase a non-expiring license from our Online Shop.
 Confirm that you have MySQL up and running on Azure, including opening up firewall access for the IP Address used by your ODBC client application.
Azure Dashboard for MySQL — Properties sub-section
Azure Dashboard for MySQL — Connection strings sub-section
Information you need prior to setting up an ODBC connection
Default Database Schema — in this case, it is
Server DNS Name or IP Address — in this case, it is
Database Server Port — in this case, it is
Setting up your ODBC Data Source Name (DSN) using the visual iODBC Administrator User Interface
Here are screenshots that cover the ODBC DSN setup process.
 Launch the
iODBC Administrator.app or
iODBC Administrator64.app (found in
 Assign a Literal Name that distinguishes this ODBC DSN from others.
 Provide Database Server Connection Information.
 Verify settings by making a simple connection to the target Database Server.
 Receive successful connection acknowledgement from Database Server.
 Save the newly created DSN for subsequent use by any ODBC compliant application.
Now that you have configured a DSN that has been confirmed as functional, proceed to making an ODBC connection using the iODBC Demo app (a simple ODBC-compliant application) that’s bundled with the driver installation.
ODBC-Compliant Application Test
 Start the
iODBC Demo Unicode.app or
iODBC Demo.app (found in
 Open a connection to your target Database Server via the Environment menu → Open Connection… .
 Provide your credentials for authentication.
 Choose Execute SQL… from the SQL menu.
 Enter a sample SQL Query.
 View query results.
At this juncture, you have a working MySQL Driver setup and a functioning DSN connecting you to a MySQL instance running in the Azure Cloud.
Microsoft Excel Usage Example
The following steps and associated screenshots walk you through the process of retrieving data into Microsoft Excel (running on macOS) through your newly configured ODBC DSN associated with PostgreSQL running on Microsoft Azure.
 Using the Data menu panel, select the From Databases menu item, and click to commence the ODBC DSN interaction process.
 Select the MySQL DSN associated with your target Database Server.
 The Microsoft Query applet bundled with Excel will now be initialized, en route to presenting you with an interface for query editing and execution. Enter your query, and click the Run button.
 On completion of the query solution production process by the Database Server, you will be presented with a dialog for selecting query solution placement. Hit OK when you’ve selected the preferred spreadsheet location.
 Data is loaded into the selected spreadsheet location.
You have successfully configured an OpenLink ODBC Driver for MySQL on macOS using the very same visual configuration pattern available to Windows users; i.e., you haven’t had to resort to manual configuration of initialization (
INI ) files which should only be necessary on macOS when there isn’t a visual ODBC Driver Administrator available for use — which should never be the case.