Software AG Products 10.7 | Administering API Portal | Configuring API Portal | Configuring API Portal with External Databases | Configure API Portal with an Oracle Database | Registering the External Service Database
 
Registering the External Service Database
1. In API Portal Cloud Controller, run the following commands:
register external service db url="jdbc:oracle:thin:@
servername:port/servicename"
driverClassName=oracle.jdbc.OracleDriver jmxEnabled=true maxActive=100
maxIdle=15 logAbandoned=true rollbackOnReturn=true maxWait=10000
removeAbandoned=false defaultAutoCommit=false
username=Application Username password=Application User password
host=servername
For example
register external service db url="jdbc:oracle:thin:@
machinename:1521/ORCL"
driverClassName=oracle.jdbc.OracleDriver jmxEnabled=true maxActive=100
maxIdle=15 logAbandoned=true rollbackOnReturn=true maxWait=10000
removeAbandoned=false defaultAutoCommit=false
username=dbuser107 password=dbuser107123
host=machinename
An external service identifier is returned once the above command is executed, for example, it returns the service id as db0000000000.