DataFlux

Every year your organization is accumulating increasing amounts of corporate data. Controlling this data means launching data quality and data integration projects to create a more consistent, accurate and reliable view of the enterprise. Fortunately, there's a way to get these projects off the ground faster and more reliably - metadata analysis.

Metadata is the data about your corporate data, found in every data source throughout your enterprise. Metadata is what describes the information in your data resources. With metadata analysis you get a clear view of these resources - and the most efficient strategy for success with your data quality and data integration initiatives.

With metadata analysis, you can:

• Organize your data logically across all of your data sources
• Simplify projects by accurately grouping related data and excluding irrelevant data
• Gain a clear understanding of what data should be included in any data-intensive project

Metadata analysis allows you to understand the exact nature of the information in all of your corporate data sources, organize it successfully, and ensure that all of your data quality initiatives run smoothly.

The foundation for faster, more comprehensive data quality and data integration

dfPower Explorer, a component of the award-winning dfPower Studio suite, integrates metadata discovery into the DataFlux technology platform. dfPower Explorer allows you to understand what data resources you have - and then, extract and organize metadata from any source anywhere throughout the enterprise.

dfPower Explorer allows you to understand the complete universe of your data before you begin any detailed data profiling, data quality or data integration exercise. dfPower Explorer allows you to:

• Discover various types of data, including customer, product, employee, inventory, etc.
• Ensure that all required data is included within your data profiling, data quality or data integration initiatives
• Build catalogs of similar data types to speed the process of building master repositories for data domains

dfPower Explorer Features

dfPower Explorer helps you quickly and easily accumulate detailed knowledge of thousands of data sources across many systems and platforms. dfPower Explorer gives you the ability to:

• Connect to disparate data sources throughout an enterprise (RDBMS, XML files, spreadsheets, text files, etc)
• Extract the metadata from each source or metadata model (including field name, field data type, field data length)
• Compare the field names/types/formats using fuzzy matching algorithms to identify potential redundancies and relationships
• Report the redundancies to the user as well as catalog the redundancies within a metadata repository
• Streamline initial master data management (MDM) projects by specifying which data should become part of a master repository

Once data relationships have been identified, DataFlux technology can verify and test these relationships by identifying the likelihood of redundancy, verify relationships across sources, and using Dataflux identification analysis to determine the domain of specified columns.