4 Connecting SQL Developer with Oracle Autonomous Database
Beginning with the release of SQL Developer 21.4, you can use Oracle Data Miner to connect and work with data in Oracle Autonomous Database.
This chapter describes the steps to install Oracle Data Miner, and how to connect with Oracle Autonomous Database.
- Downloading SQL Developer
Oracle SQL Developer is available for download free of charge from the Oracle Technology Network. - Connecting SQL Developer with Oracle Autonomous Database
You can connect Oracle SQL Developer with Oracle Autonomous Database using mTLS authentication. You require the wallet files or client credentials to establish a secure connection with your Oracle Autonomous Database. - Installing the Oracle Data Miner Repository
Oracle Autonomous Database is configured with an administrator accountADMIN
, which is used to create and manage other database accounts. Direct access to theSYS
account in Autonomous Database is not available. Therefore, you cannot install the Data Miner Repository using the Data Miner connection in the SQL Developer interface on Oracle Autonomous Database since it requires access to theSYS
account. - Configuring Oracle Data Miner Users
You must grant the required privileges to the user to start using Oracle Data Miner. This topic shows how to grant privilege to an existing user, and how to create a new user and grant the privileges to the user.