" /> [SOLVED] ETL_Assistant Timzone - Genesys CTI User Forum

Author Topic: [SOLVED] ETL_Assistant Timzone  (Read 2065 times)

Offline raza990

  • Full Member
  • ***
  • Posts: 214
  • Karma: 5
[SOLVED] ETL_Assistant Timzone
« on: March 29, 2018, 05:03:58 AM »
Advertisement
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]

« Last Edit: April 02, 2018, 03:24:20 AM by raza990 »

Offline hsujdik

  • Hero Member
  • *****
  • Posts: 541
  • Karma: 30
Re: ETL_Assistant Timzone
« Reply #1 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

Offline raza990

  • Full Member
  • ***
  • Posts: 214
  • Karma: 5
[SOLVED] Re: ETL_Assistant Timzone
« Reply #2 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.