PEC-WFM/Current/ETLRef/Preface - Revision history

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

2020-07-25T02:39:27Z

Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"

2020-07-15T11:46:24Z

Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Mhachey: Published

2020-06-12T15:52:56Z

Published

Bgrenon: Published

2020-06-08T15:21:15Z

Published

New page

{{Article
|Standalone=No
|DisplayName=Preface
|TocName=Preface
|Context=Find out who the intended audience is for this guide before using and preparing the ETL database schema.
|ComingSoon=No
|Platform=PureEngage
|Role=Administrator
|Section={{Section
|alignment=Vertical
|structuredtext=The Workforce Management (WFM) Extract, Transform, and Load (ETL) database schema enables Genesys Interactive Insights and other third-party reporting applications to easily create reports that incorporate Genesys WFM data. Once configured, this functionality can obtain Schedule, Adherence, and Performance information from WFM and store it into a documented relational database schema.

The ETL schema can co-exist with the main operational WFM database, be a standalone database, or part of any other database. WFM provides the SQL script to create the database schema, but does not specify which physical tablespace, user, or database on which to create it. The script is included in WFM Database Utility (DBU) IP, but is not executed automatically by the DBU.

|Status=No
}}{{Section
|sectionHeading=Intended audience
|anchor=IntendedAudience
|alignment=Vertical
|structuredtext=This reference guide is intended for:

*Reporting and business analysts who want to leverage the data that is contained in Genesys WFM, Data Mart, Info Mart and other third party applications to produce reports for business users.
*IT administrators who want to gain an understanding of the components that enable WFM.

This reference assumes that the reader understands of the following:

*Relational database concepts.
*Structured Query Language (SQL) for querying and mining data.
*Genesys WFM configuration and its data sources.
*Data warehouse concepts—including working with star schema, dimensions, aggregates, and measures.
*Extraction, transformation, and loading (ETL) concepts.
|Status=No
}}{{Section
|sectionHeading=Abbreviation of database terms
|anchor=Abbrev
|alignment=Vertical
|structuredtext=This reference uses abbreviations throughout all topics to provide detailed information about and within the tables, including a concise listing of primary and foreign keys, default field values, and mandatory fields for each table. The field and index abbreviations for database terms are described here:
{{{!}} border="1"
{{!}}-
!Field characterizations
!Index characterizations
{{!}}-
{{!}}'''P'''—Primary key
{{!}}'''C'''—Cluster
{{!}}-
{{!}}'''M'''—Mandatory field
{{!}}'''U'''—Unique
{{!}}-
{{!}}'''F'''—Foreign key
{{!}}
{{!}}-
{{!}}'''DV'''—Default value
{{!}}
{{!}}}
|Status=No
}}
}}

@@ Line 5: / Line 5: @@
 |Context=Find out who the intended audience is for this guide before using and preparing the ETL database schema.
 |ComingSoon=No
-|Platform=GenesysEngage-onpremises
+|Platform=GenesysEngage-cloud
 |Role=Administrator
 |Prereq=

@@ Line 7: / Line 7: @@
 |Platform=PureEngage
 |Role=Administrator
 |Section={{Section
 |alignment=Vertical
 |structuredtext=The Workforce Management (WFM) Extract, Transform, and Load (ETL) database schema enables Genesys Interactive Insights and other third-party reporting applications to easily create reports that incorporate Genesys WFM data. Once configured, this functionality can obtain Schedule, Adherence, and Performance information from WFM and store it into a documented relational database schema.
 The ETL schema can co-exist with the main operational WFM database, be a standalone database, or part of any other database. WFM provides the SQL script to create the database schema, but does not specify which physical tablespace, user, or database on which to create it.  The script is included in WFM Database Utility (DBU) IP, but is not executed automatically by the DBU.
 <!--To set up an ETL database, see {{Link-SomewhereInThisVersion|manual=|topic=ETLDB|anchor=|display text=Using ETL Database Schema - BROKEN LINK - }} in the {{Link-SomewhereInThisVersion|manual=|topic=Welcome|anchor=|display text=<i>Workforce Management Administrator's Guide</i> - BROKEN LINK - }}.-->
 |Status=No
 }}{{Section
@@ Line 18: / Line 25: @@
 |anchor=IntendedAudience
 |alignment=Vertical
 |structuredtext=This reference guide is intended for:
@@ Line 23: / Line 32: @@
 *IT administrators who want to gain an understanding of the components that enable WFM.
-This reference assumes that the reader understands of the following:
+It is assumed that the reader understands of the following:
 *Relational database concepts.
@@ Line 30: / Line 39: @@
 *Data warehouse concepts—including working with star schema, dimensions, aggregates, and measures.
 *Extraction, transformation, and loading (ETL) concepts.
 |Status=No
 }}{{Section
@@ Line 35: / Line 46: @@
 |anchor=Abbrev
 |alignment=Vertical
 |structuredtext=This reference uses abbreviations throughout all topics to provide detailed information about and within the tables, including a concise listing of primary and foreign keys, default field values, and mandatory fields for each table. The field and index abbreviations for database terms are described here:
 {{{!}} border="1"
@@ Line 53: / Line 66: @@
 {{!}}
 {{!}}}
 |Status=No
 }}
 }}

PEC-WFM/Current/ETLRef/Preface - Revision history

WikiSysop: Text replacement - "\|Platform=([^\|]*)GenesysEngage-onpremises([\|]*)" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|]*)PureEngage([\|]*)" to "|Platform=$1GenesysEngage-onpremises$2"

Mhachey: Published

Bgrenon: Published

WikiSysop: Text replacement - "\|Platform=([^\|])GenesysEngage-onpremises([\|])" to "|Platform=$1GenesysEngage-cloud$2"

WikiSysop: Text replacement - "\|Platforms?=([^\|])PureEngage([\|])" to "|Platform=$1GenesysEngage-onpremises$2"