DEVELOPMENT OF AN AUDIT-PROOF WAREHOUSE MODULE

Audit-proof future with Microsoft Azure, Microsoft SQL DWH, and Cognos reporting

CUSTOMER PROFILE

Industry: Retail
Headquarters: North Rhine-Westphalia

REQUIREMENTS

Expansion of the Microsoft SQL Server-based "on-premise" data warehouse with a Microsoft "on-cloud" Azure platform
Integration of new, tamper-proof cash register software in accordance with GOBD
Audit compliance through the use of WORM technology in the cloud
Creation of a nuclear database for analytics and data science on voucher transactions
Data Warehouse Modernization
Preservation of existing Cognos standard reports
Expansion of the Microsoft-integrated customer solution in conjunction with IBM Cognos (BI/reporting)

OUR SERVICES

Agile development and project methodology
Multi-partner management in the development cycle
Cloud-enabled development thanks to customized AzurePure blueprints
Integration of the department through reverse engineering of the existing legacy landscape and prototype development
Flexible modeling approaches through ISR-proven Data Vault approach
Foundation for the modernization of the DWH architecture

CLIENT VALUE

Significantly easier adaptability of the DWH solution
Greater transparency by shifting business logic from distributed upstream systems to the DWH
Improved maintainability of the DWH solution
Near-time access to receipts and transactions for direct operational control in retail

TECHNOLOGIES

Microsoft SQL Server
Microsoft Azure
Jetty Services (XML/JSON)
IBM Cognos
Jira