Aptitive transformed disparate data sources into a central data hub that allows users faster, more accurate access to their data

Client Industry

Global Manufacturing Company

Technology Used

JDE 9.1
Cognos 10
Attunity
TM1
SQL Server Integration Services
SQL Server

The Challenge

Our client had an older ERP that required a significant amount of manual manipulation and resulted in low quality reporting.

Our Solution

In conjunction with a larger ERP upgrade project, Aptitive implemented a central Data Hub to combine disparate sources, manage quality, and act as a “single source of the truth” for multiple reporting tools including Cognos, TM1, and a variety of custom applications. The system used Aptitive’s ETL Framework, SSIS, and SQL Server to transform operational data into an analyzable data warehouse. Aptitive also supported the integration of new applications into the centralized data hub.

The Outcome

Our client now has a foundation for a comprehensive business intelligence ecosystem, business users have faster, more accurate access to their data, and the new BI system has replaced dozens of obsolete technologies and reporting designs.

Client Industry

Global Manufacturing Company

 

Technology Used

JDE 9.1
Cognos 10
Attunity
TM1
SQL Server Integration Services
SQL Server