ODBC Driver for Microsoft Excel

Build 24.0.8963

Connect from MySQL Workbench

Clients like MySQL Workbench can connect to Excel ODBC data sources as virtual MySQL databases. This section describes how to configure ODBC remoting as a virtual MySQL database in MySQL Workbench.

Configure SQL Gateway

To create a virtual MySQL database in the SQL Gateway administration tool:

  1. Configure and start the proxying service on the Services tab.
  2. Configure database users on the Users tab.
  3. If you need to connect over TLS/SSL, configure it on the Other tab.
  4. Access services hosted behind a firewall by configuring Tunneling.

Connect to the Database

  1. In the main menu, select Database > Connect to Database.
  2. Name the connection. A new dialog displays.
  3. Complete the fields of the dialog:
    • Hostname and Port: The hostname and port of the service. If you are connecting through Tunneling, provide the mapped IP/Port of the tunnel.
    • Username: The username of a user account you created in the SQL Gateway.
When you click Test Connection, you are prompted for your password. If you enabled SSL when you configured the service, you are also prompted to accept the SQL Gateway's digital certificate. You can configure this certificate on the Other tab.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963