Oracle Extensions for IDEs

Oracle Cloud Infrastructure Toolkit for Eclipse is a plugin that enables Java developers to easily connect to Oracle Autonomous AI Database 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 AI 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 AI Databases

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

• Scale up and down

• Download the client credentials zip file (database wallet)

• Connect to Autonomous AI Databases

• Browse the schema

• Choose compartments and regions

• Change the administrator password, 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 AI Database

Oracle Developer Tools for Visual Studio is a tightly integrated extension for Microsoft Visual Studio and Oracle Autonomous AI Database. 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 AI 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 AI Database, Autonomous AI Database Dedicated, and Autonomous AI Database Serverless databases

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

• Change compartments and regions without reconnecting

• Start, stop, or terminate Autonomous AI Database

• Scale up/down Autonomous AI Database resources

• Restore from backup

• Update instance credentials

• Rotate wallets

• Convert Always Free Autonomous AI Database to paid:

  Note
  
  

  Promotion of Always Free to a paid Autonomous AI Database is supported only if the database version for the Always Free Autonomous Database is Oracle Database 19c or Oracle AI Database 26ai.

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 AI 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.

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

You can use the extension to connect to Autonomous AI 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 Visual Studio

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