In the following topics, you perform the steps required to set up Oracle Data Miner 11g Release 2 for use within SQL Developer 3.0.
Important: As stated above, you need the SYS user credentials in order to install the Oracle Data Miner Repository . In addiiton, you will use the SYS user to create a database user account for data mining purposes.
Create a Data Miner User Account
SQL Developer is a client to the Oracle Database software. Before you can perform actions such as creating a user, you must connect to the database from SQL Developer.
To connect to the database, you will define an administrative (SYS) connection in SQL Developer, and then use that connection to create the data miner user.
Perform the following steps.
|1.||To open SQL Developer, double-click sqldeveloper.exe in the directory where you unzipped SQL Developer.
For example, double-click C:\SQLDev\sqldeveloper.exe, as shown below:
|2.||In the the SQL Developer Connections tab, right-click Connections and select New Connection from the pop-up menu.
Result: The New / Select Database Connection dialog box appears.
|3.||In the New / Select Database Connection dialog box:
A. Enter the following parameters:
B. Click Test to test the connection.
Note: If the connection is successful, Status (just above the Help button) changes to “Success!”
C. Click Connect to save the connection and to also establish a connection to the database.
|4 .||Next, create an account for data mining.
A. In the SQL Developer Connections tab, drill on the admin connection.
B. Then, right-click the Other Users node and select Create User from the pop-up menu, like this:
C. In the Create/Edit User window, select the User tab and specify a username, password, default tablespace, and temporary tablespace for the user account. In the example below, the parameters include:
Note: Your available tablespaces may differ if you are using an existing database that does not have the standard default tablespaces.
D. Still in the Create/Edit User window, select the Roles tab and click the check box in the Granted Column forCONNECT.
E. Still in the Create/Edit User window, select the Quotas tab and click the check box to set Tablespace toUnlimited (for the default tablespace).
F. Click Apply to create the account.
Note: The Results tab displays the following:
E. Click Close to dismiss the Create/Edit User window.
In this topic, you create a SQL Developer connection for the data miner user.
You can create this connection either by using the SQL Developer Connections tab or the Data Miner tab. In either case, the same New / Edit Database Connection dialog box appears. All saved SQL Developer connections appears in both tabs.
Follow these steps to create a connection for the data miner user:
At this stage, you have created a database account for the data miner user (dmuser), and have created a SQL Developer connection for that user. Next, you install the Data Miner Repository in the database using an automated process.
To accomplish this, you simply display the Oracle Data Miner tab ( which looks similar to the SQL Developer Connections tab), and then connect to the data miner user from the Data Miner tab.
- The Data Miner Repository installation routine automatically starts the first time that you activate a SQL Developer connection from the Data Miner tab.
- Once the Data Miner Repository has been installed in the database, other data miner users may be granted the required privileges to the repository by an automated process that is similar to the installation routine examined here.
Follow these steps:
|1.||From the SQL Developer menu, select View > Data Miner > Data Miner Navigator, as shown here:
Result: The Data Miner tab appears below the SQL Developer Connections tab.
|2.||Dismiss the SQL Developer Connections tab by clicking the Close (X) icon, like this:
Result: The Data Miner tab now appears directly below the SQL Developer main menu.
|3 .||To begin the installation process of the Data Miner Repository:
A. Double-click on dmuser (and not the admin user).
Result: A message tells you that the Data Miner Repository is not installed in the database, and asks you if you want to install the Repository.
B. Click Yes to launch the installation process.
|4 .||In the Connection Information dialog box:
A. Enter the Administrative password for the database.
Note: You must be logged in as SYS to install the repository.
B. Click OK to continue.
|5 .||In the Repository Installation Settings dialog box:
A. Select the Default Tablespace and the Temporary Tablespace for the repository account named ODMRSYS.
B. Click OK to display the Install Data Miner Repository dialog box.
|6 .||In the Install Data Miner Repository dialog box:
A. Click Start to begin the repository installation.
B. When the installation completes, click Close to dismiss the dialog box.
You are now ready to perform data mining with the dmuser account. You can begin with the tutorial Using Oracle Data Miner 11g Release 2.
In this lesson, you learned how to set up the Oracle Data Miner graphical user interface for use within SQL Developer, version 3.0.