Information Builders Case Studies Data Migration Helps Diodes Inc. Generate Consistent Reports

Edit This Case Study Record

	Data Migration Helps Diodes Inc. Generate Consistent Reports Information Builders

Data Migration Helps Diodes Inc. Generate Consistent Reports

Information Builders

Technology Category	Analytics & Modeling - Data-as-a-Service Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries	Electronics
Applicable Functions	Discrete Manufacturing Product Research & Development
Use Cases	Manufacturing System Automation Predictive Maintenance
Services	Data Science Services System Integration
Challenge	Diodes Inc., a Dallas-based manufacturing company, found itself with important information stored in three different enterprise resource planning (ERP) systems after a multi-year acquisition spree. This led to a lack of consistency and difficulty in creating enterprise-level reports. The company wanted to improve data quality and consistency, and also acquire better enterprise reporting tools. The company's reporting problems were only the tip of the iceberg. A larger problem loomed below the surface, in the hodgepodge of databases and software applications from Oracle, PeopleSoft, IBM, Promise, and other vendors. At the time, a majority of Diodes’ reporting was accomplished through data warehouses affiliated with these enterprise applications and ERP systems. Read More
About Customer	Diodes Inc. is a Dallas, Texas-based manufacturing company that produces application-specific discrete and analog semiconductors. The company has grown steadily over the decades, much of it through acquisitions. This growth strategy led to the inheritance of many unique information systems, processes, and software applications. However, the disparate systems made it difficult for managers to apply common business rules or correlate data into cohesive reports. Without pervasive data quality standards, organization-wide metrics were elusive or even impossible to achieve. As a result, operational reporting was often a chore and data quality suffered. The company sought a solution that would allow it to grow in the future, consolidate information into enterprise reports, and improve data quality and consistency. Read More
Solution	Diodes combined iWay Software’s information management capabilities with the analytic reporting capabilities of WebFOCUS to create an information infrastructure that can grow with the business. Diodes built a Microsoft SQL Server-based data warehouse to consolidate revenue information from Excel files, balance sheets, and other corporate reports into one source, accessible to the entire organization. The company used budgeting and forecasting software from Clarity Systems to assist with this part of the process. Then Diodes retained a team of consultants from Information Builders Professional Services to design a new operational data store. Using iWay DataMigrator, the team populated the data store with data from legacy ERP systems. DataMigrator includes powerful extract, transform, and load (ETL) tools for migrating data across back-end systems and consolidating it into data marts, data warehouses, and operational data stores. It can seamlessly bring together information from multiple sources and locations across the business. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Data-as-a-Service

Application Infrastructure & Middleware - Data Exchange & Integration

Applicable Industries

Electronics

Applicable Functions

Discrete Manufacturing

Product Research & Development

Use Cases

Manufacturing System Automation

Predictive Maintenance

Services

Data Science Services

System Integration

Challenge

Diodes Inc., a Dallas-based manufacturing company, found itself with important information stored in three different enterprise resource planning (ERP) systems after a multi-year acquisition spree. This led to a lack of consistency and difficulty in creating enterprise-level reports. The company wanted to improve data quality and consistency, and also acquire better enterprise reporting tools. The company's reporting problems were only the tip of the iceberg. A larger problem loomed below the surface, in the hodgepodge of databases and software applications from Oracle, PeopleSoft, IBM, Promise, and other vendors. At the time, a majority of Diodes’ reporting was accomplished through data warehouses affiliated with these enterprise applications and ERP systems.

About Customer

Diodes Inc. is a Dallas, Texas-based manufacturing company that produces application-specific discrete and analog semiconductors. The company has grown steadily over the decades, much of it through acquisitions. This growth strategy led to the inheritance of many unique information systems, processes, and software applications. However, the disparate systems made it difficult for managers to apply common business rules or correlate data into cohesive reports. Without pervasive data quality standards, organization-wide metrics were elusive or even impossible to achieve. As a result, operational reporting was often a chore and data quality suffered. The company sought a solution that would allow it to grow in the future, consolidate information into enterprise reports, and improve data quality and consistency.

Solution

Diodes combined iWay Software’s information management capabilities with the analytic reporting capabilities of WebFOCUS to create an information infrastructure that can grow with the business. Diodes built a Microsoft SQL Server-based data warehouse to consolidate revenue information from Excel files, balance sheets, and other corporate reports into one source, accessible to the entire organization. The company used budgeting and forecasting software from Clarity Systems to assist with this part of the process. Then Diodes retained a team of consultants from Information Builders Professional Services to design a new operational data store. Using iWay DataMigrator, the team populated the data store with data from legacy ERP systems. DataMigrator includes powerful extract, transform, and load (ETL) tools for migrating data across back-end systems and consolidating it into data marts, data warehouses, and operational data stores. It can seamlessly bring together information from multiple sources and locations across the business.

Impact #1	Managers can determine how the income and expenses of each business unit affect all of the company’s subsidiaries.
Impact #2	Diodes is also developing standard workflows and business rules to ensure consistency from one accounting period to the next.
Impact #3	The company is empowering business users to gather and analyze this information in a self-service environment.

Impact #1

Managers can determine how the income and expenses of each business unit affect all of the company’s subsidiaries.

Impact #2

Diodes is also developing standard workflows and business rules to ensure consistency from one accounting period to the next.

Impact #3

The company is empowering business users to gather and analyze this information in a self-service environment.

Download PDF Version

Overview

Data Migration Helps Diodes Inc. Generate Consistent Reports

Operational Impact