Enterprise Information Catalog
This section describes new features in Enterprise Information Catalog version 10.1.1.
Business Glossary Integration
Effective in version 10.1.1, Analyst tool business glossaries are fully integrated with Enterprise Information Catalog.
You can perform the following tasks with business glossary assets:
- View business glossary assets in the catalog.
You can search for and view the full details for a business term, category, or policy in Enterprise Information Catalog. When you view the details for a business term, Enterprise Information Catalog also displays the glossary assets, technical assets, and other assets, such as Metadata Manager objects, that the term is related to.
When you view a business glossary asset in the catalog, you can open the asset in the Analyst tool business glossary for further analysis.
- Associate an asset with a business term.
You can associate a business term with a technical asset to make an asset easier to understand and identify in the catalog. For example, you associate business term "Movie Details" with a relational table named "mv_dt." Enterprise Information Catalog displays the term "Movie Details" next to the asset name in the search results, in the Asset Details view, and optionally, in the lineage and impact diagram.
When you associate a term with an asset, Enterprise Information Catalog provides intelligent recommendations for the association based on data domain discovery.
For more information about business glossary assets, see the "View Assets" chapter in the Informatica 10.1.1 Enterprise Information Catalog User Guide.
Column Similarity Profiling
Effective in version 10.1.1, you can configure and perform column similarity profiling. Column similarity profiling implies preparing metadata extracted from data sources for discovering similar columns in your enterprise data. You can then attach data domains to similar columns for faster and efficient searches for similar data in Enterprise Information Catalog.
Enterprise Information Catalog supports column similarity profiling for the following resource scanners:
- •Amazon Redshift
- •Amazon S3
- •Salesforce
- •HDFS
- •Hive
- •IBM DB2
- •IBM DB2 for z/OS
- •IBM Netezza
- •JDBC
- •Microsoft SQL Server
- •Oracle
- •Sybase
- •Teradata
- •SAP
Data Domains and Data Domain Groups
Effective in version 10.1.1, you can create data domains and data domain groups in Enterprise Information Catalog. You can group logical data domains in a data domain group.
A data domain is a predefined or user-defined Model repository object based on the semantics of column data or a column name. Examples include Social Security number, phone number, and credit card number.
You can create data domains based on data rules or column name rules defined in the Informatica Analyst Tool or the Informatica Developer Tool. Alternatively, you can create data domains based on existing columns in the catalog. You can define proximity rules to configure inference for new data domains from existing data domains configured in the catalog.
Lineage and Impact Analysis
Effective in version 10.1.1, lineage and impact diagrams have expanded functionality. The Lineage and Impact view also contains a tabular impact summary that lists the assets that impact and are impacted by the asset that you are studying.
The Lineage and Impact view has the following enhancements:
- Diagram enhancements
The lineage and impact diagram has the following enhancements:
- - By default, the lineage and impact diagram displays the origins, the asset that you are studying, and the destinations for the data. You can use the slider controls to reveal intermediate assets one at-a-time by distance from the seed asset or to fully expand the diagram. You can also expand all assets within a particular data flow path.
- - You can display the child assets of the asset that you are studying, all the way down to the column or field level. When you drill-down on an asset, the diagram displays the child assets that you select and the assets to which the child assets are linked.
- - You can display the business terms that are associated with the technical assets in the diagram.
- - You can print the diagram and export it to a scalable vector graphics (.svg) file.
- Impact analysis
- When you open the Lineage and Impact view for an asset, you can switch from the diagram view to the tabular asset summary. The tabular asset summary lists all of the assets that impact and are impacted by the asset that you are studying. You can export the asset summary to a Microsoft Excel file to create reports or further analyze the data.
For more information about lineage and impact analysis, see the "View Lineage and Impact" chapter in the Informatica 10.1.1 Enterprise Information Catalog User Guide.
Permissions for Users and User Groups
Effective in version 10.1.1, you can configure permissions for users and user groups on resources configured in Enterprise Information Catalog. You can specify permissions to view the resource metadata in Enterprise Information Catalog or view and enrich the resource metadata in Enterprise Information Catalog. You can also deny permissions to view or enrich resource metadata in Enterprise Information Catalog for specific users and user groups.
New Resource Types
Effective in version 10.1.1, you can create resources for the following data source types:
- Oracle Business Intelligence
- Extract metadata from the Business intelligence tool from Oracle that includes analysis and reporting capabilities.
- Informatica Master Data Management
- Extract metadata about critical information within an organization from Informatica Master Data Management.
- Microsoft SQL Server Integration Service
- Extract metadata about data integration and workflow applications from Microsoft SQL Server Integration Service.
- SAP
- Extract metadata from SAP application platform that integrates multiple business applications and solutions.
- Hive on Amazon Elastic MapReduce
- Extract metadata from files in Amazon Elastic MapReduce using a Hive resource.
- Hive on Azure HDInsight
- Extract metadata from files in Azure HDInsight using a Hive resource.
Synonym Definition Files
Effective in version 10.1.1, you can upload synonym definition files to Enterprise Information Catalog. Synonym definition files include synonyms defined for table names, column names, data domains and other assets in the catalog. You can search for the assets in the Enterprise Information Catalog using the defined synonyms.
Universal Connectivity Framework
Effective in version 10.1.1, Enterprise Information Catalog introduces the Universal Connectivity Framework. Using the framework, you can build custom resources to extract metadata from a range of data sources supported by MITI.