How to Configure a JDBC-ODBC Connection

Starting with version 17, Oxygen XML Developer plugin comes bundled with Java 8, which does not provide built-in access to JDBC-ODBC data sources. To access such sources, you need to find an alternative JDBC-ODBC bridge or use a platform-independent distribution of Oxygen XML Developer plugin along with a Java VM version 7 or 6.

To configure a connection to an ODBC data source, follow these steps:

  1. Open the Preferences dialog box and go to Data Sources.
  2. In the Connections panel, click the New button.

    The dialog box for configuring a database connection is displayed.

    Connection Configuration Dialog Box

  3. Enter a unique name for the connection.
  4. Select JDBC-ODBC Bridge in the Data Source drop-down list.
  5. Enter the connection details.
    1. Enter the URL of the ODBC source.
    2. Enter the user name of the ODBC source.
    3. Enter the password of the ODBC source.
  6. Click the OK button to finish the configuration of the database connection.
  7. To view your connection, go to the Data Source Explorer view (if the view is not displayed, it can be opened from the WindowShow View menu) or switch to the Database Perspective (available from WindowOpen PerspectiveDatabase).

Was this helpful?