<docbook><section><title>SingleTierLiteJDBCInstallMac</title><title> Installation and Configuration of the Single-Tier &quot;docs.openlinksw.com/uda/&quot; Edition JDBC Driver for ODBC Data Sources (a/k/a JDBC-to-ODBC Bridge), for Mac OS X </title> Installation and Configuration of the Single-Tier &quot;docs.openlinksw.com/uda/&quot; Edition JDBC Driver for ODBC Data Sources (a/k/a JDBC-to-ODBC Bridge), for Mac OS X 
<para> <emphasis>Review Preinstallation Documentation:</emphasis>  <ulink url="SingleTierdocs.openlinksw.com/uda/JDBCPreinstallMac">Pre-Installation Requirements</ulink> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> Installation</bridgehead>
<orderedlist spacing="compact"><listitem> The Single-Tier &quot;docs.openlinksw.com/uda/&quot; Edition JDBC Driver for ODBC Data Sources is distributed in a single disk image (<computeroutput>.dmg</computeroutput>) file, which contains a Macintosh Installer package (<computeroutput>.mpkg</computeroutput>).
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Dmgfile.png" /></figure> </listitem>
<listitem> Double-click the <computeroutput>.mpkg</computeroutput> to start the installation process.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_MPKG.png" /></figure> </listitem>
<listitem> You will encounter a warning message that will ask you if you are sure that you want to install the software.
 Click Continue.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Warning.png" /></figure> </listitem>
<listitem> The installer will display a <emphasis>Welcome</emphasis> message.
 Click &quot;Continue.&quot; <figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Welcome.png" /></figure> </listitem>
<listitem> The next screen will display the <emphasis>Read Me</emphasis> file, including any last- minute updates to these documents.
 Please read carefully and click &quot;Continue&quot; when finished.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Readme.png" /></figure> </listitem>
<listitem> The next screen will display the <emphasis>License Agreement</emphasis> for the Single-Tier &quot;docs.openlinksw.com/uda/&quot; Edition JDBC Driver for ODBC Data Sources.
 Please read and click &quot;Continue.&quot; <figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_License.png" /></figure> </listitem>
<listitem> You will be prompted to &quot;Agree&quot; to continue the installation or &quot;Disagree&quot; to abort.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Agree.png" /></figure> </listitem>
<listitem> You will be asked to select a Destination Volume.
 Generally, this should be your Mac OS X boot volume.
 Click on the desired disk icon and then click &quot;Continue.&quot; <figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Destination.png" /></figure> </listitem>
<listitem> You may now choose the Easy Install, or if you are an experienced user, you may Customize which components are installed.
 We generally recommend the Easy Install.
</listitem>
<listitem> If you have installed OpenLink or iODBC components in the past, click &quot;Upgrade&quot; to continue.
 Otherwise, click &quot;Install.&quot; <figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Easyinstall.png" /></figure> </listitem>
<listitem> If you chose the custom option, select which of the listed components to install.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Custominstall.png" /></figure> </listitem>
<listitem> You must have an Administration username and password to install this driver.
 Enter your Mac OS X Username and Password.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Authenticate.png" /></figure> </listitem>
<listitem> You will be shown a graphical progress bar as the Installation progresses, followed by System Optimization.
</listitem>
<listitem> You will need to locate the license file.
 Click &quot;Try or Buy License&quot; to obtain evaluation or commercial licenses from our Web site.
 Click &quot;Use Existing License&quot; to select a license on the local file system.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/Selectlicense.png" /></figure> </listitem>
<listitem> When the process is complete, you will be told that the software was successfully installed.
 Click &quot;Close&quot; and the Single-Tier &quot;docs.openlinksw.com/uda/&quot; Edition JDBC Driver for ODBC Data Sources is ready for use.
<figure><graphic fileref="SingleTierLiteJDBCInstallMac/JDBC1_Success.png" /></figure></listitem>
</orderedlist><bridgehead class="http://www.w3.org/1999/xhtml:h2"> Configuration </bridgehead>
<para>JDBC client applications always require users to provide the Driver Class Name and Connection URL.</para><itemizedlist mark="bullet" spacing="compact"><listitem> <emphasis>Driver Class Name</emphasis> -- <computeroutput>openlink.jdbc.Driver</computeroutput>, <computeroutput>openlink.jdbc2.Driver</computeroutput>, or <computeroutput>openlink.jdbc3.Driver</computeroutput>, depending on active JVM.
 See <ulink url="http://docs.openlinksw.com/uda/st/opljava.html">detailed documentation</ulink>.
</listitem>
<listitem> <emphasis>Connection URL</emphasis> -- See <ulink url="JDBC1ConnectionURLFormat">detailed documentation</ulink> to construct your local URL, which will be of the form -- <programlisting>jdbc:openlink://ODBC[/DSN=dsn][/UID=uid][/PWD=pwd][/READONLY=x]
</programlisting>For example, <programlisting>jdbc:openlink://ODBC/DSN=MyOracleDSN/UID=scott/PWD=tiger
</programlisting><itemizedlist mark="bullet" spacing="compact"><listitem> <emphasis>/DSN</emphasis> -- Local ODBC Data Source Name </listitem>
<listitem> <emphasis>/UID</emphasis> -- Database Username </listitem>
<listitem> <emphasis>/PWD</emphasis> -- Database Password </listitem>
<listitem> <emphasis>/READONLY</emphasis> -- Read-write or read-only session mode.
 Values are &quot;Y&quot; or &quot;N&quot;.
 Default is &quot;N&quot;, and this is the effect if unset; i.e., a read-write connection.</listitem>
</itemizedlist></listitem>
</itemizedlist><para>Sometimes the JDBC client applications also requires the Driver File Name and/or the path to it.
 Mac OS X uses <computeroutput>/Library/Java/Extensions/</computeroutput> as its default <computeroutput>CLASSPATH</computeroutput>.
 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 -- <computeroutput>opljdbc.jar</computeroutput>, <computeroutput>opljdbc2.jar</computeroutput>, or <computeroutput>opljdbc3.jar</computeroutput>.
 See <ulink url="http://docs.openlinksw.com/st/opljava.html">detailed documentation</ulink>.</para><para>No further system configuration should be needed.</para><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2"> Next...
 </bridgehead>
<para>Should you decide to purchase a commercial license at the end of your evaluation period, be sure to consult our documentation which explains the placement and uptake of commercial license files and the use of our <emphasis>OpenLink License Manager</emphasis> technology: <ulink url="http://wiki.usnet.private/dataspace/dav/wiki/UdaWikiWeb/UDALicenseApplication">License Technology &amp; Application</ulink>.</para></section></docbook>