(SM-1811) Oracle transparent storage

Owned by SNP
Last updated: Dec 05, 2018 by Martina Pospisilova (Unlicensed)

Oracle database (Oracle DB) is a relational database management system (RDBMS) from the Oracle Corporation. Originally developed in 1977 by Lawrence Ellison and other developers, 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: name of the storage
  • Storage Type: type of storage, use storage type "SM_TRS_ORA" for Oracle transparent storage.
  • Description:  short text description


  • Connection mode: O - Open SQL, N - Native SQL, by default Open SQL is used
  • DB Connection Name: existing SAP Database Connection.
  • DB Schema: by default empty, if it is defined, then this schema will be used for further SM API calls (read package, get external tables, etc ... ) Note: in some cases, the native connection is used even if connection mode is set to O, for example when reading from external and "foreign" schema Open SQL does not allow to read from following structure: SCHEMA_NAME.TABLE_NAME.