Select Page

Case Study

A global leader in the food industry gains higher operational visibility by switching to a scalable EDM system

Client Background

The client is an Arkansas-based international leader in the food industry

Client Need

  • The client wanted to scale up the legacy data warehouse system built on RDBMS based MPP system and perform real-time analytics on the marketing data in order to generate useful business insights
  • The client was receiving data from various data sources like SAP ERP, JDA, IRI, Acousta and many others, and was facing challenges in integrating the data from these data sources & performing real time analytics on the given data
  • The client wanted to switch to a scalable EDM system which :
    • Is easy to integrate with the other enterprise applications
    • Minimizes the effort spend on data migration and processing

Our Solution

  • Analyzed the various data sources and targets and designed and implemented a suitable Hadoop architecture for the same
  • Designed near real-time ingestion system using Attunity and Kafka to perform real-time batch processing
  • Designed a data warehouse on Hive and HBase for all transactional data processing
  • Used Talend ETL tool to design and develop Spark Streaming and batch jobs
  • Designed OLAP cubes for reporting

Tools & Technologies

Hadoop, Talend, SAP Hana, Kafta, Hortonworks, Hive

Key Benefits

  • Production rate can now be matched with order rate, thereby enabling faster and more informed decisions for sales, pricing, product, and manufacturing teams
  • Provides real-time operational visibility
  • Able to take quicker and informed decisions
  • Lower data integration cost
  • Easily scalable architecture
  • Ability to drill across cubes/data subject in pre-defined and ad-hoc ways
  • Attunity replicates the integrated data into Kafta streams thereby providing a comprehensive view of it to the managers
Key Benefits - Data Management  - Food Industry


Digital Product Engineering

Cloud Services

Data & Analytics

Intelligent Automation

Cyber Security

Build Operate Transfer

Talent Solutions


Communications & Media

Government Solutions

Healthcare, Life Sciences,
and Insurance

Banking & Financial Services

Energy, Oil & Gas and Utilities


Retail & CPG
Manufacturing & Automotive

Travel & Transportation and Hospitality



Automation Anywhere









Innovation @ Work

Blogs and Insights

Research and Whitepapers

Case Studies


Webinars & Tech Talks
US Employment Reports


About Us

Leadership Team

Strategic Partnerships

Office Locations

News and Events


The Innova Foundation


Explore Open Positions

Life @ Innova Solutions

Candidate Resource Library

Let's Connect