Creating Table Access Objects
To create a Table Access object, perform the following actions:
- Go to Configuration > System > Configuration Manager.
- Click Table Accesses. The Table Accesses list displays.
- Click the New button.
- Enter the following information. For some fields, you can either enter the name of a value or click the
Browse button to select a value from a list:
- Name—The name of this Table Access object. It can contain up to 254-characters. You must specify a value for this
property, and that value must be unique within the Configuration Database (in an enterprise environment) or within the Tenant
(in a multi-tenant environment).
- Description—A brief description of the Table Access object.
- Table Type—The type of Table Access object in the database. You must
specify a value for this property. Once you set the value, you cannot change it.
- DB Access Point—The Database Access Point through which to access the Table. You must specify a value for this
property. The Database Access Point must serve the Tenant to which this Table Access object belongs.
- Format—The Format of this Table. You must specify a value for this property for all Table types except
Log Table. Once you set the value, you cannot change it.
- Database Table—The name of this table as specified in the database. You must specify a value for this property.
The name length depends on the DBMS type. Genesys recommends that you do not exceed the following vendor-defined limitations:
- 18 characters—for DB2 and Informix databases
- 128 characters—for Microsoft SQL databases
- 30 characters—for Oracle and Sybase databases
- Update Every (seconds)—The number of seconds an application waits before updating the table data in application
memory. This value is required only if the Cacheable check box is checked.
- Cacheable—Indicates whether the Table Access data is mirrored in application memory.
- Tenant—In a multi-tenant environment, the Tenant to which this object
belongs. This value is automatically set to the Tenant that was specified in the Tenant Directory field in the object list.
- State Enabled—If selected, indicates that the object is in regular
operating condition and can be used without any restrictions.
- Click the Save button.