Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: raza990 on March 29, 2018, 05:03:58 AM

Title: [SOLVED] ETL_Assistant Timzone
Post by: raza990 on March 29, 2018, 05:03:58 AM

Hi Guys,

I am facing an issue in ETL_Assistant where I am trying to create New DB Source but under miscellaneous section, the dropdown of timezone is empty. I dont know this timezone is referring to the timezone table in Datamart or its timezone in Genesys CME.


[img width=374 height=480]https://image.ibb.co/jqneun/New_Data_Source.jpg[/img]

Title: Re: ETL_Assistant Timzone
Post by: hsujdik on March 30, 2018, 11:24:59 PM

See this manual:
https://docs.genesys.com/Special:Repository/80rt_ref.pdf?id=13d2e350-c32c-4cc2-a105-fc83600c7efd (Pages 25 through 32)

"These variations are stored in the TIME_ZONE table of the Data Mart."

As far as I know, they are not the timezones defined in CME

Title: [SOLVED] Re: ETL_Assistant Timzone
Post by: raza990 on April 02, 2018, 03:23:33 AM

Thanks hsujdik. It is taking timezone from datamart table TIME_ZONE .. I have tested by changing some timezones in lab environment and the changes in timezone are reflecting in dropdown of ETL_Assistant when creating new ODS source.