ERP Systems Consolidated into a Single Data Warehouse
How Tencate Partnered with WhereScape for their Data Automation
The 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.
The 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.
The Results
- Rapidly build a data warehouse for new reporting
- Trustworthy data from track-back and track-forward diagrams
- Automated DDL and DML generation