Oracle database (Oracle DB) is a relational database management system (RDBMS) from the Oracle Corporation. Oracle DB is one of the most trusted and widely used relational database engines.

The system is built around a relational database framework in which data objects may be directly accessed (or an application front end) through a structured query language (SQL). Oracle is a fully scalable relational database architecture and is often used by global enterprises, which manage and process data across wide and local area networks. The Oracle database has a network component to allow communications across networks.
Oracle DB is also known as Oracle RDBMS and, sometimes, just Oracle.

Supported versions

The minimal supported version is 12.1.0.2.0.

Storage setup

Storage ID: Storage name.
Storage Type: Type of storage; use the storage type SM_TRS_ORA for Oracle transparent storage.
Description: Short text description.
Connection mode: O for Open SQL, N for Native SQL, and M for mass insert; by default, Open SQL is used.
DB Connection Name: Existing SAP database connection.
DB Schema: By default is empty. If you define it, then it is used for further Storage Management API calls (read the package, get external tables, etc.).
Note that in some cases the native connection is used, even if the connection mode is set to O. For example, reading a table from external storage and a foreign schema is not supported by open SQL.
Read all clients: Read data from the database with all clients (relevant for Open SQL Connection mode).

Mass insert

Mass insert mode is available from SAP release 730. Mass insert inserts data in bulk instead of row-by-row insertion.

Browser not supported