Configuring Repository Connections

1. Understand Database Connection Limitations:
• Concurrent Connections: The database engine where the repository is stored may limit the number of concurrent connections. For Oracle, the parameter that controls this is called processes.
• Database Tuning: When running a large number of parallel executions, you may need to tune your database to increase the maximum number of allowed connections.
2. Determine the Number of Connections Needed: The number of connections required depends on the activities being run in ODI Studio and Load Plan steps.
• ODI Studio Sessions:
  Each ODI Studio session requires:
• Two database connections:
• One connection to the master repository.
• One connection to the work repository.
• Additionally, a third connection is required briefly at the start of the session for security checks.
• Load Plan Steps (Non-Oracle Databases):
• Each Load Plan step consumes an additional connection as a lock during execution.
3. Check the Number of ODI Studio Instances:
• The number of ODI Studio instances that will be running concurrently will impact the number of connections needed. Plan accordingly based on the number of parallel executions.
4. Adjust Database Parameters for Performance:
• If you're running multiple parallel executions or sessions, ensure that your database is tuned to handle the increased connection demands.
• For Oracle databases, adjust the processes initialization parameter to allow for a higher number of connections.
• For non-Oracle databases, ensure that the system can handle the connections needed, especially for Load Plan executions.
5. Monitor and Optimize Connection Usage:
• Regularly monitor the number of active connections to ensure that your database is not being overloaded, which could impact performance.
• If necessary, optimize your environment by reducing the number of concurrent executions or by increasing your database's connection limits.

By carefully configuring the repository connections and tuning the database parameters, you can ensure smooth and efficient operations while running ODI Studio and Load Plan executions concurrently.