Challenge
Tencate had separate teams operating data marts in the United States and the Netherlands. They had been generating reports from two regions but wanted to report globally. They undertook a project to combine two separate ERP systems into a single data warehouse.
Solution
WhereScape offered a single tool for designing, developing, deploying, operating, and maintaining a data warehouse. The previous data marts had used SSIS and Excel, along with many other tools, for reporting. Creating a full data warehouse with WhereScape and combining data from both ERP systems made the creation of reports and reporting data much simpler and faster.
Results
- Rapidly build a data warehouse for new reporting
- Trustworthy data from track-back and track-forward diagrams
- Automated DDL and DML generation