Modify Oracle Data Integrator Java EE Agent Connection Pool Settings

Note:

This section is applicable only if you are using Oracle Data Integrator Java EE Agent.

After configuring the Oracle Data Integrator 12c Java EE Agent, follow these steps to increase the size of the connection pool to enable parallel step executions as appropriate for Argus Analytics:

1. Open the Oracle Data Integrator WLS administration console (ex: http://<ODI server name>:<ODI port number>/Console)
2. Navigate to Services > Datasources > odiMasterRepository
3. Go to the tab Configuration > Connection Pool
4. Change the Maximum Capacity to 50.
5. Repeat these steps for increasing the connection pool size for the datasource odiWorkRepository as well.
   Without increasing the connection pool size the Oracle Argus Analytics ETLs will fail.