Software AG Products 10.11 | Administering API Portal | Configuring API Portal | Configuring API Portal with External Databases | Configure API Portal with an Oracle Database
 
Configure API Portal with an Oracle Database
 
Taking a Back up of API Portal database
Starting Zookeeper Service
Registering External Oracle DBMS
Creating Database Schema for Tenants
Enhancing Runnables with JDBC Driver for External Database
Registering the External Service Database
Assigning Tenant to the Database Service
Restoring the backed up data
To customize the API Portal with Oracle 12c or Oracle 19c database you need the following components:
*An operating Oracle database.
*ojdbc driver jar, which can be downloaded from Oracle website to a directory of your choice in the machine where API Portal is installed. Example: ojdbc6.jar.
Note:
For Oracle 12c and Oracle 19c with API Portal 10.7, download ojdbc8.jar driver.
*SQL scripts and all additional files. These scripts can be downloaded from the ARIS Download Center.
The SQL scripts creates a database and necessary database objects required by the API Portal components.
Note:
Database scripts should be executed from the machine where sqlplus client is running.
*To configure API Portal with an Oracle Database
1. Take a back up of data from API Portal.
2. Start Zookeeper service.
3. Register external Oracle DBMS.
4. Create database schema for tenants.
5. Enhance the runnables with the JDBC driver for the external database system.
6. Register the external service database.
7. Assign tenant to the database service.
8. Restore the backed up data.