(SM-2508) Oracle Storage Setup

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. It is also known as Oracle RDBMS and sometimes just Oracle. 

The system is built around a relational database framework in which data objects or an application front end can be directly accessed through a structured query language (SQL). Oracle is a fully scalable relational database architecture and is often used by global enterprises that manage and process data across wide and local area networks. Oracle DB has its own network component to enable communication across networks. 

Supported versions

The minimal supported version is 12.1.0.2.0.

Creating Oracle Storages in Kyano Storage Management 

1. Start transaction /DVD/SM_SETUP. 

2. Click Create to create a new storage. 

3. Enter a Storage ID. 

4. In the Storage type field, enter SM_TRS_ORA. 

5. Click Confirm. 

6. Specify the required parameters: 

   • Storage ID: Name of the storage. 

   • Storage type: Type of storage. Use the storage type SM_TRS_ORA for Oracle transparent storage. 

   • Description: Short text description. 

   • Connection mode: Select Open SQL, Native SQL, or Mass insert for query execution.

   • DB Connection Name: Name of the existing SAP database connection. 

   • DB Schema: Empty by default. If you define the DB schema, it is used for further Kyano Storage Management API calls – reading the package, retrieving 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 an external storage and a foreign schema is not supported by open SQL. 

   • Enable update: Support for the direct update statements.

   • Read all clients: Read data from the database with all clients (relevant for Open SQL Connection mode).
     

7. Click Save.

The new storage has been created.