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?

Microsoft SQL logo full color
Qlik logo full background

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.

Data Warehouse was built leveraging SQL Server as the RDBMS

SQL Server Integration Services (SSIS) tackled the data integration processes across the multiple ERPs to clean and standardize the data for reporting

Qlik N Printing was used to create pixel perfect reports published on a periodic basis and sent via email to the executive team

Qlik Sense was the data visualization layer leveraged by the larger business team to support standard dashboards and ad-hoc analytics

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.