Jump to: navigation, search

Database Access Point

Also known as a DAP. An object that provides the interface between an application in the Genesys installation and the databases to which the application requires access. Refer to the Framework Database Connectivity Reference Guide for more information about configuring and using DAPs.



Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Configuring the Rules Repository Database using Genesys Administrator

This procedure creates and configures the GRAT Rules Respository database using Genesys Administrator.

Most database distributions include the JDBC connector that is needed. If this is not the case, you must download it from the vendor’s site. Genesys does not provide the JDBC connector. Genesys Rules System 8.1 can use either Java 6 or 7.

Once the configuration below is complete, the same database configuration will be used whenever GRAT is installed or updated. There will be no need to specify it again. Also, if any of the database information changes (for example, DB Server location, DB name, DB user or DB password), users can simply update the DAP and restart GRAT.

Prerequisites

RDBMS; Oracle or Microsoft SQL or DB2.

Procedure

  1. Create a new database using the normal DBMS procedures for the type you are working with. This is the database that will be populated by GRAT. Create a DB user/password that will have full access to this new database.
  2. In Genesys Administrator, navigate to the Environment > Applications > GRS folder.
  3. Create a new application to be the new Database Access Point.
  4. GRS DAPGA1.png
  5. Select the Application Template type Database_Access_Point_811 (or later).
  6. Ensure that the State: Enabled check box is checked.
  7. In the Server Info panel, enter values for the Host and the Listening Ports of the DBMS server.
  8. In the DB Info panel, enter JDBC as the Connection Type. This will disable the DBMS Name field.
  9. GRS DAPGA2.png
  10. Set the Role field to value Main.
  11. Set the Debug field to value 0 (zero).
  12. Set the Query Timeout field to value 0 (zero).
  13. Select the value in the DBMS Type field (MSSQL, DB2 or Oracle).
  14. Enter the name of the database created in Step 1. For Oracle, this is the "service name".
  15. Enter the database username and password created in Step 1.
  16. Ensure that the Case Conversion field has the value any.
  17. Save your changes.
  18. Add this newly created DAP as a Connection on the GRAT Application object. When GRAT initializes, it will use the information in this DAP to connect to the repository database.
This page was last edited on April 30, 2014, at 13:23.
Comments or questions about this documentation? Contact us for support!