Define and Edit Connections

The first time that you use Oracle Data Miner, no database connections are defined. Before you can use the Oracle Data Miner, you must define a connection to an Oracle 10g Release 2 Enterprise Edition database that has the Oracle Data Mining option installed. 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 be associated with an account that satisfies the requirements of Oracle Data Mining. Oracle Data Mining requires several CREATE permissions plus SELECT access to the tables containing data for analysis. For details, see Chapters 2 and 4 of the Oracle Data Mining Administrator's Guide. See Where to Find More Information to locate this manual.

You can perform the following operations:

You can perform these operations either from the connection dialog when you start Oracle Data Miner or from 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:

You may need to contact your Oracle Data Mining DBA for this information.

Click OK when you finish the definition. The software checks that it can connect to the specified data mining server. If it cannot connect, it describes the problem.

If the connection is valid, you are returned to the Choose Connection dialog. You can now select the connection that you just defined from the dropdown box.

Edit a Connection

To edit an existing connection, select the connection in the Select 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. The software checks that it can connect to the specified data mining server. If it cannot connect, it describes the problem.

If the connection is valid, 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 Select Connection dropdown, and click Delete. A window pops up with the question Delete selected connection?; click Yes to delete the connection.