Define and Edit Connections

The first time that you use Oracle Data Miner, no connections are defined. Before you can use the Oracle Data Miner, you must define a connection to an Oracle 10g Enterprise Edition Database. Once you have defined one connection, you can define new connections and edit existing connections.

NOTE: The user name and password that you specify when you define a connection must satisfy the requirements of Oracle Data Mining. Oracle Data Mining requires a small number of database permissions, plus SELECT access to the tables containing data for analysis. The dmshgrants SQL script sets the required permissions. For details, see the Oracle Data Mining Administrator's Guide.

You can perform the following operations:

You can perform these operations either from the connection dialog when you start Oracle Data Miner or using the Connections tab of Tools | Preferences when Oracle Data Miner is running.

Define a New Connection

The first time that you invoke Oracle Data Miner, the dialog for defining a connection appears when you start Oracle Data Miner. To define a new connection, click New in the Choose Connection dialog. A dialog appears asking for the following connection information:

Click OK when you finish the definition. You are returned to the Choose Connection dialog. You can now select the connection that you just defined from the dropdown box.

You may need to contact your ODM DBA for this information.

Edit a Connection

To edit an existing connection, select the connection in the Connection dropdown that you want to edit, and click Edit. The following information is displayed:

Change fields by typing in new values. Click OK when you have made all changes. You are returned to the Choose Connection dialog. You can now select the connection that you just edited from the dropdown box.

Delete a Connection

To delete an existing connection, select the connection in the Connection dropdown that you want to delete, and click Delete. A window pops up with the question Delete selected connection; click Yes to delete the connection.