Skip to Main Content

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

Workshop Info

Session Has Completed - 12 October 2021
1 Hour
JSON in Oracle Database Office Hours
English
JSON

Other Upcoming Sessions