PowerCenter | 10.4.0

Release Information

Data Validation Option Release Notes

Read the PowerCenter Data Validation Option Release Notes 10.4.0 to learn about Data Validation Option 10.4.0 compatibility with PowerCenter.

New Features Guide

Read the Informatica® New Features and Enhancements Guide to learn about the new features and enhancements in Informatica products for this release.

Release Guide

See the Informatica® Release Guide to learn about new features and enhancements for current and recent product releases. Learn about behavior changes between versions and tasks you might need to perform after you upgrade from a previous version. The Release Guide includes content for Data Engineering products and …

Release Notes

Read the Informatica® Release Notes to learn about known limitations and fixes associated with version 10.4.0. The Release Notes also include information about upgrade paths, EBFs, and limited support, such as technical preview or deferments.

Getting Started

Complete the lessons in PowerCenter® Getting Started Guide to learn how to create user and groups, and creating a folders to store tutorial objects. You can learn how to create source tables and definitions, target tables and definitions, mappings, sessions, and workflows.

Glossary

Refer to the Informatica® Glossary to learn about the terminology for Informatica products that you can use with Informatica Administrator, Informatica Analyst, and Informatica Developer.

Help for Users

Advanced Workflow Guide

Use PowerCenter® Advanced Workflow Guide to learn advanced workflow concepts such as pushdown optimization, pipeline partitioning, and grid processing. You can also create sessions and see information in the session log. You can add transformation logic and partition the pipeline to optimize the performance.

Analyst Tool Guide

Use the Informatica® Analyst Tool Guide to learn how to discover, define, and review the business logic within Informatica Analyst (the Analyst tool). Learn about the different workspaces where you can manage assets or use assets to support business operations.

Data Validation Option User Guide

Read the PowerCenter Data Validation User Guide to learn how you can test and validate data across multiple sources. Read about the Data Validation Option architecture, components, and the validation process. Learn how to configure and run validation tests.

Designer Guide

Use PowerCenter® Designer Guide to learn how to use PowerCenter Designer and create mappings. You can define sources, targets, and transformations to build the mappings and mapplets. You can use windows to view folders, repository objects, and tasks.

Mapping Analyst for Excel Guide

Use PowerCenter® Mapping Analyst for Excel Guide to understand how to configure and define PowerCenter mappings to include sources, targets, and transformations in Microsoft Office Excel.

Mapping Architect for Visio Guide

Use PowerCenter® Mapping Architect for Visio Guide to learn how to create mapping template that represents PowerCenter mapping. You can specify the extraction logic by configuring rules and parameters in a mapping template. You can define and maintain consistent methodology for your data integration projects. You can also create multiple …

Performance Tuning Guide

Refer to the PowerCenter® Performance Tuning Guide to learn about run-time bottlenecks and how to tune for optimal performance.

PowerExchange Interfaces for PowerCenter

Use the Informatica® PowerExchange® Interfaces for PowerCenter® publication to learn how to use the PowerExchange Client for PowerCenter (PWXPC) and ODBC interfaces to configure and run bulk data movement and CDC jobs in PowerCenter. This publication is intended for developers and administrators who are responsible for creating, …

Profile Guide

Use the Informatica Profile Guide to learn how you can use profile to analyze the content and structure of data sources. You can determine the characteristics of source data in columns, such as value frequency, percentages, and patterns. The guide is written for data analysts and developers.

Repository Guide

The PowerCenter® Repository Guide is written for database administrators and developers who manage repositories. This guide assumes you have knowledge of relational database concepts, and the database engines, flat files, or mainframe systems in your environment. You should also be familiar with the interface requirements of your …

Repository Reports

The PowerCenter® Repository Reports is written for PowerCenter administrators who want to run reports on the PowerCenter repository. This guide assumes that you have knowledge of the PowerCenter repository, repository metadata, and repository connectivity.

Transformation Guide

See the PowerCenter® Transformation Guide to learn about the configuration, guidelines, usage, and run-time behavior of Informatica transformations. Transformations are repository objects that represent the operations that the Integration Service performs on a data. Refer the guide to perform data operations to generate, change, or …

Transformation Language Reference

Refer to the PowerCenter® Transformation Language Reference to understand transformation language in PowerCenter. Learn how you can use constants, operators, variables, dates, and functions to transform source data.

Web Services Provider Guide

See the PowerCenter® Web Services Provider Guide for information about the Web Services Provider and the PowerCenter web services hosted by the Web Services Hub. Use the guide to learn how to turn PowerCenter workflows into web services and to see examples that create client applications that use the web services available on the …

Workflow Basics Guide

Use the PowerCenter® Workflow Basics Guide to learn how to create, run, schedule, and to monitor workflows and sessions. You can create and configure a workflow in the Workflow Manager. Workflows are a set of instructions to run the mappings build in Designer. Workflows can contain a session and other tasks, such as an email …

XML Guide

The XML Guide is written for developers and software engineers responsible for working with XML in a data warehouse environment. Before you use the XML Guide, ensure that you have a solid understanding of XML concepts, your operating systems, flat files, or mainframe system in your environment. Also, ensure that you are familiar with the …

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 …

Message Reference

Refer to the Informatica® Message Reference to understand run-time errors that you see in logs and learn what actions you can take based on the error. Error messages in this reference are grouped by message code.

Installation and Upgrade

Data Validation Option Installation and Configuration Guide

Follow the instructions in the Informatica Data Validation Option Installation and Configuration Guide to install, configure, and upgrade Data Validation Option. It includes the installation information for DVO command line program and the commands in it. It describes how to configure multiple environments and set up standalone JasperReports server.

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.0 (10.4.0)

Follow the instructions in this upgrade guide to upgrade the product. In addition to upgrade steps, the guide also includes pre- and post-requisite tasks. This guide is written for the system administrator who is responsible for upgrading the product. Review the upgrade guide to upgrade the services and clients for the Informatica domain. …

Upgrading from Version 10.1 (10.4.0)

Upgrading from Version 10.1.1 (10.4.0)

Converting Workflow Parameter Files to Taskflow Parameter Sets

Learn how to convert parameter files from PowerCenter workflows to parameter sets in Cloud Data Integration taskflows when you migrate from PowerCenter to Cloud.

Show Less

Debugging: PowerCenter + Cloud Data Integration

Learn the differences between PowerCenter's Debugging tool and Cloud Data Integration's Mapping Data Preview.

Show Less

Recovering PowerCenter Workflows and Cloud Data Integration Taskflows

Learn how to configure recovery for PowerCenter workflows and Cloud Data Integration taskflows.

Show Less

Starting Workflows and Taskflow Jobs with a 3rd-Party Scheduler

Learn how a third-party scheduler can use Informatica’s command line utilities to start a PowerCenter workflow or a Cloud Data Integration taskflow job.

Show Less

Versioning Objects in PowerCenter and Cloud Data Integration

Learn about the differences in object versioning between PowerCenter and Cloud Data Integration.

Show Less

Getting Started

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.

Running a Workflow on a PowerCenter Grid

When an Informatica domain contains multiple nodes, you can configure PowerCenter workflows to run on a grid. When you run a workflow on a grid, the PowerCenter Integration Service runs a service process on each available node of the grid to increase performance and scalability. The service distributes workflow tasks across the nodes …

Team-Based Development in the PowerCenter Repository and the Model Repository

Team-based development is the collaboration of team members on a development project. Both the PowerCenter repository and the Model repository contain team-based development features, such as versioning and the ability to check out and check in objects. The list and method of implementation of team-based development features depends on …

Configure

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 Secure Communication to Microsoft SQL Server in PowerCenter

You can enable secure communication with SSL encryption from PowerCenter to Microsoft SQL Server. When you use an ODBC provider type in the Microsoft SQL Server connection, you must enable DSN to set the SSL encryption. This article describes how you can configure secure communication from PowerCenter to Microsoft SQL Server with a …

Configuring SFTP Connections in PowerCenter®

This article describes how to set up an SFTP workflow connection in PowerCenter and configure the SFTP connection properties to achieve secure transfer of files and protection against attacks such as IP spoofing, IP source routing, and DNS spoofing.

Configuring the Simba ODBC Driver for MongoDB

You can configure an ODBC connection to connect to MongoDB from the Developer Tool or PowerCenter. This article explains how to configure an ODBC connection for MongoDB in the Developer Tool or PowerCenter.

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 PowerCenter

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

Creating a Data Processor Transformation for an XML Source

Use the Data Processor transformation to process an XML source with one format and produce an XML output in another format. The Data Processor transformation uses an XMap to transform an XML hierarchy into a different XML hierarchy. This article describes how to create and configure a Data Processor transformation with an XMap to …

Enable Proxy User Support for Oracle Databases in PowerCenter (10.4.0)

You can temporarily sign in to your network as a different user through user impersonation. This article describes how you can specify an impersonate user and connect to Oracle databases on behalf of that user and perform read or write operations.

Entering an Adabas FDT Password for CAPXRT Database Row Tests or PowerCenter CDC Sessions

This article shows how to enter the Adabas FDT password when you connect to an Adabas source or target during a PowerCenter batch, Change, or Real-time mode session or run a CAPXRT database row test for an Adabas extraction map.

How to Configure Oracle Single Client Access Name (SCAN) in Informatica 10.1.1

Informatica supports connectivity to an Oracle Real Application Cluster (RAC) for the domain, Model Repository Service, and PowerCenter Repository Service. Informatica services can connect to Oracle RAC configured in Connect Time Connection Failover (CTCF) or Fast Connection Failover (FCF) mode. Effective in version 10.1.1, you can use …

How to Migrate Microsoft SQL Server Connections from the OLE DB to the ODBC Provider Type

When you create a Microsoft SQL Server connection, you can use the OLE DB or ODBC provider types. If required, you can migrate the OLE DB provider type to the ODBC provider type. This article explains how to migrate Microsoft SQL Server connections from the OLE DB provider type to the ODBC provider type.

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 …

Reading Data from SAP HANA Modelling Views Using PowerCenter

This article explains how to read data from SAP HANA modelling views using PowerCenter.

Testing XML Data with Informatica Data Validation Option

With Informatica Data Validation Option (DVO), you can reduce the complexity to test XML data and provide flexibility to test the data in both XML and non XML data scenarios. This article describes how you can use DVO to test XML data.

Using Parameters for General Session Properties

You can use the general session parameter, $ParamName, to define a parameter for a general session property. This article describes how to add a general session parameter to a session, create a parameter file to define the value of the parameter, and configure the parameter file name and location.

Using PowerCenter to Process Flat Files in Real Time

You can use PowerCenter to process a large number of flat files daily in real time or near real time. Based on the source data, you can run a session that processes multiple flat files at scheduled intervals. Or, you can run a single real-time session that processes flat files continuously. This article presents multiple real-time or near …

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.

Integrate

Implementing Data Masking and Data Subset with Sequential or VSAM Sources

You can use PowerExchange, PowerCenter, and Persistent Data Masking and Data Subset to perform data masking and data subset with sequential or VSAM sources on z/OS. This article describes the procedures for installing and configuring PowerExchange and performing data masking and data subset with these sources.

Troubleshoot

Business Glossary Best Practices

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

Optimize and Tune

Data Validation Option Best Practices

To maximize the benefits that Data Validation Option offers, you must understand how to best set up Data Validation Option in a customer environment and know the best practices for using Data Validation Option.

How to Use Full Pushdown Optimization in PowerCenter

You can push transformation logic to the database to improve mapping performance. A common use case is full pushdown optimization where the Integration Service attempts to push all transformation logic to the target database. This article describes how to configure full pushdown optimization in PowerCenter.

Increasing Performance for PowerCenter Sessions that Use Partitions

A partition is a pipeline stage that executes in a single reader, transformation, or writer thread. You can configure multiple partitions for a single pipeline stage. This article explains how to increase performance in sessions that use partitions.

PowerCenter Repository Maintenance

The PowerCenter repository grows over time as you run new jobs on the development and production environments. The PowerCenter administrator must perform certain maintenance tasks on the database that hosts the repository to maintain the size of the database for optimal performance. This article provides information for the PowerCenter …

Setting Up Disaster Recovery for PowerCenter

You can implement a disaster recovery plan for PowerCenter deployments to recover from accidental loss of user data, hardware failures, database corruption, and natural disasters. This article presents some recovery strategies and best practices that you can adopt to recover and protect PowerCenter deployments during a disaster.

Sizing Guidelines and Performance Tuning for Metadata Manager 10.0

This article is intended to provide you general reference guidelines to help you tune the performance of Metadata Manager. The results listed in this article are based on observations in an internal Informatica environment using data from real-world scenarios. The performance of Metadata Manager might vary based on individual environments …

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.

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.

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 SequeLink to Access Data

If PowerExchange® does not provide access for your database, you might be able to use the DataDirect SequeLink Client and Server with the SequeLink ODBC drivers to access the data, depending on the database type. With the SequeLink ODBC drivers, you can access data on a Windows machine from a UNIX or Linux machine that runs PowerCenter® services.

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.

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

Data Validation Option Integration with Cloudera

You can use Cloudera Impala to process queries directly on the Apache Hadoop data stored in HDFS or HBase. Data Validation Option contains a graphical user interface to create and run tests on data including Hadoop data. This article describes how you can integrate Data Validation Option with Cloudera Impala.

Data Validation Option Integration with Hortonworks

You can use Hortonworks to process queries directly on the Apache Hadoop data stored in HDFS or HBase. Data Validation Option contains a graphical user interface to create and run tests on data including Hadoop data. This article describes how you can integrate Data Validation Option with Hortonworks.

Deploying PowerCenter on AWS ICMP Infrastructure

You can deploy a PowerCenter® installation on AWS ICMP. This article describes how to verify that the PowerCenter installation is correctly deployed in your AWS ICMP infrastructure.

Deploying the Informatica® PowerCenter 10.4.0 AWS Marketplace Solution

This deployment reference provides step-by-step instructions for deploying Informatica® PowerCenter on the Amazon Web Services Cloud 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® PowerCenter 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 PowerCenter on the Microsoft Azure Marketplace.

Deploying the Informatica® PowerCenter 10.4.0 Microsoft Azure Marketplace Solution

Deploy PowerCenter on the AWS Cloud Marketplace (10.5.1.1)

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

Deploy PowerCenter on the AWS Cloud Marketplace (10.5.1)

Deploy PowerCenter on the AWS Cloud Marketplace (10.5)

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

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

Deploy the Informatica® 10.5.1.1 PowerCenter Solution on the Microsoft Azure Marketplace

Deploy the Informatica® 10.5.3 PowerCenter Solution on the Microsoft Azure Marketplace

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

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

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

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

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

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

How to Configure Hive ODBC Connector for Cloudera Enterprise with PowerCenter on Linux

You can configure Hive ODBC Connector for Cloudera Enterprise with PowerCenter® on Linux. This article describes how to install and configure the connector and also use the connector with the PowerCenter installation deployed in your infrastructure.

How to Configure Hortonworks ODBC Driver for Apache Hive with PowerCenter on Linux

How to Configure MapR Hive ODBC Connector with PowerCenter on Linux

You can configure MapR Hive ODBC Connector with PowerCenter® on Linux. This article describes how to install and configure the connector and also use the connector with the PowerCenter installation deployed in your infrastructure.

How to Configure PowerCenter 10.2 HotFix 2 on Kubernetes

You can configure PowerCenter on Kubernetes to optimize resource management and to enable load balancing for the Informatica domain within the containerized environment. This article is written for the PowerCenter administrator responsible for configuring PowerCenter 10.2 HotFix 2 on Kubernetes.

How to Connect to a Microsoft SQL Server Database that Uses Kerberos Authentication in Informatica 10.x

You can connect to a Microsoft SQL Server database with Kerberos authentication from PowerCenter. This article describes how you can configure a connection to a Microsoft SQL Server database that uses Kerberos authentication in Informatica 10.x.

How to Implement PowerCenter on Microsoft Azure

You can use all the features of PowerCenter® on an Azure machine instance. This article describes how to install PowerCenter 10.2 HotFix 1 or 10.2 HotFix 2 with an Azure machine instance.

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.

Installing and Configuring PowerCenter 10.2 in the AWS Cloud

You can use all the features of an on-premises PowerCenter® installation on an Amazon EC2 instance. This article describes how to install and set up PowerCenter with an Amazon EC2 instance to install Informatica services.

Installing and Configuring PowerCenter in the AWS Cloud

Install PowerCenter (10.4.x - 10.5) 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 PowerCenter on Docker from the Docker image using Informatica Deployment Manager.

Install PowerCenter 10.5 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 PowerCenter 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 PowerCenter …

Install PowerCenter on Docker with Informatica Deployment Manager 10.5.1 and 10.5.2

Install PowerCenter on Docker with Informatica Deployment Manager 10.5.3

Install PowerCenter on Docker with the Container Utility (10.4.0 - 10.4.1)

Informatica provides the Informatica container utility to install the Informatica domain quickly. This article describes how to install PowerCenter from the Docker image through the Informatica container utility on Docker.

Install PowerCenter on Kubernetes with Informatica Deployment Manager 10.5.1 and 10.5.2

Install PowerCenter on Kubernetes with Informatica Deployment Manager 10.5.3

Install PowerCenter on Kubernetes with the Container Utility (10.4.0 - 10.4.1)

Install PowerCenter with the Container Utility on Kubernetes (10.4.0 - 10.4.1)

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

Configuring HTTP Streaming for SAP ABAP Table Reader Mappings in PowerCenter®

When you run ABAP mappings in PowerCenter to read data from SAP tables, you can configure HTTP streaming. HTTP stream mode sessions use background processing. This article describes how to configure HTTP streaming for ABAP table reader mappings in PowerCenter.

Configuring SAML-based Single Sign-on for Informatica 10.1.1 Web Applications

You can enable users to log into the Administrator tool, the Analyst tool and the Monitoring tool using single sign-on. This article explains how to configure single sign-on in an Informatica domain using Security Assertion Markup Language (SAML) and Microsoft Active Directory Federation Services (AD FS).

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).

Implementing Data Masking and Data Subset with IMS Unload File Sources

You can use PowerExchange, PowerCenter, and Test Data Management (TDM) to perform data masking and data subset with IMS unload file sources on z/OS. This article describes the procedures for installing and configuring PowerExchange and performing data masking and data subset with these sources.

Improving the Performance of the PowerCenter Repository

The PowerCenter repository is a relational database instance managed by the PowerCenter Repository Service. The database stores tables that hold metadata about repository objects, such as mappings and transformations. Over time, PowerCenter repository performance can slow for many reasons. This article describes methods to improve …

Actions

Download Documentation Set

Send Feedback

Resources

Communities

Knowledge Base

Success Portal

Rename Saved Search

Release Information

Data Validation Option Release Notes

New Features Guide

Release Guide

Release Notes

Getting Started

Getting Started

Glossary

Help for Users

Advanced Workflow Guide

Analyst Tool Guide

Data Validation Option User Guide

Designer Guide

Mapping Analyst for Excel Guide

Mapping Architect for Visio Guide

Performance Tuning Guide

PowerExchange Interfaces for PowerCenter

Profile Guide

Repository Guide

Repository Reports

Transformation Guide

Transformation Language Reference

Web Services Provider Guide

Workflow Basics Guide

XML Guide

Help for Administrators

Administrator Guide

Application Service Guide

Security Guide

Reference Material

Command Reference

Message Reference

Installation and Upgrade

Data Validation Option Installation and Configuration Guide

Installation for PowerCenter and Data Quality

Upgrading from Version 10.0 (10.4.0)

Upgrading from Version 10.1 (10.4.0)

Upgrading from Version 10.1.1 (10.4.0)

Converting Workflow Parameter Files to Taskflow Parameter Sets

Debugging: PowerCenter + Cloud Data Integration

Recovering PowerCenter Workflows and Cloud Data Integration Taskflows

Starting Workflows and Taskflow Jobs with a 3rd-Party Scheduler

Versioning Objects in PowerCenter and Cloud Data Integration

Getting Started

Business Glossary Documentation Quick Reference

Running a Workflow on a PowerCenter Grid

Team-Based Development in the PowerCenter Repository and the Model Repository

Configure

Configure an ODBC Connection to SAP HANA

Configuring Secure Communication to Microsoft SQL Server in PowerCenter

Configuring SFTP Connections in PowerCenter®

Configuring the Simba ODBC Driver for MongoDB

Connecting to Oracle Database Cloud Service from Informatica Developer or PowerCenter

Connect to Oracle Using Oracle Connection Manager from PowerCenter

Creating a Data Processor Transformation for an XML Source

Enable Proxy User Support for Oracle Databases in PowerCenter (10.4.0)

Entering an Adabas FDT Password for CAPXRT Database Row Tests or PowerCenter CDC Sessions

How to Configure Oracle Single Client Access Name (SCAN) in Informatica 10.1.1

How to Migrate Microsoft SQL Server Connections from the OLE DB to the ODBC Provider Type

Migrating Objects from a Model Repository to a PowerCenter Repository

Reading Data from SAP HANA Modelling Views Using PowerCenter

Testing XML Data with Informatica Data Validation Option

Using Parameters for General Session Properties

Using PowerCenter to Process Flat Files in Real Time

Using the SQL Transformation in an Informatica Developer Mapping

Integrate

Implementing Data Masking and Data Subset with Sequential or VSAM Sources

Troubleshoot

Business Glossary Best Practices

Optimize and Tune

Data Validation Option Best Practices

How to Use Full Pushdown Optimization in PowerCenter

Increasing Performance for PowerCenter Sessions that Use Partitions

PowerCenter Repository Maintenance

Setting Up Disaster Recovery for PowerCenter

Sizing Guidelines and Performance Tuning for Metadata Manager 10.0

Administration

Informatica Architecture: Nodes and Domains

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