Redesign of data interfacing and exchange from the data warehouse
The project consisted of redesign and improvements of data exports from the existing data warehouse.
The BI team wanted to take ownership of the export creation and optimise the process. Initially this was managed by the .NET team. The export files are being used by internal systems like the webshop or could be sent to external parties like suppliers.
A redesign to the T-SQL views was done and a Operational Data Store was created to make the XML exports independent (and not impacting) from the data warehouse. SSIS packages, stored procedures and C# was used to be able to epxort the views to XML. The files were accessible via FTP and made available to internal teams and external parties.