Enterprise Data Catalog: Intermediate

Home
Explore
Product Learning Path

Home
Explore
Product Learning Path

Learning Path
Enterprise Data Catalog: Intermediate

Level 1

Intermediate: Enterprise Data Catalog 6 hours

Start Learning

Informatica Enterprise Data Catalog (EDC) provides business and IT users with powerful semantic search and dynamic facets to filter search results, data lineage, profiling statistics, 360-degree relationship views, data similarity recommendations, and an integrated business glossary. This enables IT users to be more productive and business users to be able to be full partners in the management and use of data. You can now easily and efficiently manage enterprise data assets to maximize their value throughout the company. Business users can quickly find data and easily manage the lifecycle of business terms, definitions, reference data, and more.

The Intermediate level constitutes of many 'how-to' documents, whitepapers and videos that will help you understand EDC installation, configuration, resource management, monitoring, profiling, similarity discovery and many such concepts.

After you successfully finish all the three levels of EDC product learning, you will earn an Informatica Badge for EDC. So continue on your learning!

Give Feedback

This module covered topics on installation and configuration and getting started with EDC. The section also walked you through the architecture, resource management, configuring security, Business Glossary, Custom Model, Resource Management, Scanners, Schedule Management, Monitoring, and Resource Security.

This module also covered EDC Profiling, Data Domains, Similarity Discovery, Attribute Management, classifications and Connection Assignment that includes creating a connection, refreshing the connection list, viewing a connection, configuring pooling for a connection, editing and testing a connection and deleting a connection.

You also learned about Synonyms, how to add synonyms to your search, Lineage, Lineage Export, custom lineage options, how to get detailed lineage in EDC for PowerCenter mappings and Intelligent Business Glossary Association.

Now move on to the Advanced level for your EDC product journey and get to know more about the product.

Back to Learning Path

Next Level: Advanced

Installation and Configuration

1.1

EDC Installation and Configuration

update

Architecture

2.1

Understanding EDC Architecture

60 minutes

2.2

EDC 10.2.2 Architecture Updates

60 minutes

Resource Management

3.1

Resource Creation

5 minutes update

3.2

Resource Management Articles

Performance

4.1

Tuning EDC performance

5 minutes update

Schedule Management

5.1

Resource Scheduling

5 minutes

Monitoring

6.1

Monitoring Tasks in Catalog Admin

5 minutes

Resource Security

7.1

Configuring Resource Security

5 minutes

EDC Profiling

8.1

Configuration

15 minutes

Data Domains

9.1

Creating a Data Domain

5 minutes

9.2

Data Domain Curation

5 minutes

9.3

Creating a Composite Data Domain

5 minutes

Similarity Discovery

10.1

Similar Columns

5 minutes

Attribute Management

11.1

EDC Excel Import for Custom Attributes

15 minutes

11.2

Editing a System Attribute

5 minutes

11.3

Creating a Custom Attribute

5 minutes

Classifications

12.1

Classifications in EDC

10 minutes

Connection Assignment

13.1

Connection Assignment in EDC

5 minutes

Synonyms

14.1

Adding Synonyms

5 minutes

Lineage

15.1

Lineage in EDC

15 minutes

Glossary Association

16.1

Glossary Association in EDC

5 minutes

16.2

EDC: Creating picklist custom attributes using BG

15 minutes

Advanced Concepts

17.1

Use Cases

20 minutes

Webinars

18.1

Meet the Expert Webinar on EDC 10.4

1 hour new

Go through the following documents and Knowledge Base articles to understand Enterprise Data Catalog (EDC) installation and configuration:

EDC Installation and Configuration

EDC Installation: High-Level Overview

HOW TO: Validate EDC pre-requisites

HOW TO: Deploy EDC on Azure

HOW TO: Deploy EDC & EDP

HOW TO: Configure Ports in EDC

HOW TO: Configure SSL for EDC

HOW TO: Switch from non-Kerberos to Kerberos

HOW TO: Switch from non-TLS enabled to TLS

FAQ: What are the perquisites for IHS

HOW TO: Validate utility for IHS Prerequisites

FAQ: What are the IHS load types

HOW TO: Configure IHS on SSL enabled domain

HOW TO: Enable SSL for IHS

HOW TO: Configure SUDO Permission

Deployment & Sizing considerations

IHS Sudoless startup

HOW TO: Configure IHS Custom directory

This Meet the Experts webinar helps you understand the EDC architecture better.

Additional Resource: This document describes the overall architecture of EDC and details the different components the architecture relies on. It talks about the service-oriented architecture that EDC follows, Informatica domain nodes, application services, repository databases, and Hadoop Cluster Services.

Click Here to Read the Document

This video discusses EDC 10.2.2 Architecture Updates, Graph Refactoring, and steps for the upgrade.

This video explains how to create a new resource to extract metadata from an Oracle database, and run data profiling and domain discovery during the extraction process followed by a demo.

EDC Prerequisites for Resource Configuration: This article provides information about the prerequisites for specific resources in Enterprise Information Catalog. For detailed steps and information about installation, see the Informatica Catalog Administrator Guide.

Click here to read the document

Browse through the following articles and documents to learn more about resource management:

HOW TO: Configure snowflake resource

HOW TO: Configure Sybase resource

HOW TO: Configure Oracle cluster resource

HOW TO: Configure Oracle resource

HOW TO: Provide permissions for oracle resource scan

HOW TO: Configure JDBC MYSQL resource

HOW TO: Configure Azure Blob storage

HOW TO: Configure Salesforce resource

HOW TO: Configure Salesforce with Proxy

HOW TO: Configure Databricks

HOW TO: Configure DBScript scanner for BTEQ

HOW TO: Configure Postgres SQL resource

HOW TO: Configure BG Scanner

HOW TO: Configure BG Scanner with SSL

HOW TO: Configure HDFS resource

HOW TO: Configure DB2Zos scanner

HOW TO: Configure Cloud scanner in non SSL domain

HOW TO: Configure Cloud scanner

HOW TO: Configure SAP HANA Scanner

HOW TO: Configure Greenplum JDBC Scanner

HOW TO: Configure Microstrategy Scanner

HOW TO: Configure AWS Dynamo DB JDBC Scanner

HOW TO: Configure Netezza Scanner

HOW TO: Configure Profile warehouse scanner

FAQ's on Google Big Query resource

FAQ's on DBScript resource

Resource types for tracking metadata changes

Parameter files

EDC Catalog Agent

Filter tables and views from Relational source for the profiling in EDC 10.2.2

Use filter option for Source Metadata and Data Profile Filter in EDC 10.2.2

Filter tables and views from Relational source for the metadata scan in EDC 10.2.2

This article provides information about tuning Enterprise Data Catalog performance. Tuning Enterprise Data Catalog performance involves tuning parameters for metadata ingestion, ingestion database, search, and tuning data profiling.

The performance of Enterprise Data Catalog depends on the size of data that needs to be processed. The article lists the parameters that you can tune in Enterprise Data Catalog and the steps that you must perform to configure the parameters based on the data size.

Tuning Enterprise Data Catalog Performance

In this video, you will see how to create reusable schedules. You will also be able to create a reusable schedule to assign multiple resources to the same schedule with the help of a demo in this video.

Additional Resources:

HOW TO: Schedule a resource in Live Data Map

HOW TO: Create a reusable schedule in Live data Map

HOW TO: Change the automatic schedule for DataDomain and DataDomainPropagation system scanner in Enterprise Data Catalog

This video explains how to monitor EDC based on resources and tasks. You will also learn how to use the Catalog Administrator to monitor resources and track the status and schedules of tasks.

Additional Resources:

HOW TO: Monitor the loaded/created resource in Live Data Map

HOW TO: Monitor reindex job in EDC

In this video, you will see how to secure client records in an enterprise or an organization by assigning specific permissions only to authorized users with the help of a demo. You will learn to configure specific permissions and default permissions on resources for users and user groups that are configured in the Informatica domain.

Additional Resource:

Managing Resource Security

Go through the following documents to learn more about profiling in EDC.

Profiling Configurations

HOW TO: Exclude tables/view list for profiling in EDC

Custom Conformance Value

This video explains how to create a data domain. You will learn to create a data domain to discover the functional meaning of data in the data sources based on the semantics of the data with the help of a demo.

In this video, you will see how to curate data domains in bulk. You will also learn how to validate and manage discovered metadata of a data source using Curation so that the metadata is fit for use and reporting with the help of a demo.

In this video, you will see how to create a composite data domain named customer to include details of the customer such as name, email, and gender. You will also learn to create composite data domains using rules with existing data domains and new data domains with the help of a video.

Read more about Data Discovery

As a data analyst or data architect, you can scan your enterprise data to find similar columns. This document will guide you on column similarity that includes how column similarity works, column similarity process, business examples and to propagate business terms.

Click here to read about Similar Columns, Value Frequency, and Permissions for Value Frequency

This video demonstrates the process of using Python to read the contents of Excel, lookup the equivalent catalog object, and update the catalog if necessary with the help of a video.

Additional Resource: EDC - Bulk import custom attributes

This video explains how to use Catalog Administrator to edit the pre-defined system attributes that are extracted as metadata from source systems. With the help of a demo, the video explains how to configure the predefined attribute named author.

In this video, you will see how to create a custom attribute and how to use that attribute. You will learn to create custom attributes that you want EDC users to add to the search filters and include these custom attributes in the catalog.

Additional Resources:

HOW TO: Create Custom Attributes in EDC

HOW TO: Create a custom attribute with an array of pre-defined values in EDC

HOW TO: Search by custom attribute

HOW TO: Export custom attributes

HOW TO: Bulk update custom attribute User datatype

Go through the following Knowledge Base articles to learn about classifications in EDC:

HOW TO: Configure Business classification in EDC

HOW TO: Bulk Update Classifications in EDC

This video explains how to assign a schema to the connection as well as multiple connection assignments. You will also learn to manage connections between resources and schemas by assigning, unassigning, or reassigning connections to resources.

Additional Resources:

HOW TO: Perform connection assignment for multiple connections in EDC

HOW TO: Unassign multiple connections in EDC

HOW TO: Generate missing link report in EDC

In this video, you will see how to add synonyms to your search. You will also learn how to import synonym data into the catalog and search for an asset using a synonym with the help of a demo.

Additional Resource:

HOW TO: Create synonyms for EIC assets

Go through the following articles to learn about Lineage in EDC:

Custom Lineage Options

How to get Detailed Lineage in EDC for PowerCenter mappings

HOW TO: Use custom lineage resource in Live Data Map

Custom Lineage Resource CSV

Lineage/Impact Summary

Go through the following Knowledge Base articles to learn about Glossary Association in EDC:

Multiple Business term association

Intelligent Business glossary association

What is an Intelligent Business glossary association?

Business Term Association

This session shows how to create an EDC custom attribute that is driven from a category created in Business Glossary.

Watch a Webinar: Meet the Experts – EDC 10.2.2 Release Deep-Dive & Demo - Overview of key features for data discovery, cataloging, and management.

Watch a Video: Enterprise Data Catalog for Cloud Data Integration

Watch a Video: Enterprise Data Catalog - Data Discovery & Search Faceting

Watch a Video: Enterprise Data Catalog - Semantic Search

This webinar will guide you through the key use cases of Enterprise Data Catalog (EDC) for your digital transformation, and also discuss the new capabilities of EDC 10.4.

Summary