Example Values for Database Connection Parameters
During the installation of the Genesys Rules Authoring Tool, you will be prompted to enter various connection parameters for the database you are using as the Rules Repository (created in Creating the Rules Repository Database).
The table below provides some example values for the three supported database types (MSSQL, Oracle, and DB2). Note that these values are examples only, and you must consult your database vendor’s documentation for specific information. The last column in the table lists the JDBC drivers that you must to copy to the lib directory of your application server.
|
Database Type |
Example Connector Class |
Example Database URL |
JDBC Driver to be Copied |
|---|---|---|---|
| MSSQL | com.microsoft.sqlserver.
jdbc.SQLServerDriver |
jdbc:sqlserver://example.com:1433;databaseName=GRS_db
where example.com is the MS SQL host, and GRS_db is the database name |
sqljdbc.jar |
| Oracle | oracle.jdbc.driver.OracleDriver | jdbc:oracle:thin:@//example.com:1521/orcl
where example.com is the Oracle database host, and orcl is the database instance (SID) |
ojdbc14.jar
ojdbc14_g.jar ojdbc14dms_g.jar ojdbc6_g.jar |
| DB2 | com.ibm.db2.jcc.DB2Driver | jdbc:db2://192.168.10.10:50000/GRS_db
where 192.168.10.10 is the DB2 host, and GRS_db is the database name |
db2jcc.jar db2jcc_license_cu.jar |