The External Data Mart feature is configured to work with a PostgreSQL database by default. This is an open-source database and therefore the required driver is distributed with the Context Store software.

If you are using an Oracle or Microsoft SQL Server database, Avaya Context Store does not have permission to re-distribute the required drivers. The JDBC driver must therefore be manually loaded into the Breeze Element Manager and then installed on the Context Store cluster. See instructions for doing this in the Loading JDBC driver to System Manager section in the Avaya Context Store Snap-in Reference guide.

SQL Server

Download Microsoft JDBC Driver 6.0 for SQL Server from http://www.microsoft.com:

• Breeze 3.2 and earlier runs on Java 7, therefore the SQL Server JDBC driver selected must support the jre7 version (in Microsoft JDBC Drivers 6.0 for example, this would be the sqljdbc41.jar)

• Breeze 3.3 (and later) runs on Java 8, therefore the SQL Server JDBC driver selected must support the jre8 version (in Microsoft JDBC Drivers 6.0 for example, this would be the sqljdbc42.jar)

• Consult Microsoft JDBC Driver documentation to make sure you have the correct driver for your database version

• Use of an incompatible driver will result in failures in the system and/or SQL exceptions in logs

Oracle

Download the applicable Oracle JDBC Driver from http://www.oracle.com.

• The JDBC driver required depends on the database version that is used, you must consult Oracle JDBC Driver documentation to make sure you have the correct driver for your database version.

• Use of an incompatible driver will result in failures in the system and/or SQL exceptions in logs