Creating database profiles

This topic describes how to create database profiles.

1. In one of the Intelligent Miner® Visualizers, for example, the Classification Visualizer, click File => Open... to display the Open a New Model window.
2. On the Database page of the Open a New Model window, select the Use a profile radio button and click New to display the Add New Database Profile window.
   The following figure shows the Add New Database Profile window.

   

3. On the Add New Database Profile window, follow these steps:
   1. Type a name for the database connection profile in the Profile name entry field, for example, Model-Db2-Table1.
   2. The JDBC driver entry field displays the Java™ class name of the universal Db2 driver. It is com.ibm.db2.jcc.DB2Driver.

      If you want to use a different JDBC driver, overwrite the entry with the name of the JDBC driver of the database that you want to use, or select another JDBC driver from the drop-down list. For example, if you want to use the JDBC type 2 driver, you must type com.ibm.db2.jdb.app.DB2Driver in the JDBC driver entry field.

      For more information, refer to the appropriate documentation or ask your system administrator.

   3. Depending on the JDBC driver that you have specified in the JDBC driver entry field, type the appropriate uniform resource locator (URL) of the database that you want to use in the Database URL entry field. For example, if you want to use the universal Db2 JDBC driver that is located on your computer, type the following specification in the Database URL entry field:

      jdbc:db2://localhost:50 000/<dbname>
      

      where:

      • localhost denotes the host name
      • 50 000 denotes the port number
      • <dbname> denotes the name of the database

      If you want to use the JDBC type 2 driver, you must specify jdbc:db2:MODELS in the Database URL entry field, where MODELS denotes the name of the database on the host.

      For more information, refer to the Db2 documentation or ask your system administrator.

   4. Type the user ID that you want to use in the User ID entry field, for example, db2inst1.
   5. Click Retrieve Database Information.
   6. On the Logon dialog, type the password that you received from your system administrator in the appropriate entry fields and click OK.

      After you have retrieved the database information, the table schema and the table names that are available on the selected database are included in the appropriate drop-down lists in the Database Properties group box.

      The following drop-down lists in the Column Names group box also contain the column names and the appropriate types that are available on the selected database:

      Primary key

      Integer or string

      Model name

      String

      Model data

      CLOB or BLOB

      If you select a CLOB column as model data column, you can save models only in pure PMML format without compression. If you select a BLOB column, you can use all of the available formats.

      (Model description)

      String

      (Model type)

      String

      (Properties)

      BLOB

      The column names that are included in brackets are optional fields.
   7. Select the table schema, the table name, and the column names that you want to use from the appropriate drop-down lists. You can also type this information in the entry fields.

      In the tables that are used by Intelligent Miner, the model name is used as primary key. If you use such tables, select the same column for the primary key and the model name.

   8. Click OK to close the Add New Database Profile window.