Oracle Extensions for IDEs

Oracle extensions let developers connect to, browse, and manage Autonomous Databases directly from common IDEs.

Use Oracle Cloud Infrastructure Toolkit for Eclipse

Oracle Cloud Infrastructure Toolkit for Eclipse is a plugin that enables Java developers to easily connect to Oracle Autonomous Database on Dedicated Exadata Infrastructure through their IDE. The plugin is free and is available for Linux, UNIX, Microsoft Windows, and Apple Mac OS.

You can use the plugin to perform cloud and database operations right from Eclipse, such as creating Autonomous Databases, stopping and starting, scaling up and down, and so on. You can also use the plugin to easily connect to the databases to browse the schema, access tables, execute SQL statements, and perform other development tasks.

Users with permissions to manage the databases can perform a number of actions, including those listed below. For detailed information about permissions, see Toolkit for Eclipse in the Oracle Cloud Infrastructure documentation. You can:

  • Create Autonomous Databases

  • Start, stop, terminate, clone, and restore Autonomous Databases

  • Scale up and down

  • Download the client credentials zip file (database wallet)

  • Connect to Autonomous Databases

  • Browse the schema

  • Choose compartments and regions

  • Change the administrator password, update the license type, and so on

Download the latest version of the plugin from GitHub (com.oracle.oci.eclipse-version.zip, where version is the latest version, for instance 1.2.0):

https://github.com/oracle/oci-toolkit-eclipse/releases

Then follow the installation instructions and details about how to get started in this step-by-step walkthrough:

New Eclipse Plugin for Accessing Autonomous Database (ATP/ADW)

Use Oracle Developer Tools for Visual Studio

Oracle Developer Tools for Visual Studio is a tightly integrated extension for Microsoft Visual Studio and Oracle Autonomous Database on Dedicated Exadata Infrastructure. The extension is free and supports Visual Studio 2019 and Visual Studio 2017 on Microsoft Windows.

You can use the extension to perform database management operations right from Visual Studio, such as creating Autonomous Databases, stopping and starting, scaling up and down, and so on. You can also use the extension to easily connect to the databases and perform development tasks, such as browsing your Oracle schema and launching integrated Oracle designers and wizards to create and alter schema objects.

Users with permissions to manage the databases can perform a number of actions, including the following:

  • Sign up for Oracle Cloud

  • Connect to a cloud account using a simple auto-generated config file and key file

  • Create new or clone existing Always Free Autonomous Database, Autonomous Database Dedicated, and Autonomous Database Serverless databases

  • Automatically download credentials files (including wallets) and quickly connect, browse, and operate on Autonomous Database schemas

  • Change compartments and regions without reconnecting

  • Start, stop, or terminate Autonomous Database

  • Scale up/down Autonomous Database resources

  • Restore from backup

  • Update instance credentials, update the license type used

  • Rotate wallets

  • Convert Always Free Autonomous Database into paid databases

    Note

    Promotion of Always Free to paid is currently supported only if the Always Free instance has database release 19c.

Download the extension from Visual Studio Marketplace:

You'll find lots of information about the extension on those Marketplace pages.

Then follow the installation instructions and details about how to get started in this step-by-step walkthrough:

New Release: Visual Studio Integration with Oracle Autonomous Database

For detailed information about how to use the extension, see the online documentation that's optionally installed with Oracle Developer Tools for Visual Studio. Press the F1 key to display the context-sensitive help for each dialog.

Use Oracle Developer Tools for VS Code

Oracle Developer Tools for VS Code is a tightly integrated extension for Microsoft Visual Studio Code (VS Code) and Oracle Autonomous Database on Dedicated Exadata Infrastructure. The extension is free and is available for Linux, Microsoft Windows, and Apple Mac OS.

You can use the extension to connect to Autonomous Databases right from Visual Studio Code and easily explore database schema, view table data, and edit and execute SQL and PL/SQL.

Download the extension from Visual Studio Marketplace:

Oracle Developer Tools for VS Code

Installation instructions and information about how to get started can be found in this quick start guide:

Getting Started Using Oracle Developer Tools for VS Code