Genesys Info Mart Tenant User Schema and Tenant Views
A Genesys-provided script, named make_gim_view_for_tenant.sql, is used to create read-only 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 the Genesys Info Mart Database Schema
The purpose of these views (referred to as tenant-specific views in the Genesys Info Mart Data Organization and Tenant Views diagram) 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, use the same script to create a similar set of read-only views. The data organization for the Tenant User that is shown in the Genesys Info Mart Data Organization and Tenant Views diagram is applicable to single-tenant deployments in which data-access views are created.
Views in the Tenant User Database Schema
These views (shown within the Tenant User database schema in Genesys Info Mart Data Organization and Tenant Views) can be used to make data access more specific to the needs of a particular tenant user. The tenant administrator creates these views in separate Tenant User database schemas by using the same make_gim_view_for_tenant.sql script.
Because each tenant’s data is exposed through a different database schema, tenant administrators can control user access to tenant-specific data.
Each Tenant User schema has a view on a single DATE_TIME table, so each schema supports a single time zone. To provide reports in multiple time zones, the downstream report developer must use a separate Tenant User schema for each time zone.
The Genesys Info Mart Data Organization and Tenant Views diagram shows a Tenant User schema that contains table views for only one tenant. However, to simplify deployment of the reporting solution, Genesys Info Mart supports creating table views for more than one tenant in the same Tenant User schema. Therefore, the tenant administrator does not need to create a separate Tenant User schema for each combination of time zone and tenant. Instead, the tenant administrator can include all tenants, or a group of tenants, in a single schema per time zone. For more information, see Creating Read-Only Tenant Views in the Genesys Info Mart Deployment Guide.
Each Tenant User database schema contains:
- Dimension views
- Fact views
The structure of the views created in the Tenant User database schema is identical to that of their underlying dimension and fact tables or views in the Genesys Info Mart database schema. For this reason, subject area diagrams and descriptions for the Tenant User views are not provided in this document.
A Tenant User database schema contains the following views, as well as additional views that are created for custom user data tables. For internal reasons in the case of some of the dimension views, the Tenant User schema includes views of both the dimension view and its underlying table.