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 through their IDE. The plugin is free and is available for Linux, UNIX, Microsoft Windows, and Apple Mac OS. - 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. The extension is free and supports Visual Studio 2019 and Visual Studio 2017 on Microsoft Windows. - 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. The extension is free and is available for Linux, Microsoft Windows, and Apple Mac OS.
Parent topic: Develop
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 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, 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)
Parent topic: Oracle Extensions for IDEs
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. 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
-
Rotate wallets
-
Convert Always Free Autonomous Database to paid:
Note
Promotion of Always Free to a paid Autonomous Database is supported only if the database version for the Always Free Autonomous Database is Oracle Database 19c or Oracle Database 23ai.
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.
Parent topic: Oracle Extensions for IDEs
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. 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:
Parent topic: Oracle Extensions for IDEs