Data Warehouse
Overview
Provides a central repository for data extracted by a number of means, either for the purposes of direct external reporting or staging data for further processing in other systems under a dedicated workflow. The Service itself includes a scheduling mechanism and a set of API endpoints that provide a number of methods of triggering report extracts.
Scripts are managed through SQL Server Integration Services (SSIS), a component of MS SQL Server, available through the standard MS SQL Licence.
Data can be extracted from the ITAS Operational Database on a recurring schedule or on-demand. The 'records' are stored in tables that exist in a separate (reporting) Database which acts as a repository for the reporting technology of choice.
For an overview of the relationship between the ITAS data and the reporting/analytics tool read this guide provided by Microsoft.
Contents of Data Warehouse
-
Report Factory
An Architectural Pattern for allowing extraction of reporting data generated by (heritage) business applications.
-
Data Factory
An Architectural Pattern for allowing extraction of operational data generated through (SSIS) script.
-
Reporting Stars
Designed with speed of read access in mind, these generic, pre-defined stars are provided to allow reports to be designed based on transaction-level data with the purpose and presentation controlled by the reporting tool of choice.