(SM-2308) Oracle Storage Setup

Owned by SNP
Aug 23, 2023
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 (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.

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 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 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.