SAH from TSS Data Loads
What is a data load?
Data loads occur in two steps. The first step is using data integration tools to pull data from the source system and add to the Activity Hub drop location. The second step is processing the data through the various levels of each Activity Hub until the new data reaches the FCV level. The AH-Data Load Status Report will tell you when the data has completely reached the FCV layer is available for Cognos, Tableau and Column Group users.
What impacts a data load?
Source system availability.
Data integration technology used and availability.
Amount of data being loaded.
Hana Production data loads take priority over Hana QA data loads.
The number of other data sources the Activity Hub is sourcing.
What would I see in SAH during the data load window?
Slowness, failed reports, if you are looking prior to when the FCV is being loaded you will see old data, if you are looking exactly when the FCV is being loaded you will see no data.
Current Schedule - Hana Prod (starting 7/28)
Time | TSS to Hana Prod | ISIS* to Hana Prod |
|---|---|---|
10pm | Pull data from TSS Prod | n/a |
11pm | TSS lock out | n/a |
12am-Early morning | Load to views | Pull data from ISIS Prod and load views |
When will new data be available? | See AH-Data Load Status Report Select Hana Prod | See AH-Data Load Status Report Select Hana Prod |
Normal Schedule - Hana Prod
Time | TSS to Hana Prod | ISIS* to Hana Prod |
|---|---|---|
12am - Early morning | Pull data from TSS Prod and load views | Pull data from ISIS Prod and load views |
When will new data be available? | See AH-Data Load Status Report Select Hana Prod | See AH-Data Load Status Report Select Hana Prod |
Current Schedule - Hana QA (starting 7/28)
Time | TSS to Hana QA | ISIS* to Hana QA |
|---|---|---|
9pm | Pull data from TSS Prod | n/a |
11pm | TSS lock out | n/a |
8am-Late morning | Load views (must wait for ISIS data) | Pull data from ISIS Prod and load views |
When will new data be available? | See AH-Data Load Status Report Select Hana QA | See AH-Data Load Status Report Select Hana QA |
Normal Schedule - Hana QA
Time | TSS to Hana QA | ISIS* to Hana QA |
|---|---|---|
1am start | Pull data from TSS Prod | n/a |
5am start | n/a | Pull data from ISIS Prod |
7am to Late Afternoon | Load views | Load views |
When will new data be available? | See AH-Data Load Status Report Select Hana Prod | See AH-Data Load Status Report Select Hana Prod |
*There are additional data sources for SAH that are not reflected on this page that impact when SAH data is available.