Nalco masters data governance with quality management tool

With operations around the globe and more than 70,000 customers in 130 countries, data quality ended up being the hot button in Nalco Company's migration to a single global instance of SAP. “Data governance is a critical issue for the company. Quality data is a key asset,” says Charlon Franklin, senior data steward analyst for the Naperville, Ill.


With operations around the globe and more than 70,000 customers in 130 countries, data quality ended up being the hot button in Nalco Company 's migration to a single global instance of SAP .

“Data governance is a critical issue for the company. Quality data is a key asset,” says Charlon Franklin, senior data steward analyst for the Naperville, Ill.-based water treatment and processing systems manufacturer.

Since bringing its outsourced ERP back inside the company, Nalco has been migrating all global operations to one platform. A year and a half ago it formed the data governance group Franklin heads to ensure data consolidated from multiple sources is consistent, without errors and duplication, and properly formatted to home country and corporate standards.

Nalco selected a best-of-breed data quality management system from DataFlux , an operating unit of SAS , to shore up the data.

“We're bringing up different countries and other companies we've acquired over time that haven't been on SAP,” Franklin says. “We use DataFlux to look at the non-SAP information. Inconsistent data can create all kinds of problems.”

For one, there's a business problem on the demand side, called “hanging orders.”

“Demand planning never gets the order, so it doesn't know that it's supposed to plan for filling an order,” says Franklin. “You leave a customer out there expecting an order, only it doesn't come.”

It's problematic on the supply side, too. “If you have duplicate records for a vendor,” explains Franklin, “you may end up double billing them. DataFlux eliminates duplicate records.”

Prior to implementing DataFlux, Franklin's group used Microsoft Access and Excel as tools to analyze and validate the data migration. “But with CRM, one group had more than 600,000 records,” she says. “As you move from parent-to-child relationships, the database doubles every time.”

Franklin's team uses DataFlux to analyze record sets it receives from multiple sources, determining how large the table or database is and how it's structured.

“It can look at the entire database, or just the fields you select, and can tell you what the values are and if there's something wrong,” says Franklin. “You just have to point the tool to the table you want to analyze, and it runs.”

DataFlux, a data quality integration solution, analyzes records from multiple sources, determining how large the table or database is and how it’s structured. An Architect tool within DataFlux dfPower Studio builds consistent business rules for normalizing and validating data brought in from multiple systems to ensure standard conformance.

Nalco is following a path typical to many companies migrating data to a new system. “There is no direct link currently between SAP and DataFlux,” Franklin says, adding that data is extracted in batches and loaded on a server, where it is cleansed and normalized based on the business rules it has created to govern data. But once the entire migration is complete, Nalco plans to directly link the two systems so analysis will be in real time.

“Full rules monitoring of the database on the front end will trigger notification whenever there's any problem,” Franklin explains.

Next up, Nalco will evaluate the DataFlux Master Data Management component for implementation, in an effort to synchronize all corporate data from a single master data reference file.

The Top Plant program honors outstanding manufacturing facilities in North America. View the 2015 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
Pipe fabrication and IIoT; 2017 Product of the Year finalists
The future of electrical safety; Four keys to RPM success; Picking the right weld fume option
A new approach to the Skills Gap; Community colleges may hold the key for manufacturing; 2017 Engineering Leaders Under 40
Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
The cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Power system design for high-performance buildings; mitigating arc flash hazards
VFDs improving motion control applications; Powering automation and IIoT wirelessly; Connecting the dots
Natural gas engines; New applications for fuel cells; Large engines become more efficient; Extending boiler life

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
The maintenance journey has been a long, slow trek for most manufacturers and has gone from preventive maintenance to predictive maintenance.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me