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 account ADMIN, which is used to create and manage other database accounts. Direct access to the SYS 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 the SYS 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.