Discovery

IBM InfoSphere Discovery accelerates information centric project deployment and reduces risk by creating a 360º view of data relationships across heterogeneous sources. Using patented capabilities, Infosphere Discovery identifies and documents what data you have, where it is located and how it's linked across systems by intelligently capturing relationships and determining applied transformations and business rules.

• Discover hidden data relationships to define "business objects" (logical groupings of data)

• Reverse engineering transformation logic

• Reverse engineering transformation logic

• Use heuristics and sophisticated algorithms that automate an otherwise time consuming manual process

• Support for source data discovery of Unicode compliant sources

• Support for source data discovery of Unicode compliant sources

• Source data support for a wide range of enterprise data sources including relational databases and any structured data source that can be represented in a text file format such as hierarchical database

• Operating systems supported: Linux, Windows, z/OS

Features

• Cross source column overlap analysis: performs a cross compare of all the columns across many data sources in order to establish a baseline of overlapping data across multiple sources.

• Matching key prototype Hypothesize and test the quality of matching keys on multiple data sources simultaneously

• Empty target modeling and prototype Drag, drop and combine attributes from data sources to prototype a new unified schema. View the profiling statistics for the prototype target data

• Precedence Discovery Automatic generation of attribute matching precedence based on statistical analysis.

• Transformation Rule Discovery IBM Infosphere Discovery features patented algorithms that automate the discovery of complex business rules between two structured data sets: Substrings, concatenations, cross-references, aggregations, case statements, arithmetic equations etc.

• Automatic matching key discovery Algorithms automatically discover the matching key and statistically validates the key between two data sources

• Cross source data preview Provides side by side preview of data across multiple data sources for the same logical row and allow the analyst to see values that match the business rules and anomalies that do not match

• Identification of sensitive information Workflow supports classification of Personally Identifiable Information (PII)

• Business object creation Define complete business objects (logical groupings of related objects e.g. customer) that serve as essential inputs into information-centric projects such as data integration, master data management, data warehousing test data management and data archiving using IBM Optim products

• Import/Export Read mapping specs from CSV and generate source maps to CSV

• Standardize business termsCreate and manage your business vocabulary within InfoSphere Business Glossary

Benefits

• Speeds time-to-value of information centric projects by automating the data relationship discovery process.

• Improves success rates of data dependent projects by providing a 360 degree view of data assets and their complex relationships across heterogeneous sources.

• Increases Collaboration Business objects can easily be discovered, defined and shared with IBM Optim products allowing re-use and faster deployment.

• Reduces development time IT can prototype and test new transformation rules for completeness before data is physically converted and moved. These rules can then be transferred to IBM InfoSphere FastTrack where business data analysts can augment with additional documentation and business logic before generating IBM InfoSphere DataStageIBM InfoSphere DataStage Extract Transform and Load (ETL) jobs

• Enables data governance by providing a centralized, accurate understanding of data relationships across complex heterogeneous data sources.