You are here

Inter Pipeline Ltd.

Challenges

  • “Floating in a sea of spreadsheets” – 1/3rd of the data in excel
  • “Every single piece of master data is causing grief on a daily basis” - inconsistent data due to redundancies
  • Incorrect data impacting insights and decisions
  • Multiple upcoming source systems migration and modernization projects

Solution

  • Denodo was deployed to provide a normalized virtual view of sources, including databases, datawarehouses, and spreadsheets
  • Virtual ‘right time’ data marts were built to feed data in a timely fashion to reporting processes from data warehouses as well as real-time feeds from field equipment
  • Denodo was used to issue data quality alerts (via email) and provide write-back capabilities that enabled users to fix quality issues

Benefits

  • Increased trust in data due to minimized replication
  • Reusable data services ensured consistent business logic and data across the enterprise while increasing agility
  • Abstraction layer provided by Data Virtualization minimized disruptions caused due to migration of data and applications

Notable Data Sources

Databases - MS SQL & SQL Server Integration Services (SSIS)
Datawarehouses – Essbase
Excel and PowerPivot

Notable Data Consumers

Reporting – MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)
Tableau
ETL – Informatica Powercenter Express

Our Customers