(SM-1905) Oracle transparent storage

Owned by SNP
Jan 15, 2019
1 min read

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 by users (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 its own network component to allow communications across networks.
Oracle DB is also known as Oracle RDBMS and, sometimes, just Oracle.

Storage setup

  • Storage ID: storage name
  • Storage Type: type of a storage; use the storage type "SM_TRS_ORA" for Oracle transparent storage.
  • Description: short text description


  • Connection mode: O for Open SQL and N for Native SQL; 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 package, get external tables, etc.).
    Please 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 an external storage and a foreign schema is not support by open SQL.