Modernizing a Global Precision Manufacturer’s Reporting Landscape with Cloud 9 

A fifth-generation, family-owned precision manufacturer serving specialized industries relied on Epicor Kinetic and an on-premises reporting environment to support business reporting. 

The organization’s reporting environment relied on a CData integration with Epicor Kinetic, replicating data into an on-premises SQL Server 2008 database to support Power BI reporting. Using CData to replicate Epicor Kinetic data into an on-premises SQL Server 2008 reporting database that supported Power BI reports and dashboards. The legacy environment relied on broad SQL-level access and lacked structured user groups, role-based access controls, and row-level or table-level security, making access difficult to govern and scale. As the infrastructure approached end of life and reporting processes required increasing manual IT intervention, the manufacturer partnered with Cloud 9 Infosystems to modernize its reporting platform using Azure SQL Database, Power BI, Microsoft Entra ID, and Row-Level Security, providing a more secure and manageable approach to user access and data-level permissions. 

The client is a US-based provider of DOT (Department of Transportation) and FMCSA (Federal Motor Carrier Safety Administration) compliance management solutions for transportation and logistics companies. Its platform supports driver qualification, compliance workflows, reporting and document management functions that carriers depend on to stay compliant and operational every day. When the client needed to move this entire platform off legacy, vendor-managed infrastructure and onto Microsoft Azure, they brought in Cloud 9 Infosystems to lead the Azure application migration and modernization effort.

Company

Global Precision Manufacturing Company 

Location: US 

Industry: Manufacturing 

Practice Areas:

  • Azure SQL Database 
  • Power BI 
  • Microsoft Entra ID 
  • Data and Analytics Modernization 

Challenge

The manufacturer’s reporting environment was anchored around Epicor Kinetic as the system of record for sales orders, quotes, invoices, and customer data. CData replicated approximately 20–30 Epicor tables into an on-premises SQL Server 2008 reporting database on recurring schedules, including once- or twice-daily refreshes, weekly refreshes, and periodic full reloads. This database served as the source for Power BI reports and dashboards. 

Although the data pipeline was operational, the manufacturer faced several limitations: 

The manufacturer sought a trusted partner to help achieve key goals: 

Solution

The manufacturer engaged Cloud 9 Infosystems to modernize the reporting platform while preserving the proven Epicor Kinetic data flow. Cloud 9 assessed the existing reporting architecture and designed a cloud-native Azure Data Platform that addressed infrastructure, governance, semantic modeling, and security together. 

The existing CData replication pipeline, which extracts data from Epicor Kinetic, from the on-premises SQL Server 2008 reporting database to Azure SQL Database. This preserved the working source integration while creating a governed, centralized analytical data store on a scalable cloud foundation. 

Power BI connects directly to Azure SQL Database for in-scope dashboards, reducing or eliminating dependency on the on-premises Power BI Gateway. Cloud 9 also introduced semantic models for Sales, Variance, Margin, and Forecasting logic, creating consistent calculations and a single version of truth across business reporting. 

Security was implemented using Microsoft Entra ID groups for Admin, Finance, and Sales, Power BI workspace role mapping, and Row-Level Security. Sales representatives can view only their own customers’ data, unauthorized users see no data even if a report is opened, and executives retain full access. 

The engagement included architecture assessment, modernization planning, Azure SQL deployment, CData replication reconfiguration, semantic model development, Power BI report modernization, security implementation, validation of core business use cases, user acceptance testing, go-live, and handover. Delivery followed five sprints: Kickoff and Infrastructure, Semantic Modeling, Security Integration, Validation and UAT, and Go-Live and Handover. 

Results

By combining Azure SQL Database, the existing CData replication layer, Power BI, Microsoft Entra ID, and Row-Level Security, Cloud 9 transformed the manufacturer’s infrastructure-dependent reporting model into a scalable, governed, and self-service analytics environment. The solution delivered improvements across several areas:

At the time of implementation, the solution supported approximately 50 users through a flexible, group-based access model. The manufacturer now has a repeatable analytics foundation that can support secure reporting expansion while allowing IT to focus more on platform governance and architecture rather than routine report maintenance.

Latest Blogs

16 Year Microsoft Partner Cloud 9

16+ Years of Partnership 🎉

For over 16+ years, Cloud 9 Infosystems has maintained a strong and enduring partnership with Microsoft—delivering enterprise-grade solutions across cloud, AI, and data platforms. As a Microsoft Designated Solutions Partner, we have consistently enabled organizations to modernize their infrastructure, enhance operational efficiency, and accelerate innovation. This collaboration reflects our shared commitment to driving digital transformation with integrity, expertise, and forward-thinking solutions. As we look to the future, Cloud 9 remains dedicated to empowering businesses through trusted technology and measurable outcomes.

Azure Migration

    Need a personalized recommendation?

    We’re here to help! Let us know what you're looking for.