Portals eNewsletters Web Seminars dataWarehouse.com DM Review Magazine
DM Review | Covering Business Intelligence, Integration & Analytics
   Covering Business Intelligence, Integration & Analytics Advanced Search
advertisement

RESOURCE PORTALS
View all Portals

WEB SEMINARS
Scheduled Events

RESEARCH VAULT
White Paper Library
Research Papers

CAREERZONE
View Job Listings
Post a job

Advertisement

INFORMATION CENTER
DM Review Home
Newsletters
Current Magazine Issue
Magazine Archives
Online Columnists
Ask the Experts
Industry News
Search DM Review

GENERAL RESOURCES
Bookstore
Buyer's Guide
Glossary
Industry Events Calendar
Monthly Product Guides
Software Demo Lab
Vendor Listings

DM REVIEW
About Us
Press Releases
Awards
Advertising/Media Kit
Reprints
Magazine Subscriptions
Editorial Calendar
Contact Us
Customer Service

Data Integration Adviser:
It is all About the Data

  Column published in DMReview.com
April 1, 2006
 
  By Rick Sherman

If you work in IT, you better like alphabet soup: master data management (MDM); customer data integration (CDI); corporate performance management (CPM); business intelligence (BI); enterprise application information (EAI); enterprise integration information (EII); extract, transform and load (ETL); Sarbanes-Oxley (SOX); and Health Insurance Portability and Accountability Act (HIPAA).

We get new acronyms each year. Analysts, vendors and consultants rattle them off in articles and client discussions. Faced with an unfamiliar term you might feel dumb, then investigate and find it is just data integration wrapped up in new acronyms. Sometimes it is a new approach, but often it is a new term for an old method. Maybe the old approach sputtered due to lack of disk I/O or network capacity was abandoned and forgotten, and has now been resurrected with a new name.

Breathing new life into old concepts is invigorating but can carry risks. It is risky when a concept doesn't leverage past lessons and repeats past mistakes. Parochialism is another risk, blinding people to the fact that their problems are actually the same as other people's problems.

I am always explaining to people in one industry that every other industry also has similar data issues, and they could learn from other successful data implementations regardless of what industry they are in. It is amazing that even people in different divisions in the same company can think they have unique issues and, therefore, work in data silos. It is a recipe for overlapping data warehouses, data marts and business intelligence efforts.

Old Concepts with New Names

As for old concepts with new names, let's start with inconsistent dimensional data, such as product or part numbers. Now it is called MDM. We've been dealing with this for more than a decade in data warehousing and BI - calling it conforming dimensions. We called it making consistent reference data in the 1980s.

Consistent customer data across the enterprise is not new, either, but it has a new name: CDI. Remember 360 degrees of the customer? The customer relationship management (CRM) folks keep inventing new terms for integrating customer data because their stovepipe applications (call centers, campaign management, sales force automation, etc.) lend themselves to keeping customer data fragmented. They stovepipe it and then build applications to put it back together!

Data Integration is the Commonality

What do all these problems have in common? It's all about the data - data integration. Some of these acronyms are nothing more than data integration applied to a specific subject area - MDM or CDI - or business process.

Some new names just describe the use of new or different technology to achieve data integration - such as EAI, EII and Web services rather than ETL. It is still data integration. Source-to-target mapping as well as data transformation according to business rules - that's not new, regardless of the transportation used or whether it is real time or batch.

It is the same story with databases. In the old days, you needed to understand how data was stored on disk, but now the database handles it. At some point you'll do data integration and won't worry about whether ETL, EAI, EII or something else is performing the data integration. You'll concentrate on what you are trying to do, not how the underlying tools are performing the processes.

Business requirements such as SOX and financial transparency depend on data integration, but who realizes that? Instead, we're investing in the development of new applications. We're hung up on software and buzzwords instead of concentrating on data integration. Data warehousing isn't old fashioned, even if the terminology changes over time.

It's all about the data. Let's continue to discuss new and old trends, methods, best practices and what is important as we cut through the acronym alphabet soup to get to the important issues.

...............................................................................

For more information on related topics visit the following related portals...
Customer Data Integration, Data Integration, Enterprise Information Management and Master Data Management.

Rick Sherman has over 20 years of business intelligence and data warehousing experience, having worked on more than 50 implementations as a director/practice leader at a Big Five firm and while managing his own firm. He is the founder of Athena IT Solutions, a Boston-based consulting firm that provides data warehouse and business intelligence consulting, training and vendor services. Sherman is a published author of over 50 articles, an industry speaker, a DM Review World Class Solution Awards judge, a data management expert at searchdatamanagement.com, and has been quoted in CFO and Business Week. You can reach him at rsherman@athena-solutions.com or (617) 835-0546.

Sherman can be found blogging on performance management, data warehouse and business intelligence topics at The Data Doghouse. His most recent post is at http://datadoghouse.typepad.com/data_doghouse/2006/07/database_market_1.html.

Sherman's comprehensive, highly acclaimed onsite DW/BI training can be customized for your IT and business groups' needs. Public courses are taught in the Boston area. His detailed data warehousing and business intelligence assessments ensure that your project has the best chance for success and stays within budget. See www.athena-solutions.com for details.



E-mail This Column E-Mail This Column
Printer Friendly Version Printer-Friendly Version
Related Content Related Content
Request Reprints Request Reprints
Advertisement
advertisement
Site Map Terms of Use Privacy Policy
SourceMedia (c) 2006 DM Review and SourceMedia, Inc. All rights reserved.
SourceMedia is an Investcorp company.
Use, duplication, or sale of this service, or data contained herein, is strictly prohibited.