Genesys Info Mart Tenant Views

A Genesys-provided script, named make_gim_view_for_tenant.sql, is used to create views to access data in the Genesys Info Mart fact and dimension tables.

The views are created in:

• Genesys Info Mart database schema, in both multi-tenant and single-tenant environments. • Tenant User database schema, in a multi-tenant environment.

In a multi-tenant environment, the two types of views can be used in combination. Views in Genesys Info Mart Database Schema The purpose of these views (referred to as tenant-specific views in Figure 1) is to provide read-only access to data in the Genesys Info Mart database schema for tenant users who are working only with the data for a particular tenant. A separate set of views is created for each particular tenant. When the tenant administrator creates these views by using the make_gim_view_for_tenant.sql script, the script generates the names for created views.

Multi-tenant deployment applications should query Genesys Info Mart data by using these read-only views, instead of querying the tables and views that reside in the Genesys Info Mart database schema.

To restrict data access in single-tenant deployments, the same script should be used to create a similar set of read-only views. The data organization for the Tenant User that is shown in Figure 1, on page 15, is applicable to the single-tenant deployments in which data-access views are created.

Views in Tenant User Database Schema These views (shown within the Tenant User database schema in Figure 1) can be used to make data access more specific to the needs of a particular tenant user. The tenant administrator creates these views in a separate Tenant User database schema by using the same make_gim_view_for_tenant.sql script. Refer to Appendix D for more information.