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

October 12, 2021

16: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.


Oracle Database Api for MongoDB
In this session we demo our newest feature for the Autonomous Database: the Oracle Database Api for MongoDB!
You can now connect MongoDB applications, tools, drivers, etc to the Oracle Autonomous Database! And of course SQL-access to the same data is possible!

0:50 Oracle Converged (multi-model) Database
2:27 Autonomous Databases
5:33 Oracle Database Api for MongoDB
10:15 Connect Mongo shell to Oracle Autonomous JSON
10:50 Work with Mongo collections from Mongo shell
12:30 Access Mongo collections with Oracle SQL
13:50 Using MongoDB Compass to insert data into Oracle
15:30 Execute SQL over Mongo Collections
19:02 Write data from SQL to a Mongo collection
21:08 Benefits of Oracle's converged database
21:55 Sample JSON App: Machine Learning and Prediction
22:50 Mongoose application to generate sensor data
25:50 Migration from MongoDB to Oracle
28:09 mongoexport, mongoimport, change connection
30:40 Relational access to Mongo collections
32:00 SQL vs Aggregation Framework, with exaamples
37:17 Build JSON data from relational data
39:00 Benefits of Oracle Autonomous Database
39:10 Machine Learning notebooks
41:15 Train a model to predict sensor failures
45:50 Geo/spatial data extraction from JSON
48:50 APEX and visualization on map

Your Experts

    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    Loïc Lefèvre

    Loïc Lefèvre   

    Data Warrior