Get started with Oracle Autonomous JSON Database for free

Oracle Autonomous JSON Database is a document database cloud service that makes it simple to develop JSON-centric applications. It’s easy to get started with the Oracle Cloud Free Tier using two always-free Autonomous Database instances with 1 OCPU and 20 GB of storage each. Developers also get US$300 in free credits for a 30-day trial of a wide range of other Oracle Cloud services.

Step 1

Create and log in to your Oracle cloud account

Create an account through a web browser or mobile device. It only takes a few minutes.

  • Sign up for a free Oracle Cloud account.
  • Read the welcome email for access details.
  • Log in to the free Oracle Cloud account.
step 1

Step 2

Create an Oracle Autonomous JSON Database

Access the Oracle Cloud Infrastructure (OCI) console, which makes it simple to create databases. Additionally, developers can choose to deploy databases via REST APIs, the OCI command-line interface (CLI), or SDKs. You can

  • Use SQL Developer Web with Simple Oracle Document Access (SODA) collection APIs.
  • Develop REST interfaces for Autonomous JSON Database.
  • Use SODA APIs for REST with Autonomous JSON Database.
step 2

Step 3

Develop applications

Developers use tools and languages of their choice for JSON-centric application development through APIs.

  • Option 1: Use Oracle Database API for MongoDB to develop applications with MongoDB tools, drivers, and frameworks.
  • Option 2: Use SODA API to develop applications in popular programming languages, such as Java, Node.js, and Python.

Application development option 1

Develop with MongoDB tools and frameworks through Oracle Database API for MongoDB

Oracle Database API for MongoDB lets Autonomous JSON Database understand Mongo-speak. With the API, JSON data in MongoDB Atlas or on-premises MongoDB can be easily migrated to Autonomous JSON Database with import/export tools that are familiar to MongoDB developers. Current MongoDB applications will continue to run with a simple change of the connection string, often without the need for additional coding changes or rewrites. Developers can build new applications on Autonomous JSON Database using MongoDB drivers, tools, and frameworks.

Oracle Database API for MongoDB concepts

  • The API translates the MongoDB wire protocol into SQL statements that are executed by Autonomous JSON Database. This means you can continue to use the drivers, frameworks, and tools you're familiar with to develop your JSON document-store applications.
  • The API lets you leverage the converged database capabilities of Autonomous JSON Database to manage multiple data types, including JSON data, within a single database. For example, these converged database capabilities let you use SQL to query or update JSON data.
  • There’s no need to install or configure the API—just retrieve the connection string for your Autonomous Database instance from Database Actions within OCI.

Develop new MongoDB applications

Develop new MongoDB applications using favorite development tools, drivers, and frameworks—such as MongoDB Compass, Oracle Database Actions, Go, and Java.

Migrate MongoDB workloads to Autonomous JSON Database

  • Use the MongoDB command-line tools, such as mongoexport and mongoimport, or Compass to import data into Autonomous JSON Database. Or use Oracle GoldenGate for an online, zero-downtime migration.
  • Moving your applications from MongoDB to Oracle can be as simple as changing the connect string to point to Autonomous Database. The applications need little or no recoding.

Application development option 2

Develop in popular programming languages through SODA API

SODA is a set of NoSQL-style APIs that let developers create and store JSON documents natively in Oracle Database. Developers can perform create, read, update, and delete (CRUD) operations without needing to know Structured Query Language (SQL). The SODA APIs support popular programming languages and the Representational State Transfer (REST) architecture.

SODA concepts

  • SODA document collections are backed by ordinary database tables and views, and you can take advantage of database features for use with the content of SODA documents. SODA CRUD and query operations are automatically mapped to SQL operations on the underlying database tables or views, and these operations are optimized.
  • There are separate SODA implementations for use with different languages and with the REST architectural style. SODA for REST can itself be accessed from almost any programming language. It maps SODA operations to URL patterns.

Java Application

  • Install JDK
  • Connect to Autonomous JSON Database
  • Configure JDBC driver
  • Install and configure SODA for Java

Node.js application

  • Install Node.js
  • Install node-oracledb
  • Connect to Autonomous JSON Database
  • Install and configure SODA for Node

Python Application

  • Install Python
  • Install cx_oracle
  • Connect to Autonomous JSON Database
  • Install and configure SODA for Python


  • Access it through Service Console in Autonomous Database
  • Click Development tab
  • Use the URL in RESTful Services and SODA card to get stated


  • Oracle SQL Developer Command Line (SQLcl) provides a command line interface for SODA
  • Use Oracle SQL Developer Command Line (SQLcl) to work with SODA collections directly
  • Perform CRUD operations on JSON documents using SQL


  • SODA for PL/SQL APIs provide full SQL support
  • Perform CRUD operations on JSON documents using SQL
  • Query JSON documents using SQL

February 15, 2022

At Last, MongoDB Developers Get Full Autonomous Capabilities

Carl Olofson, Research Vice President, Data Management Software, IDC

Maintaining JSON data in the multimodal Autonomous JSON Database, the same database that manages the related table data, overcomes the problem of managing two separate databases—a JSON database and a relational database. Autonomous JSON Database enables users to perform SQL queries over JSON documents while offering machine learning-driven self-tuning and self-healing capabilities that underpin Autonomous Database.

Read the complete post

Featured blogs

View all


Get started

Try Oracle Autonomous Database

Build, test, and deploy applications on Oracle Cloud for free.

Run a workshop

Run a wide variety of labs and workshops and experience our best technology live.

Get certified

Access online training and certifications for Oracle Database cloud services.

Contact us

Interested in learning more? Contact one of our industry-leading experts.