DATA LAKES AND WAREHOUSES – ECOMMERCE

Ecommerce client integrates 7 ERP systems with 1 data warehouse

Overview

Growth through acquisition raises a number of logistical challenges for businesses.

This includes figuring out how to integrate disparate systems and platforms. The more entities an organization acquires or merges with, the more complex its IT environment will become.

One of our clients –  an ecommerce educational, healthcare and agricultural supply company – recently hit the breaking point with its increasingly complicated mix of ERP systems following a period of aggressive expansion. As a result of its M&A activity, it had seven distinct ERP platforms in operation, making it all but impossible to effectively capture a centralized view of the enterprise.

One Six Solutions stepped in to help create a data warehouse solution to integrate those systems and provide more visibility across the entire organization.

The question remains for many businesses: What do they do once they have that data?

Our Solution

Bringing multiple disparate ERP systems under one roof

As the project got underway, our team consulted with the company’s key executive leaders to define requirements and standardize business definitions for a range of metrics and KPIs. We also helped conduct system analysis, data warehouse architecture and development to establish a uniform information management architecture throughout the entire firm.

Using SQL Server 2016 and SSIS for ETL, One Six Solutions created a data warehouse solution that could seamlessly integrate with various ERP systems. We also incorporated Qlik Sense and its NPrinting Platform to facilitate data visualization, data discovery and reporting. In this way, our client’s end users could disseminate their key findings with any stakeholders, including distributing daily reports to the executive leadership team.

The Results

Now that the data warehouse solution has been implemented and integrated with each ERP platform, our client can measure business performance across every division in the organization. The firm has successfully achieved greater visibility into sales, finance and other key operating areas.