New Tools To Clean Up Bad Data - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management

New Tools To Clean Up Bad Data

Business Objects and IBM introduce tools to help businesses clean up inaccurate or contradictory data

Much business data is scattered across disparate databases, making it tough to mine that data for useful information, build and improve customer relationships, simplify supply chains, and support other business initiatives. Two products released last week show how vendors are trying to crack this problem from different market segments.

To help companies get their data act together, business intelligence vendor Business Objects last week unveiled an enterprise information management strategy that includes new information integration and metadata management tools. IBM on the same day unveiled a release of WebSphere Product Center for building a master data management repository for product data.

As data proliferates, managers and workers increasingly are unable to integrate disparate data to get a comprehensive view of their customers, or they can't trust the data they're using for business decisions because of inconsistencies (see story, "Hamstrung By Defective Data"). Businesses recognize they need to address the problem. Only 19% of 672 data pros surveyed by the Data Warehousing Institute last year rated their use of enterprise information integration technologies as high or medium, but 52% expected it to reach that level in two years.

Easier Queries

Data DisconnectBusiness Objects unveiled Data Federator, a tool for enterprise information integration that lets users get a virtual, consolidated view of data from multiple sources without physically moving it into a single database. The software, which uses technology the company acquired in October when it bought Medience, lets users more easily perform queries against real-time data generated by ERP, CRM, and other systems. Most data integration is done in batch mode on a daily or even less-frequent basis--too slow for some business intelligence needs.

The vendor also debuted Metadata Manager, software that collects and combines metadata from databases, business intelligence tools, and data extraction, transformation, and loading systems. That lets administrators see and analyze metadata relationships and better understand the impact of changes in data sources throughout a business intelligence environment.

While Cognos and Business Objects offer data extraction, transformation, and loading software for batch-mode data integration, Business Objects is the first BI vendor to expand into enterprise information management, which means it will be battling vendors such as BEA Systems, IBM, Informatica, and Oracle.

IBM has its own approach. While customer data integration has been getting a lot of attention, providing a central repository of data about products such as pricing, product codes, and product dimensions can be just as critical. Such information is often siloed in disparate databases, which causes confusion, delays in getting products on shelves, and angry customers.

The most significant element of the new WebSphere Product Center release is a Java API that lets the software work within a service-oriented architecture, making it easier for companies to build links between the software and other operational applications. The new release also makes it easier to search for more detailed information using a SQL-like query language instead of custom scripts.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
White Papers
More White Papers
IT Careers: Top 10 US Cities for Tech Jobs
Cynthia Harvey, Freelance Journalist, InformationWeek,  1/14/2020
Predictions for Cloud Computing in 2020
James Kobielus, Research Director, Futurum,  1/9/2020
What's Next: AI and Data Trends for 2020 and Beyond
Jessica Davis, Senior Editor, Enterprise Apps,  12/30/2019
Register for InformationWeek Newsletters
Current Issue
The Cloud Gets Ready for the 20's
This IT Trend Report explores how cloud computing is being shaped for the next phase in its maturation. It will help enterprise IT decision makers and business leaders understand some of the key trends reflected emerging cloud concepts and technologies, and in enterprise cloud usage patterns. Get it today!
Flash Poll