Creating an Oracle Connection Profile

A connection profile contains the connection property information needed to connect to a Oracle database in your enterprise.

Prerequisites
Before creating the connection profile, copy your Oracle JAR file (for example, ojdbc14.jar) to:

<SUP-Install-Path>\Unwired_Work-Space\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_1.5.2.<plugin version number>\lib

Task
  1. In Enterprise Explorer, right-click Database connections and select New.
  2. Select Oracle as the connection profile type, and click Next.
  3. Select the New driver definition icon adjacent to the Drivers field.
  4. From the driver templates choose Oracle Thin Driver.
  5. From the Jar list tab, click Edit Jar/zip and verify that ojdbc14.jar points to<SUP-Install-Path>\Unwired_Work-Space\Eclipse\sybase_workspace\mobile\eclipse\plugins\com.sybase.uep.com.oracle_1.5.2.<plugin version number>\lib
  6. Click Yes (from the Update all Jars to use same path prompt), then OK on the previous screen (Edit driver definition).
  7. Complete the following information.
    Specify Oracle database connection details page
    Field Description
    SID The Oracle System ID (SID) used to identify the Oracle database.
    Host The host name on which the database resides.
    Port number The port to which you are connecting. For example, 1521.
    User Name Enter the name for the database login.
    Password Enter the password for the database login, if required.
    Save Password Select the checkbox to save the password.
    Connection URL Read-only details specifying the connection URL.
    Catalog Select the catalog which allows the user to obtain information about the database.
    Connect when the wizard completes Select this option to connect to the database upon exiting the wizard.
    Connect every time the workbench is started Select this option if you want Unwired WorkSpace to connect automatically to the database (when it is started) and display its contents in Enterprise Explorer.
    Test connection Click Test connection to ping the database and to verify that the connection profile is working.
  8. Click Next to see the summary page, or Finish to create the connection profile.

    The connection profile displays under Database connections in Enterprise Explorer.