Configuration and support for enterprise data warehouse 2018
Project duration: 1 year
Brief description
Source data from connected CRM, ERP and other source systems are imported to the supported enterprise data warehouse. The source data are consolidated if necessary and then made available to connected data marts or for other analysis purposes.
Supplement
The support includes the necessary configuration of the relational databases and interfaces (inbound and outbound) associated with this enterprise data warehouse (EDW). This configuration is necessary due to the setup of new interfaces, adaptations caused by modifications in used source systems or, particularly for outbound interfaces, due to version upgrades of the connected data marts. This also includes the creation of necessary change requests and their tasks where these activities are documented. In addition, interface malfunctions documented by means of incidents are analyzed and corrected, and inquiries (service calls or incidents) from domestic and foreign subsidiaries are processed.
Subject description
The enterprise data warehouse (EDW) which is the topic of this support activity centralizes business information from multiple source systems and applications. The source data are consolidated if necessary and then made available for analytics and BI within data marts. Creation and modification of inbound and outbound interfaces is performed by configuration tasks within this EDW.