Royal Smilde
A leading producer of various foodstuffs, founded in 1863. With customers from more than 50 countries worldwide, the family business from Heerenveen has grown into a major player on the international market. Royal Smilde offers more than 1000 products in the field of edibles. The range of foodstuffs varies from basic products, such as oils and baking mixes, to ready-made sauces and salads. It is precisely this diversity that is the strength of the company. The combination of knowledge and quality results in distinctive concepts and offers plenty of room for innovation.
The Challenge
Previously, Royal Smilde obtained necessary information from a data warehouse (DWH), which ran on an outdated Oracle platform (Oracle Warehouse Builder). In addition, the organization complained that the existing software (OWB) no longer supported the business objectives and that the business operations could not be strategically aligned with the continuously moving market. Business Data Challengers (BDC) took on the challenge to design and set up a future-proof data warehouse for Royal Smilde based on BDC-GRIP.
The Inspiration
By means of BDC-GRIP, data flows are developed, executed and managed in a simple manner. In a short time, a complete data warehouse is realized and the old environment is phased out. After the smooth migration and implementation, the new DWH is then fully available to the company.
The Elaboration
For Royal Smilde, BDC-GRIP was installed on the existing infrastructure. The outdated Oracle Warehouse Builder software was phased out and all existing data from Royal Smilde was migrated to BDC-GRIP. Within 30 hours, the new BDC-GRIP data warehouse was implemented and expanded with additional sources. Complex calculations within the reporting software are now a thing of the past. Not only has the lead time for loading the entire DWH been greatly improved, but the reports on the end user's screen are also available many times faster. This solution also enables fast and easy unlocking of (new) sources.
The Result
Migration and Implementation: Within 40 hours
License Fees – 50%
Charging time DWH: 5 hours > 30 min.
Report loading time: 45 min. > 20 sec.
The Added Value
Thanks to the implementation of BDC-GRIP, Royal Smilde is able to make strategic choices based on data-driven facts. Combined with even more source access and smart ways to process this data, the company is assured of a development that fits its ambition.
“This expansion of knowledge then results in distinctive concepts and offers room for innovation.”
Are you curious about what our Challengers can do for you?