How To Install and Configure the Lite Edition JDBC-to-ODBC Bridge Drivers (macOS)

Pre-Installation Guide

  1. You must have a working ODBC Environment (comprising an ODBC Administrator and Driver Manager) that is compatible with the Single-Tier (Lite Edition) JDBC to ODBC Bridge Driver for ODBC Data Sources.
  2. You must be able to establish an ODBC connection to one or more target databases using third-party or native ODBC drivers that have already been installed.
  3. You must have a Java Runtime Environment (JRE) that is compatible with the Single-Tier (Lite Edition) ODBC Driver for JDBC Data Sources.
    • Generally, the latest JVM from http://java.com/ is the best choice.
    • If using a 64-bit ODBC Driver, you must have a 64-bit JVM.
  4. You must possess third-party or native JDBC drivers that connect to your target database.

Installation Guide

  1. Download and open the Lite Edition (Single-Tier) ODBC Driver for JDBC Data Sources disk image (.dmg) file.
  2. Double-click the .mpkg file to start the installation process.
  3. After the driver has been installed, you will be prompted to locate a license file.
    • If a correctly named file already exists in $OPL_LICENSE_DIR, /Library/Application Support/OpenLink/Licenses/, you will not see this dialog. If the existing file is not valid (evaluation has expired, it's for a different OS, it permits insufficient processor cores, etc.), you will need to manually apply a valid license file after installation is completed.
    • In some environments, this dialog may be hidden by the Installer.app or other windows on your Mac. Please minimize, hide, and/or move windows until you can see and act on this dialog. If you do not answer this dialog, the installation will not complete properly, and the driver will not function as desired.
    • If a license file already exists on the machine, select the 'use existing' option. (Previously generated license files may be re-downloaded from your ODS-Briefcase data space.)
    • If you need to obtain a new trial or permanent license file, select the 'try or buy' option, which will load a relevant web page from which you can obtain a license file.
  4. When the process is complete, you will be told that the software was successfully installed. Click "Close" and the Single-Tier "docs.openlinksw.com/uda/" Edition JDBC Driver for ODBC Data Sources is ready for use.

Configuration Guide

  1. JDBC client applications always require users to provide the Driver Class Name and Connection URL.
    • Driver Class Name -- openlink.jdbc.Driver, openlink.jdbc2.Driver, or openlink.jdbc3.Driver, depending on active JVM. See detailed documentation.
    • Connection URL -- See detailed documentation to construct your local URL, which will be of the form:
      jdbc:openlink://ODBC[/DSN=dsn][/UID=uid][/PWD=pwd][/READONLY=x]
      For example:
      jdbc:openlink://ODBC/DSN=MyOracleDSN/UID=scott/PWD=tiger
      • /DSN -- Local ODBC Data Source Name
      • /UID -- Database Username
      • /PWD -- Database Password
      • /READONLY -- Read-write or read-only session mode. Values are "Y" or "N". Default is "N", and this is the effect if unset; i.e., a read-write connection.
  2. Sometimes the JDBC client applications also require the Driver File Name and/or the path to it. macOS uses /Library/Java/Extensions/ as its default CLASSPATH. All JDBC drivers (or aliases or symbolic links to them) should be installed here, and this is what our installer does. The Driver File Name depends on the active JVM -- opljdbc.jar, opljdbc2.jar, or opljdbc3.jar. See detailed documentation.
  3. No further system configuration should be needed.