Configure API-Portal with an Oracle Database
To customize the API-Portal with Oracle 11g or Oracle 12c database you need the following components:
An operating Oracle database.
The ojdbc6.jar driver. You can download this driver from the Oracle Web Site to a directory of your choice.
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.
1. Go to the directory Software AG Installation Directory\API_Portal\Add-ons\DatabaseScripts\Design&ConnectServer\oracle.
2. Configure envset.bat
a. Log on remotely onto the system where the database is installed and copy the database scripts to that system.
In the Design&ConnectServer directory you can find the following files:
cip_create_app_user.bat cip_create_schema_for_tenant.bat cip_update_schema_for_tenant.bat envset.bat b. Edit the following lines in the envset.bat file:
SET CIP_ORA_BIN_PATH=Path where sqlplus.exe can be found
SET TARGET_HOST=DB Server Name
SET TARGET_PORT=Port
SET TARGET_SERVICE_NAME= Name of the database
SET CIP_INSTALL_USER=User Name
SET CIP_INSTALL_PWD=Password
3. Run the database scripts.
a. Run the script cip_create_app_user.bat. The application user is the oracle user connecting ARIS and the Oracle database.
b. Type cip_create_schema_for_tenant.bat aris_master (mandatory)
c. Type cip_create_schema_for_tenant.bat aris_default (mandatory). Two schemes are mandatory. One for the master tenant and one for the default tenant.
4. Add the JDBC drivers to API-Portal classpath.
a. Start API-Portal Cloud Controller.
b. Stop all runnables except zoo_m.
c. In ACC type enhance apiportalbundle_m with commonsClasspath local file "ojdbc6.jar location"
5. Register the external service database.
a. In ACC, type register external service db url="jdbc:oracle:thin:@servername:port:databasename" driverClassName=oracle.jdbc.OracleDriver jmxEnabled=true maxActive=100 maxIdle=15 logAbandoned=true rollbackOnReturn=true maxWait=10000 removeAbandoned=false defaultAutoCommit=false username=User Name password=Paswordhost=servername
An external service identifier will be returned once the above command is executed, for example it returns the service id as db0000000000.
b. Execute the following command from ACC console to assign the service to the tenant default: assign tenant default to service db0000000000 com.aris.cip.db.schema=default schema assign tenant master to service db0000000000 com.aris.cip.db.schema=master schema
6. Start all runnables.
You configured API-Portal with an Oracle 11 g or Oracle 12c database.
