New Tools To Clean Up Bad Data - InformationWeek
Software // Information Management
03:10 PM

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.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
Digital Transformation Myths & Truths
Transformation is on every IT organization's to-do list, but effectively transforming IT means a major shift in technology as well as business models and culture. In this IT Trend Report, we examine some of the misconceptions of digital transformation and look at steps you can take to succeed technically and culturally.
Twitter Feed
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.
Flash Poll