3.15 Managing SODA Collections
Use Object Browser to load data to a SODA collection as JSON, TXT, or ZIP files.
- About SODA Collections
Learn about SODA collections. - Creating a SODA Collection
Use Object Browser to load documents and create a new SODA collection. - Viewing a SODA Collection
View existing SODA collections in Object Browser. - Editing or Dropping a SODA Collection
View a SODA collection in Object Browser, then use Load Data to upload a new version of the data or click the Drop button to remove the SODA collection from the workspace.
Parent topic: Managing Database Objects with Object Browser
3.15.1 About SODA Collections
Learn about SODA collections.
Simple Oracle Document Access (SODA) is a set of NoSQL-style APIs that enable you to create and store, retrieve, and query collections of documents in Oracle Database without needing to know Structured Query Language (SQL) or how the documents are stored in the database.
SODA uses a SQL schema to store documents .Documents are generally JSON data but they can be any type of data, including video, images, sounds, or other binary content. Documents can be fetched from the database by key lookup or by using query-by-example (QBE) pattern-matching.
Requirements
- Database 18.3 or higher.
- The workspace user must have the SODA_APP role.
Supported Filetypes
You can upload the following filetypes to a SODA collection:
-
JSON files - APEX supports JSON files containing an array with multiple JSON objects. APEX extracts each JSON object from the array and loads it as a single JSON document to the SODA collection. The array selector is auto-detected by default.
-
JSON lists - JSON lists are files containing multiple JSON documents, one per line, separated by line feeds.
-
ZIP files - ZIP files are automatically extracted and each file can be uploaded to a SODA collection. Depending on data load settings, non-JSON files within the ZIP archive are either skipped or also loaded to the collection. XML files can be converted to JSON before loading to the SODA collection.
Parent topic: Managing SODA Collections
3.15.2 Creating a SODA Collection
Use Object Browser to load documents and create a new SODA collection.
To load documents to a new SODA collection:
Parent topic: Managing SODA Collections
3.15.3 Viewing a SODA Collection
View existing SODA collections in Object Browser.
To view an existing SODA collection:
Parent topic: Managing SODA Collections
3.15.4 Editing or Dropping a SODA Collection
View a SODA collection in Object Browser, then use Load Data to upload a new version of the data or click the Drop button to remove the SODA collection from the workspace.
To edit or drop a SODA collection:
Parent topic: Managing SODA Collections