How to Configure a JDBC-ODBC Connection

The steps for configuring a connection to an ODBC data source are the following:
  1. Go to menu Preferences > Data Sources.
  2. In the Connections panel click the New button.

    The dialog for configuring a database connection will be displayed.

    The Connection Configuration Dialog

  3. Enter a unique name for the connection.
  4. Select JDBC-ODBC bridge in the Data Source combo box.
  5. Fill-in the connection details.
    1. Fill-in the URL of the ODBC source.
    2. Fill-in the user name of the ODBC source.
    3. Fill-in the password of the ODBC source.
  6. Click the OK button to finish the configuration of the database connection.