< Previous | Next >

Connecting to the Optim sample database

Optim™ Designer provides wizards that make it easy for you to connect to databases and to display the status of your connections. In this exercise, you will create a connection to the Optim sample database.

Note: This tutorial uses the Optim sample database included with your Optim installation. For more information about installing the Optim sample database, refer to the IBM® InfoSphere® Optim for DB2® for z/OS® Customization Guide.

You can use the pages in the New Connection wizard to create a connection profile, so that you can connect to a database.

You will use the sample database to define physical and logical data models upon which Optim processes are based.

To connect to the sample database:

  1. In the Data Source Explorer view, right-click the Database Connections folder, and click New Connection. The New Connection wizard opens.
  2. On the Connection Parameters page, select a DBMS, a JDBC driver, and specify other connection details.
    1. In the Connection identification area, specify a connection name. The connection name is displayed in the Data Source Explorer after you create the connection.
      Use default naming convention
      Specifies that a connection name is generated based on the name of the database that you are connecting to.
      Connection name
      Type a name for the connection. Available only if Use default naming convention is not checked.
    2. In the Local tab, select the DBMS for your database.
    3. Select a driver in the JDBC driver list.

      If a driver that you want to use is not listed, but it is supported by the database manager, select Other Driver Default and provide the details.

      To modify the path to the JAR files for a JDBC driver, click the browse button (...) to open the Edit JAR List window. You can also use this window to view the names and typical locations for JDBC JAR files for each listed driver.

    4. In the Properties area, enter connection information for your database, based on the selected DBMS.
  3. Click Test Connection to verify the connection.
  4. Click OK to save the connection profile.
  5. Right-click the database connection profile and click Connect.

The connection definition will display the database type, and open to display the database.

sample database connection

< Previous | Next >