Configure API Portal with an Oracle Database
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 downloaded from the
ARIS Download Center. For
API Portal 10.7, you must download the 10SR14 scripts (ARIS10.0.SR14.DatabaseScripts.zip)
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.