Oracle Data Mining takes place in an Oracle Database. All data mining objects including input tables and models reside in a database.
This chapter contains the following topics:
In Oracle SQL Developer, the Data Miner tab lists the following:
Connections
Note:
Connections are listed both in the Connections tab and in the Data Miner tab.Projects
Workflows
Before you start data mining, ensure the following:
Specify a connection to an account in an Oracle Database 11g Release 2 (11.2.0.1) or Oracle Database 12c Release 1 (12.1). The account that you connect to must have all grants required by Oracle Data Mining.
Define at least one connection to indicate the account where workflow nodes run.
If the Data Miner tab is not visible in the Oracle SQL Developer window, then:
Go to Tools and click Data Miner. Then, select Make Visible.
Go to View and click Data Miner. Then, select Data Miner Connections.
This docks the Data Miner pane in the Oracle SQL Developer window.
You can create connections to Oracle Database from the Connections tab and from the Data Miner tab.
See Also:
To create connections from the Connections tab:
In Oracle SQL Developer, go to View and click Connections. This docks the Connections pane in the Oracle SQL Developer window.
In the Connections pane, right-click Connections and click New Connections. Alternately, you can click to add a new connection.
In the New/Select Database Connection dialog box, enter the following for the new connection:
Connection Name: The name of the connection.
Username: The Data Miner user name. See Oracle Data Miner Installation and Administration Guide for more information about Data Miner users.
Password: The Data Miner user password.
Save Password: Select this option to save your password.
In the Oracle tab, provide the following details about the Oracle Database:
Connection Type
Role
Hostname
Port
SID: This is the Oracle Service Identifier (SID), a name by which the Oracle Database instance is uniquely identified from other database instance.
Service Name: Select this option if you are connecting to a database that is installed in a cluster such as Oracle Real Application Clusters.
Select one or all of the following options:
OS Authentication
Kerberos Authentication
Proxy Connection
To connect to the database, click Connect.
To save the connection, click Save.
To create connections from the Data Miner tab:
In Oracle SQL Developer, if the Data Miner tab is not visible, then you can dock it in the Oracle SQL Developer window.
In the Data Miner tab, right-click Connections. The Select Connection dialog appears.
To create a new connection, click . The New/Select Database Connection is displayed.
Follow step 3 through step 8, to complete the task of creating a connection.
See Also:
"Viewing the Data Miner Tab" for more information about making the Data Miner tab visible.
"Creating Connections from the Connections Tab" for more information about creating connections.
After you create a connection, you can manage it from the Data Miner Connections context menu. To perform the following tasks, right-click the connection name in the Data Miner tab and click:
Disconnect: To disconnect the connection from the database.
Note:
The connection still exists. You can reconnect by double-clicking the connection, and entering the password.Add Connection: To create a new connection.
New Project: To create a new project.
Remove: To remove a connection.
Properties: To open the New/Select Database Connection dialog box. You can view and edit connection properties here.
See Also:
"Creating a Project" for more information about project creation.
"Removing a Connection" for more information about connection removal and deletion.
To view connection properties:
In the Data Miner tab, right-click the connection name and select Properties.
In the New/Select Database Connection dialog box, you can view the connection properties and edit them, as required.
Click OK.
To remove a connection:
In the Data Miner tab, right-click the connection name and select Remove. This removes the connections from the Data Miner tab.
Note:
Removing the connection from the Data Miner tab does not remove the connection permanently. To permanently remove the connection, delete it from Connections tab.Go to the Connections tab and right-click the connection.
Click Delete. This permanently removes the connection.
Note:
When you delete a connection, the projects and workflows accessible through the connection are not deleted.To connect to Oracle Database:
In the Data Miner tab, right-click the connection that you want to connect and click Add Connections. If the Data Miner tab is not visible, then dock it in the Oracle SQL Developer window.
In the Select Connections dialog box, select the connection from the Connections drop-down list. If you are disconnected from the connection, you may have to provide a password.
Click OK.
See Also:
"Viewing the Data Miner Tab" for more information about adding connections to the database.
If you do not select the Save Password option when defining the connection, then you must provide the password when you connect.
After you log in, Oracle Data Miner monitors the connection. You can now perform data mining operations.