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. Build, test, and deploy free Oracle Autonomous Database instances for an unlimited time with Always Free services. In addition, get a US$300 cloud credit and try a wide range of Oracle Cloud services free for 30 days.

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

REST

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

SQLcl

  • 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

PL/SQL

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

January 22, 2024

Autonomous JSON Database Adopts ECPUs and Per-Gigabyte Storage, Lowering the Entry Level Price Point for Developers

Hermann Baer, Senior Director Product Management, Oracle

In early 2023, Oracle introduced ECPUs which are based on the number of cores per hour elastically allocated from a pool of compute and storage servers. The introduction of ECPU reduces the entry-level price point for Autonomous JSON Database since it can now be provisioned with as little as 2 ECPUs and 20 GB of storage.

Read the complete post

Featured blogs

View all

Resources

Get started with Autonomous JSON Database


Try Oracle Autonomous Database

Oracle Cloud offers a Free Tier with a 30-day free trial and always-free services.

Try it for free

Download Autonomous Database

Get Autonomous Database Free Container Image to develop your apps without the cloud.

Download

Run a workshop

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

Learn more

Contact us

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

Get in touch