Jump to: navigation, search

role

Section: gim-etl
Default Value: No default value
Valid Values: ICON_CFG, ICON_CORE, ICON_MM, ICON_OCS, INFO_MART
Changes Take Effect: For an extraction DAP, the next time that extraction jobs are launched; for the Info Mart DAP, on restart of the Genesys Info Mart Server.


Extraction DAPs

Specifies which data domain Genesys Info Mart will extract through the DAP:

  • ICON_CFG — The DAP specifies the connection information for an IDB from which Genesys Info Mart will extract ICON Configuration details. This role must be associated with one and only one DAP, or with redundant DAPs that constitute one HA set.
  • ICON_CORE — The DAP specifies the connection information for an IDB from which Genesys Info Mart will extract ICON Voice details, including agent activity details. This role is optional, but you need at least one DAP with a role of ICON_CORE or ICON_MM.
  • ICON_MM — The DAP specifies the connection information for an IDB from which Genesys Info Mart will extract ICON Multimedia details, including agent activity details. This role is optional, but you need at least one DAP with a role of ICON_CORE or ICON_MM.
    Warning
    You cannot reconfigure the DAP role from ICON_CORE to ICON_MM, or vice versa, once data extraction occurs.
  • ICON_OCS — The DAP specifies the connection information for an IDB from which Genesys Info Mart will extract ICON Outbound Contact details.
  • For the supported topologies that combine data domains (see Interaction Concentrator Topologies in the Genesys Info Mart Deployment Guide), specify all the applicable roles, separated by commas — for example: ICON_CFG,ICON_CORE,ICON_OCS.
Important
Ensure that the extraction role you specify is consistent with the role that is specified for ICON (in the [callconcentrator] section in both the ICON application and DAP). For more information about the corresponding ICON roles, see ICON role in the Deployment Guide.

Info Mart DAP

  • INFO_MART — The DAP specifies connection information for the Genesys Info Mart Server to access the Info Mart database to read and write data. This role is required; it can be associated with only one DAP.

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

Interaction Database

Also known as IDB. The database that stores data about contact-center interactions and resources at a granular level of detail.
See also Interaction Concentrator.



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

IDB Tables Accessed by Genesys Info Mart

This page lists the IDB tables that the Genesys Info Mart extraction jobs access. The type of data that is extracted depends on the role that is configured for the DAP. For more information about configuring the DAPs that enable Genesys Info Mart to access IDB, see Configuring Required DAPs and the DAP role option.

Important
The following table lists only those IDB tables from which Genesys Info Mart actually extracts data. Genesys Info Mart does not populate all of the Global Interaction Database (GIDB) tables in the Info Mart database schema. For more information about the GIDB tables, see Info Mart Database.
IDB Tables Extracted by Genesys Info Mart
DAP Role Type of Data Tables Extracted
ICON_CFG Configuration details

Data source: Configuration Server

GCX_AGENT_PLACE

GCX_CAMPGROUP_INFO
GCX_ENDPOINT_PLACE
GCX_GROUP_AGENT
GCX_GROUP_PLACE
GCX_GROUP_ROUTEDN
GCX_LOGIN_INFO
GCX_SKILL_LEVEL
GC_AGENT
GC_ANNEX
GC_CALLING_LIST
GC_CAMPAIGN
GC_ENDPOINT
GC_GROUP
GC_IVR
GC_IVRPORT
GC_LOGIN
GC_PLACE
GC_SCRIPT
GC_SKILL
GC_SWITCH
GC_TENANT
GC_TIME_ZONE
G_DSS_CFG_PROVIDER

ICON_CORE Voice details (including voice interactions; voice agent activity; user data; and ACD and virtual-queue activity)

Data source: T-Server

GSYS_SYSPROCINFO

G_IR
G_IS_LINK
G_IS_LINK_HISTORY
G_CALL
G_CALL_STAT
G_PARTY
G_PARTY_HISTORY
GX_SESSION_ENDPOINT
G_VIRTUAL_QUEUE
G_ROUTE_RESULT
G_ROUTE_RES_VQ_HIST
G_USERDATA_HISTORY
G_SECURE_USERDATA_HISTORY
G_LOGIN_SESSION
G_AGENT_STATE_HISTORY
G_AGENT_STATE_RC
G_AGENT_STATE_RC_A
G_DND_HISTORY
G_CUSTOM_DATA_S
G_DSS_GCC_PROVIDER
G_DSS_GLS_PROVIDER

ICON_MM Multimedia details (including multimedia interactions; multimedia agent activity; user data; and interaction queue, interaction workbin, and virtual-queue activity)

Data source: Interaction Server

G_IR

G_CALL
G_PARTY
G_PARTY_HISTORY
GX_SESSION_ENDPOINT
G_AGENT_STATE_HISTORY
G_AGENT_STATE_RC
G_AGENT_STATE_RC_A
G_VIRTUAL_QUEUE
G_ROUTE_RESULT
G_ROUTE_RES_VQ_HIST
G_USERDATA_HISTORY
G_SECURE_USERDATA_HISTORY
GM_F_USERDATA
GM_L_USERDATA
G_LOGIN_SESSION
G_DND_HISTORY
G_CUSTOM_DATA_S
G_DSS_GCC_PROVIDER
G_DSS_GLS_PROVIDER

ICON_OCS Outbound Contact details

Data source: Outbound Contact Server

GO_CHAIN

GO_CHAINREC_HIST
GO_FIELDHIST
GO_SEC_FIELDHIST
GO_METRICS
GO_CAMPAIGN
GO_CAMPAIGNHISTORY
GOX_CHAIN_CALL
G_DSS_GOS_PROVIDER

This page was last edited on September 3, 2019, at 20:08.
Comments or questions about this documentation? Contact us for support!