Adding a new database vendor to your system

You can add a new database vendor to your system either during or after the installation of IBM® Sterling Order Management System Software by adding DB vendor jar files.

Adding a new database vendor during installation

You can directly add database vendors to your system during the installation of Sterling Order Management System Software. You need to ensure that the "Enable mixed database vendor support" option is enabled and that the appropriate drivers are specified in the Installation Manager.

Note: After the installation, you still need to add the different shards.

Adding a new database vendor post-installation

You can add a new database vendor to your system after the installation of Sterling Order Management System Software. For example, to add an Oracle database vendor to your system:
  1. Copy the new dbdriver to <INSTALL_DIR>\dbjar\jdbc\Oracle\<DBJARFILENAME>.jar.
  2. Add the dbdriver path of Oracle to the DB_DRIVER parameter in <INSTALL_DIR>\properties\sandbox.cfg.

    For example: DB_DRIVERS=C\:\\Platform\\SI\\dbjar\\jdbc\\Db2\\db2cc4.jar;C\:\\Platform\\SI\\dbjar\\jdbc\\Oracle\\oracle.jar

  3. Modify sandbox.cfg and set multischema.multivendor.enabled=true.
  4. Run the install3rdParty utility and -targetJVM EVERY to add the new jar file to all classpath application servers and agents.
  5. Run the script <INSTALL_DIR>/bin/setupfiles.sh (for UNIX/Linux) or <INSTALL_DIR>\bin\setupfiles.cmd (for Windows).