An administrator must make an additional database accessible from within IBM Sterling B2B Integrator. The database connectivity details and service-account credentials have been supplied. Which property file should contain them?
Sterling B2B Integrator reaches databases through JDBC connection pools. The product's own pools are defined in the main JDBC properties, but connections to additional databases are defined in a customer-specific properties file so that local definitions are kept apart from shipped files and are retained through upgrades. IBM's documented procedure uses jdbc_customer.properties.in, which produces jdbc_customer.properties when the configuration is applied. Each pool is defined by a set of entries that name the JDBC driver class, the connection URL, the database user and password, and the pool settings such as the initial and maximum number of connections. After the file is edited, the administrator runs setupfiles to regenerate the properties and restarts Sterling B2B Integrator so the new pool is created. Business processes then refer to the pool by name when they use the JDBC adapter or services. Passwords should be stored in encrypted form and the account should have only the privileges the integration needs. The sandbox.cfg file holds installation settings such as ports and directories, and it does not define connection pools. database.properties and pool.properties are not documented product files for this task.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit