RoOUG TechSession #46 Online

Workshop: Simple Oracle Document Access (SODA) for Python


Incepem 2022 cu un workshop online Simple Oracle Document Access (SODA) for Python ce se va desfasura pe parcursul a doua dupa-amiezi, in 10 Februarie 2022 si in 11 Februarie 2022.

In data de 10 Februarie 2022 workshopul va incepe la ora 14:00 (ora Romaniei) iar in data de 11 Februarie 2022 va incepe la ora 13:00 (ora Romaniei).

Prezentarea va fi sustinuta in limba romana de Valentin Leonard Tabacaru, Principal Product Manager, Oracle DB Platform Technology Solutions – EMEA.

Evenimentul este gratuit si se va desfasura online prin intermediul platformei Zoom. Linkul de acces va fi trimis tuturor celor inscrisi. Locurile sunt limitate.


Speaker: Valentin Leonard Tabacaru is Product Manager at Oracle. He supports Oracle Database server technology programs to drive the adoption of products and cloud services, maintains and develops exchanges with Product Management teams, helps partners validate and certify their applications, delivers briefings, webcasts, and hands-on workshops.
Valentin also helps strategic partners and customers by handling technical request assignments in his area of expertise

Workshop Description

Oracle’s converged database makes developers and data more productive. Oracle provides a rich API, called Simple Oracle Document Access (SODA), for one of the most popular data models, JSON data commonly used in web and mobile applications.

SODA is a set of NoSQL-style APIs that let you create and store collections of documents (in particular JSON) in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the documents are stored in the database.

This hands-on workshop focuses on SODA for Python which enables enterprise capabilities of the Oracle Database in conjunction with the popular Python programming language and JSON data. You will learn how to use Oracle Database as a document store with JSON, a complete platform for document store applications, including but not limited to: secure data processing through encryption, access control, and auditing; horizontal scalability with Real Application Clusters; consolidation with Oracle Multitenant; and high availability functionality for mission critical services. After this workshop, you will be able to implement Oracle Database enterprise capabilities into your existing and future Python applications. Oracle Database can generate a schema and indices from JSON objects to enable parallel SQL analytics, transactions, and joins of JSON data with spatial, graph, and relational data.


Participants must use their own laptop with the following:

  • Access to Oracle Cloud Infrastructure.
    • Provided by the instructor for instructor-led workshops
  • Basic knowledge of Python is not required but nice to have


  • Create Virtual Cloud Network (VCN)
  • Provision Compute Node for development
  • Configure Compute Node for development
  • Provision Oracle Autonomous JSON Database (AJD)
  • Deploy Atlas document store on MongoDB Cloud
  • Create Python application for MongoDB document store
  • Run the Python application and check results
  • Improve Python application adding Oracle AJD document store
  • Run the application with MongoDB and Oracle AJD support
  • Migrate documents between document stores

Lab guide

Simple Oracle Document Access (SODA) using Python

Workshop walk-through

Leave a Comment