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.
Learn how to build a microservice using the API for MongoDB and MongoDB tools (mongoimport and mongo shell), then query JSON data on Autonomous JSON Database using JSON and SQL.
Learn how to develop applications faster with open source document APIs and store JSON documents natively without worrying about data models.
Understand Oracle Autonomous JSON Database features and why it costs less than MongoDB Atlas.
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 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 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
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 postResources
Autonomous JSON Database documentation
Check out the Help Center for product documentation, guides, and other resources for Autonomous JSON database service for shared and dedicated infrastructure.
Learn more
- Technical brief: Oracle Autonomous JSON Database overview (PDF)
- Technical brief: JSON-based Application Development with Oracle Database and MongoDB compatibility (PDF)
- JSON Developer's Guide
- Simple Oracle Document Access (SODA)
- Oracle Database API for MongoDB
- What is JSON?
- JSON document technology
- SODA technology
Try sample applications
Analyst articles
- Wikibon: Oracle Just Transformed the JSON Database Cloud Landscape: MongoDB Developers and DBAs, Are You Paying Attention? (PDF)
- OMDIA: A database by any other name? Oracle rolls out API compatibility for MongoDB atop its own multi-model database (PDF)
- Forbes: Oracle Announces Support for MongoDB—This Is Bigger Than Just an API
- ZDNet: Oracle Autonomous JSON Database adds MongoDB support
- Search Data Management: Oracle Autonomous cloud database gains MongoDB API support
- Techzine: Oracle integrates MongoDB JSON workloads with Autonomous Database
- Cloud Database Report: MongoDB in the Oracle Cloud? New Silo-Busting API Makes It Possible
- SiliconANGLE: Oracle adds support for the MongoDB API, makes its case for value of the converged database
- Database Trends and Applications: Oracle Announces Oracle Database API for MongoDB
Analyst videos
- Constellation Research: Gerald Venzl, Oracle on the New API for MongoDB (9:32)
- theCUBE: Oracle Lures MongoDB Devs with New API for Autonomous Database (18:54)
Analyst blogs
- IDC: At Last, MongoDB Developers Get Full Autonomous Capabilities
- ESG: Oracle Embraces the 'Najort Horse' Concept with its MongoDB API for Autonomous Database News (PDF)
- KuppingerCole Analysts: SQL vs. NoSQL? Why Not Both? (PDF)
- ESG: Oracle Autonomous JSON Database—Imagine Allowing App Developers to (Just) Develop Apps (PDF)
Analyst reports
- Wikibon Research: Oracle Autonomous JSON takes on Document DBs (PDF)
- Constellation Research: Oracle Boosts Developer Velocity with Autonomous JSON Database (PDF)
- DSC Research: How Oracle Autonomous JSON Database Services: ATP, ADW, and AJD Transform Database IT Outsourcing (PDF)
- Omdia Research: Oracle spins up Autonomous JSON Database (PDF)
- WinterCorp: Oracle Autonomous JSON Database (PDF)
- dbinsight: JSON Developers? Oracle Autonomous JSON wants you (PDF)
- IDC: Oracle Announces Oracle Autonomous Database for JSON (PDF)
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.