Challenges
- Inefficient manual integration of disparate data spread across legacy mainframes, enterprise (CRM, ERP, Excel) and Hadoop sources
- Delayed data for business reporting
- High costs in building data integration workflows
Solution
- Denodo deployed to modernize transportation scheduling system (5 – 10 year project)
- Platform used to normalize operational sources, mainframe tables and Hadoop systems
- Data Virtualization used to provide an abstracted view of legacy data while company migrates to a Linux based architecture
Benefits
- Increased efficiency in extracting and combining data due to connectors provided by Denodo to mainframes as well as enterprise and big data sources such as DB2, MS SQL, Oracle, SAP BW, Teradata and Hadoop
- Agile development and data delivery as Denodo’s virtual views enable fast creation of integrated views while also collaborating with middleware entities such as Informatica ETL, IBM Websphere MQ (ESB)
- Reduced impact to business systems and customers due to large scale data and application migration from legacy to a modern data architecture
- Minimal custom development in connecting and leveraging new sources such as Hadoop in existing infrastructure
- Scalability of the Data Virtualization platform to build an enterprise wide data layer to support multiple use analytical and operational cases such as a uniform semantic (MDM) layer and big data integration
