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:
The Data Miner tab in SQL Developer allows you to establish connection to a database, and create projects and workflows.
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
Lists the mandatory steps that you must follow before you start data mining.
Ensure the following:
Specify a connection to an account in an Oracle Database 11g Release 2 (11.2.0.4) and later. 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.
Sometimes the Data Miner tab may not be visible in the SQL Developer window. You have the options to make the Data Miner tab visible.
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 tab in the Oracle SQL Developer window.
You must create a SQL Developer connection to an Oracle Database for the Data Miner user.
You can create connections to an Oracle Database in the Connections tab and in the Data Miner tab.
You must create a SQL Developer connection to an Oracle Database for the Data Miner user. You can create this connection from the Connections tab in SQL Developer.
To create connections from the Connections tab:
You must create a SQL Developer connection to an Oracle Database for the Data Miner user. You can create this connection from the Data Miner tab.
To create connections from the Data Miner tab:
Related Topics
After you create a connection, you can manage it from the Data Miner Connections context menu.
You can perform the following tasks by right-clicking 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.
To view connection properties:
For data mining and data analysis, you must establish a connection to a database.
To connect to Oracle Database:
Related Topics