Configuring the Data Warehouse Time Zone

The default time zone used for loading data into the data warehouse is UTC (Coordinated Universal Time), which is essentially the same as GMT (Greenwich Mean Time).

To change the time zone:

  1. Create an <ATG9dir>/home/servers/server_name/localconfig/atg/
    reporting/datawarehouse/loaders/TimeRepositoryLoader.properties     file.

  2. Edit it to contain the following:

    dateTimeZoneID=tz database timezone

    tz database timezone is a code from the public domain TZ database. For example, the following line sets the time zone to US Central Standard Time (UTC -6 hours):

    dateTimeZoneID=CST

 
loading table of contents...