Informatica Data Quality

Release Notes (10.5.3)

Read the Informatica® Release Notes to learn about known limitations and fixes associated with version 10.5.3. The Informatica version 10.5.3 release includes multiple bug fixes and third-party library upgrades to improve security. The Release Notes also include information about upgrade paths, EBFs, and limited support, such as …

What's New and Changed (10.5.3)

See Informatica® What's New and Changed to learn about new functionality and changes for current and recent product releases. You can also read the important notices for information related to support changes, new products, and release tasks that you might need to perform after you upgrade from a previous version. What's New …

What's New and Changed (10.5.3.0.3)

Help for Users

Data Quality Performance Tuning Guide

Refer to the Informatica® Data Quality Performance Tuning Guide to learn how to configure your data quality transformations to optimize run-time performance and to learn about the memory requirements that apply to Informatica reference data.

Developer Tool Guide

Use the Informatica® Developer Tool Guide to learn about the user interface in the Developer tool. Learn how to connect to a Model repository, create connections and data objects, and deploy applications.

Developer Workflow Guide

Use the Informatica® Developer Workflow Guide to learn how to create, run, and administer workflows. Understand workflow concepts so you can run mappings and other tasks in a single operation. Learn how to recover a workflow if it is interrupted or if an error occurs.

Help for Administrators

Administrator Guide

Use the Informatica® Administrator Guide to learn how to log into the Administrator tool and understand the user interface. Read on how to configure, manage, and monitor the Informatica domain. Learn about domain architecture and its components, including nodes, services, high availability, connections, and monitoring.

Application Service Guide

Use the Informatica Application Service Guide to understand the application services in the Informatica domain, and learn how to manage each service. You can also learn about application service management concepts and tasks including configuration, processing behavior, architecture, and performance tuning.

Security Guide

Use the Informatica Security Guide to learn how to enable security in an Informatica domain. Understand how to configure and manage various authentication protocols, including Lightweight Directory Access Protocol, Kerberos, and Security Assertion Markup Language. Learn how to manage users and groups, and how to use permissions, …

Reference Material

Command Reference

Refer to the Informatica® Command Reference for information about the command line programs and utilities, such as infacmd, infasetup, pmcmd, pmpasswd, and pmrep to manage the Informatica domain, application services, and objects. Learn command descriptions, options, and arguments. You can perform much of the command line …

Installation and Upgrade

Installation for PowerCenter and Data Quality

Follow the instructions in Installation for PowerCenter and Data Quality to install Informatica services and the PowerCenter and Informatica Data Quality products. You can install Informatica services and clients on one or more machines. The guide includes pre- and post-requisite tasks and steps to install the Informatica services and …

Upgrading from Version 10.2 (10.5.3)

Follow the instructions in this upgrade guide to upgrade the product. Review the upgrade guide to upgrade the services and clients for the Informatica domain. Verify the database requirements and set up the databases for the domain. You can verify the distributions for the supported products in the native and non-native environments. …

Upgrading from Version 10.4.0 and Later (10.5.3)

Additional Guides

API Guide

Use the Informatica® Business Glossary API Guide to write client applications that developers need to access a business glossary. It contains information you need to include the business glossary in your client application. This guide assumes you have a working knowledge of application programming interfaces. Informatica recommends …

Business Glossary Getting Started Guide

Use the Informatica® Business Glossary Getting Started Guide to create and view Business Glossary content. It provides a tutorial to help first-time users learn how to use Informatica Business Glossary. Informatica recommends that you use Axon Data Governance instead of Business Glossary for enhanced functionality.

Business Glossary Guide

Use the Informatica® Business Glossary Guide to read and manage a business glossary. It contains information you need to look up content, create, and manage business glossaries and to relate information between glossary content. The Business Glossary Guide assumes you have a working knowledge of the data for your …

Desktop Guide

Use the Informatica® Business Glossary Desktop Guide to look up business terms in a business glossary using the Business Glossary Desktop. The guide includes information about configuring server settings, preferences, and keyboard shortcuts. Informatica recommends that you use Axon Data Governance instead of Business Glossary …

Installation and Configuration Guide

Use the Informatica® Business Glossary Desktop Installation and Configuration Guide to install the Business Glossary Desktop. Informatica recommends that you use Axon Data Governance instead of Business Glossary for enhanced functionality.

Additional Content

Common Content for Data Integration 10.5.3

Access Flat Files

In Informatica Developer, you can create a flat file physical data object when you want to use a flat file as a source, lookup, or target. In this demo, we import a flat file to create a flat file data object, configure the data object, preview the data object, run a profile on the data object, and then add the data object as a source in a mapping.

Check If Workflow Tasks Ran Successfully

In Informatica Developer, you can use conditional sequence flows to check if previous workflow tasks ran successfully.

Integration between Business Glossary and Metadata Manager

Learn how to load a glossary as a Business Glossary resource in Metadata Manager, import published business terms and categories, and link related catalog objects, which show up as related assets in the Analyst tool.

Business Glossary Documentation Quick Reference

This article lists the Business Glossary user guides and how-to articles available for data stewards, administrators, and Glossary consumers.

Configure

Bulk Edit Published or Rejected Business Terms

This article lists the Business Glossary user guides and how-to articles available for data stewards, administrators, and Glossary consumers.

Calling a Web Service from a Web Service Consumer Transformation in Informatica Developer

In Informatica Developer, you can create a Web Service Consumer transformation that calls a web service from an Informatica Data Services mapping or an Informatica Data Quality mapping. This article describes the steps to create a Web Service Consumer transformation, configure the SOAP messages in the transformation, and connect the …

Configure an ODBC Connection to SAP HANA

You can connect to an SAP HANA database by using ODBC. This article explains how to configure an OBDC connection for SAP HANA in PowerCenter, the Administrator tool, the Developer tool, and the Analyst tool.

Configuring Auto Curation Parameters to Infer Foreign Keys in Informatica Developer

When you run an enterprise discovery profile in Informatica Developer, you can discover column profile statistics, data domains, primary keys, and foreign keys in a large number of data sources. A large number of keys and relationships might be inferred. You can approve, reject, or reset the inferred data domains, primary keys, or …

Connecting to Oracle Database Cloud Service from Informatica Developer or PowerCenter

You can configure an Oracle connection to connect to Oracle Database Cloud Service from Informatica® Developer or PowerCenter®. This article describes how to configure connectivity to Oracle Database Cloud Service.

Connect to Oracle Using Oracle Connection Manager from Informatica Developer

You can use Oracle Connection Manager to connect to an Oracle database from Informatica® Developer. This article discusses the tasks that you must perform to configure connectivity to Oracle using Oracle Connection Manager from Informatica Developer.

Creating a Column Profile on a Logical Data Object in Informatica Developer

To identify data quality issues in multiple data sources, you can create an enterprise discovery profile, or you can create a column profile on a logical data object. This article describes how to create and run a column profile on the logical data object in Informatica Developer to identify data quality issues, such as null values, inferred …

Creating a Parameter File for Informatica Developer

A parameter file is an .xml file that lists user-defined parameters and their assigned values. Parameter files provide the flexibility to change parameter values each time that you run a mapping or a workflow. Generate a parameter file based on a mapping or workflow using the Developer tool or the command line. Edit the contents of the file …

Creating a REST Web Service in the Informatica Developer Tool

You can create an Informatica REST web service that returns data to a web service client in JSON or XML format. The article explains how to define a REST web service in the Developer tool. The REST web service runs a mapping that returns hierarchical data in JSON format to a web service client browser.

Creating Column Profiles on Avro and Parquet Data Sources in Informatica Developer

You can discover data on Hadoop by creating and running profiles on the data in Informatica Developer. Running a profile on any data source in the enterprise gives you a good understanding of the strengths and weaknesses of its data and metadata. A profile determines the characteristics of columns in a data source, such as value …

Creating Column Profiles on LDAP Data Objects

You can use Informatica Developer to read data from Lightweight Directory Access Protocol (LDAP) directory servers. You can create column profiles on the LDAP data sources and view the profile results to find the content, quality, and structure of the data sources. This article is written for database administrators and developers and …

Creating Filters for Profiles and Scorecards Using Informatica Analyst

You can add, edit, or delete filters in a profile. A filter determines the rows that the profile reads at run time. The profile does not process rows that do not meet the filter criteria. When you create a filter for a profile or scorecard, the profile or scorecard runs on the filtered data. This article describes how to create filters for a …

Creating Glossary Content Using Microsoft Excel

You can use Microsoft Excel to create glossary content for business glossaries. The Microsoft Excel file that contains the business glossary data must be in a format that the Analyst tool can import. This article describes how to generate a .xlsx file, edit the file in Microsoft Excel, and import the file to the Analyst tool.

Detecting Outliers in Column Profile Results in Informatica Analyst

When you analyze data in data sources, you might come across data that do not fall within an expected range of values or patterns, such as employee names that do not fall within an expected set of patterns or a Social Security Number that appears multiple times in an Employee database. To identify these anomalies, you can create a column …

Developing a Dynamic Mapping to Manage Metadata Changes in Relational Sources

In the Developer tool, you can develop a dynamic mapping that handles metadata changes in relational sources at run time. This article describes the steps to create a dynamic mapping for relational tables that can have metadata changes and to run the mapping with metadata changes. This article assumes that you are familiar with mapping and …

Developing a Dynamic Mapping to Run Against Different Sources and Targets

In the Developer tool, you can develop a dynamic mapping that reuses the same mapping logic for different sources and targets. This article describes the steps to create a dynamic mapping with a mapping logic that you can run against different sources and write to different targets. This article assumes that you are familiar with mappings …

Migrating Objects from a Model Repository to a PowerCenter Repository

Informatica supports the migration of mappings, mapplets, and logical data object models created in Informatica Developer to PowerCenter. This article explains how you can migrate objects from a Model repository to a PowerCenter repository. The article also outlines guidelines and restrictions to consider, and notes changes to objects that …

Purging Profile and Scorecard Results from the Profiling Warehouse

When you run a profile or scorecard, the profile and scorecard results are saved in the profiling warehouse. You can delete these results from the profiling warehouse. This article discusses how to purge the profile results and scorecard results from the profiling warehouse.

Reading NVARCHAR and NCHAR Data from SAP Tables with a JDBC Connection in Informatica Developer

You can run a mapping that reads NVARCHAR and NCHAR data from SAP tables with a JDBC connection. Before you can run the mapping, you must configure properties for the Data Integration Service that runs the mapping in Informatica Administrator and configure properties for Informatica Developer (the Developer tool) in the developerCore.ini …

Reading Profiles in Third-Party Applications

Informatica provides database views that you can use to open profile results in third-party reporting tools. This article describes how to configure the database views for the profile statistics you want to read.

Replicating a Glossary in a Domain

This article describes how a Glossary administrator or data steward can replicate a glossary in an Informatica domain.

Running a Column Profile on JSON and XML Data Sources

When you run a profile on JSON and XML data sources, Informatica Developer treats the files as flat files. This article describes how you can create column profiles on flat file data sources that are in JSON or XML format, and view the profile results for data analysis and development.

Running a Profile on Wide Tables

You might need to perform discovery tasks on a relational data source with wide tables or flat files with a huge number of columns. To optimize the profile run on wide tables, you can configure some of the Data Integration Service parameters specific to Profiling Service Module. You can run a column profile on the relational source. Column …

Using the Blaze Engine to Run Profiles and Scorecards

Informatica Blaze engine is an Informatica proprietary engine for distributed processing on Hadoop. You can run profiles and scorecards on the Blaze engine. This article discusses how you can use the Blaze engine to run profiles and scorecards in Informatica Developer and Informatica Analyst.

Using the Random Sampling Option in Profiles

You can choose to run a profile on all the rows in a data object, first N number of rows, or a random sample of data in the data object. This article discusses the random sampling options in profiling and how to use the options based on your requirement.

Using the SQL Transformation in an Informatica Developer Mapping

You can run SQL queries against a relational database midstream in a mapping. This article describes how to configure an SQL transformation in a logical data object mapping in the Developer tool.

Using Workflow Parameters and Variables to Write to a Dynamic Target File

You can use parameters and variables in a workflow designed in the Developer tool to make the workflow more flexible. This article describes how to use workflow parameters and variables to dynamically determine the name of the target file at run time.

Monitor

Viewing Scorecard Lineage

View a scorecard lineage diagram for a scorecard metric or metric group in Informatica Analyst. Use scorecard lineage to analyze the root cause of unacceptable score variance for a metric or metric group and understand the data flow. To view the scorecard lineage diagram, export scorecards to an XML file from Informatica Developer. Use …

Troubleshoot

Business Glossary Best Practices

This article provides best practices for migrating, configuring, and using Business Glossary.

Clean up the Data Profile Warehouse

When you run a profile or scorecard, the profile and scorecard results are saved in the profile warehouse. You can delete the profile and scorecard results from the Model Repository. The deleted results remain in the profile warehouse and appear in the trend charts. This article discusses how to clean up the orphan profiles and …

Optimize and Tune

Optimizing the Data Integration Service to Process Concurrent Web Services

The Data Integration Service runs concurrent web service requests according to the properties that you configure on the Data Integration Service and the application properties that you configure for each web service object. When you optimize the properties that affect web service concurrency, you can improve performance.

Relational Pushdown Optimization Best Practices for Developer Tool Mappings

To improve Developer tool mapping performance, use best practices when you configure mappings and apply relational pushdown optimization. Relational pushdown optimization causes the Data Integration Service to push transformation logic to a database. Pushdown optimization improves mapping performance as the source database can process …

Using the Data Quality Accelerator for Crisis Response

The Data Quality Accelerator for Crisis Response is a set of preconfigured rules that accelerate your implementation of a data quality process in healthcare and crisis management scenarios. Import the rules into your Informatica environment to analyze, validate, and improve the accuracy of your data, enabling more reliable decision making …

Administration

Informatica Architecture: Nodes and Domains

The Informatica domain consists of one or more servers, one or more installations of the Informatica software, and at least one relational database. This article is a discussion of how nodes work with the database, communications between nodes, what happens when a node dies, and basic troubleshooting on your domain.

Joining Model Repository and Profiling Warehouse Database Views

Regulatory reporting might require you to consolidate information available in multiple Model repository views and profiling warehouse views. You can join the views based on your requirements using key columns of the views. You can run a join query on the views to retrieve the required information from the Model and profiling warehouse repositories.

Migrating Mappings and Mapplets from a PowerCenter Repository to a Model Repository

Informatica supports the migration of mappings and mapplets created with the PowerCenter Client to a Model repository. This article explains how you can import objects from a PowerCenter repository into a Model repository. The article also outlines guidelines and restrictions to consider, and notes changes to objects that might occur during migration.

Profiling and Discovery Sizing Guidelines

The system resource guidelines for profiling and discovery include resource recommendations for the Profiling Service Module, the Data Integration Service, profiling warehouse, and hardware settings for different profile types. This article describes the system resource and performance tuning guidelines for profiling and discovery.

Using Groups and Roles to Manage Informatica Access Control

When you use groups and roles to organize Informatica access control, you simplify user management and create a more secure environment. This article describes how to identify groups and roles and examines the benefits of using groups and roles.

Using Synchronization in Profiling

You can synchronize the changes in the external data source to the data object in the Model Repository after you create and run a profile on the data object. You can also synchronize the curated results of an enterprise discovery profile after you migrate the profile from version 9.5 to a later release. This article discusses the …

Security

Configuring HTTPS for the Administrator Tool Using a Certificate Signed by a Certificate Authority

To use the SSL protocol for a secure connection to the Administrator tool, create a keystore file and configure an HTTPS port for each gateway node in the domain. The keystore file can include a self-signed certificate or a certificate signed by a certificate authority. This article describes how to create and use a certificate signed by a …

Configuring Kerberos Authentication in an Informatica Domain

Kerberos is a network authentication protocol that provides strong authentication between users and services in a network. This article explains how you can configure clients and services within an Informatica domain to use Kerberos authentication.

How to Create Keystore and Truststore Files for Secure Communication in the Informatica Domain

When you enable secure communication for the Informatica domain, you secure the connection between services and between the services and the service managers. For better security, you can provide a custom SSL key and certificate. This article describes how to create keystore and truststore files in PEM and JKS formats with a custom SSL …

Using LDAP Authentication in an Informatica Domain

Lightweight Directory Access Protocol (LDAP) is a software protocol for accessing users and resources on a network. You can configure an Informatica domain to use LDAP to authenticate Informatica application client users.

Using Two-Factor Authentication to Connect to a Kerberos-enabled Informatica Domain

Two-factor authentication (2FA), utilizing smart cards or USB tokens, is a popular network security mechanism. This article explains how two-factor authentication works in an Informatica domain configured to use Kerberos authentication. The information in the article might also be useful when troubleshooting authentication issues.

Install and Upgrade

10.5.1 Upgrade Paths

When you upgrade from a previous version, follow the supported upgrade paths to ensure a smooth and successful upgrade. This article includes upgrade paths for all products supported in the 10.5.1 Informatica installer.

10.5 Upgrade Paths

Deploy Data Quality on the AWS Cloud Marketplace (10.5.1.1)

You can deploy Data Quality on the Amazon Web Services (AWS) Marketplace. This deployment reference includes step-by-step instructions for deploying Data Quality on the Amazon Web Services (AWS) Marketplace. It also includes information on prerequisites and how to troubleshoot common issues.

Deploy Data Quality on the AWS Cloud Marketplace (10.5.1)

Deploy Data Quality on the AWS Cloud Marketplace (10.5)

Deploy Data Quality on the AWS U.S. Intelligence Community Marketplace (10.5.1.1)

You can deploy Data Quality on the Amazon Web Services (AWS) U.S. Intelligence Community Marketplace. This deployment reference includes step-by-step instructions for deploying Data Quality on the AWS U.S. Intelligence Community Marketplace. It also includes information on prerequisites and troubleshooting.

Deploying the Informatica® Data Quality 10.4.0 AWS Marketplace Solution

This deployment reference provides step-by-step instructions for deploying Informatica Data Quality on Amazon Web Services (AWS) from the AWS Marketplace. Automated reference deployments use AWS CloudFormation templates to launch, configure, and run the AWS compute, network, storage, and other services required to deploy a specific workload on AWS.

Deploying the Informatica® Data Quality 10.4.0 Microsoft Azure Marketplace Solution

The automated marketplace solution uses Azure Resource Manager to launch, configure, and run the Azure virtual machine, virtual network, and other services required to deploy a specific workload on Azure. This deployment reference provides step-by-step instructions for deploying Informatica Data Quality on the Microsoft Azure Marketplace.

Deploy the Informatica® 10.5.3 Data Quality Solution on the Microsoft Azure Marketplace

Deploy the Informatica® Data Quality 10.5.1.1 Solution on the Google Cloud Marketplace

The automated marketplace solution uses Google Cloud Platform templates to launch, configure, and run the Google Cloud compute, network, storage, and other services required to deploy a specific workload on Google Cloud. This deployment reference provides step-by-step instructions for deploying Informatica Data Quality on Google Cloud …

Deploy the Informatica® Data Quality Solution on the AWS Cloud Marketplace (10.4.1)

Deploy the Informatica® Data Quality solution on the AWS Cloud Marketplace (10.5.2)

Deploy the Informatica® Data Quality solution on the AWS Cloud Marketplace (10.5.3)

Deploy the Informatica® Data Quality Solution on the Microsoft Azure Marketplace (10.4.1)

Deploy the Informatica® Data Quality Solution on the Microsoft Azure Marketplace (10.5.1)

Deploy the Informatica® Data Quality Solution on the Microsoft Azure Marketplace (10.5)

Informatica Port Administration

Domain and application services ports can either be static ports or dynamic ports. The Informatica domain and domain components are assigned to static ports. Certain application services are also assigned to static ports while others run on dynamic ports.

Install Data Quality on Docker with Informatica Deployment Manager

Informatica Deployment Manager provides a quick and easy way to install the Informatica domain. This article describes how to install Data Quality on Docker from the Docker image using Informatica Deployment Manager.

Install Data Quality on Docker with Informatica Deployment Manager 10.5.2

Install Data Quality on Docker with Informatica Deployment Manager 10.5.3

Install Data Quality on Kubernetes with Informatica Deployment Manager

Informatica Deployment Manager provides a quick and easy way to install and manage the Informatica domain. This article describes how to install Data Quality on Kubernetes from the Docker image using Informatica Deployment Manager. This article also describes how you can use Informatica Deployment Manager to manage an existing Data Quality …

Install Data Quality on Kubernetes with Informatica Deployment Manager 10.5.3

Supported Upgrade Paths to Informatica 10.2

Informatica 10.2 HotFix 2 contains various improvements and enhancements to the Informatica domain. Informatica provides a list of supported upgrade paths for users who want to upgrade their product. This article describes the supported upgrade paths to upgrade to Informatica 10.2 HotFix 2.

Additional Articles

Enabling SAML Authentication in an Informatica 10.2.x Domain

You can enable users to log into Informatica web applications using single sign-on. This article explains how to configure single sign-on in an Informatica 10.2.x domain using Security Assertion Markup Language (SAML) and Microsoft Active Directory Federation Services (AD FS).