Skip to Main Content

JSON in Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

April 12, 2022

18:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Description

Store and Analyze JSON Data Using the Oracle API for MongoDB and SQL/JSON
Many developers like the MongoDB API for building applications. You can now use that same easy-to-use API against Oracle Autonomous Database. Simply bring your MongoDB application to Autonomous Database and inherit the security, availability, and manageability of the service. Plus, you can use Oracle SQL to analyze both your JSON collections and your relational data from your favorite SQL tools and applications. During this session, we will build a low-latency microservice using the Oracle API for MongoDB and then show how the backing collections can be queried directly using SQL.

5:30 - Introduction of dataset
9:00 - Accessing the Oracle API for MongoDB
10:40 - Loading data
12:15 - Using mongosh
14:40 - Spring Boot microservice
21:30 - SQL/JSON
28:50 - Bar chart visualization
Catch up on the recording for our last session!
Don't miss our next live session!
This session: https://asktom.oracle.com/pls/apex/asktom.search?oh=17194

Your Experts

  • #SELECTION#
    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Josh Spiegel

    Josh Spiegel

    Josh is a member of the Oracle Database development team, writing bits and bytes for JSON in Oracle Database, the XDK, Oracle XQuery for Hadoop, SODA and more.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Roger Ford

    Roger Ford

    Roger Ford is the Product Manager for Oracle Text. He has worked for Oracle for three decades, as a developer, support manager, technical marketing specialist and product manager.
    #MISC#
    #ACTIONS#

All Sessions

Resources