English
PowerCenter All Products

Administrator Guide

The Informatica Administrator Guide is written for Informatica domain administrators and operators. It contains information that you need to configure, manage and monitor the domain. The Administrator Guide assumes that you have basic working knowledge of the Informatica domain and services.

Advanced Workflow Guide

The PowerCenter® Advanced Workflow Guide is written for developers and administrators who are responsible for creating workflows and sessions, and running workflows. This guide assumes you have knowledge of your operating systems, relational database concepts, and the database engines, flat files or mainframe system in your …

Analyst Tool Guide

The Informatica Analyst Tool Guide describes how to use Informatica Analyst (the Analyst tool) to discover and define business logic and collaborate on business projects in an enterprise. It is written for business users such as analysts and data stewards who collaborate on projects within an organization. This guide assumes that you have …

Application Service Guide

The Informatica Application Service Guide is written for Informatica users who need to configure application services. The Informatica Application Service Guide assumes you have basic working knowledge of Informatica and details of the environment in which the application services run.

Command Reference

The Informatica Command Reference is written for Informatica administrators and developers who manage the repositories and administer the domain and services. This guide assumes you have knowledge of the operating systems in your environment. This guide also assumes you are familiar with the interface requirements for the supporting applications.

Designer Guide

The PowerCenter® Designer Guide is written for developers and software engineers responsible for implementing a data warehouse. The PowerCenter Designer Guide assumes that you have a solid understanding of your operating systems, relational database concepts, and database engines, flat files, or mainframe system in your environment. …

Developer Tool Guide

The Informatica Developer Tool Guide is written for big data, data services, and data quality developers. This guide describes common functionality in the Developer tool. This guide assumes that you have an understanding of flat file and relational database concepts, and the database engines in your environment.

Getting Started

PowerCenter® Getting Started is written for the developers and software engineers who are responsible for implementing a data warehouse. It provides a tutorial to help first-time users learn how to use PowerCenter. PowerCenter Getting Started assumes you have knowledge of your operating systems, relational database concepts, and the …

Glossary

The Informatica Glossary is written for Informatica users. It contains terminology for Informatica products that you can use with Informatica Administrator, Informatica Analyst, and Informatica Developer.

Informatica New Features Guide

The Informatica New Features and Enhancements Guide is written for all Informatica software users. This guide lists the new features and enhancements in Informatica products.

Installation and Configuration Guide

The Informatica Installation and Configuration Guide is written for the system administrator who is responsible for installing the Informatica product. This guide assumes you have knowledge of operating systems, relational database concepts, and the database engines, flat files, or mainframe systems in your environment. This guide also …

Mapping Analyst for Excel Guide

The PowerCenter® Mapping Analyst for Excel Guide is written for business analysts who want to use Microsoft Excel to develop PowerCenter mappings. It is also written for PowerCenter developers who want to use the Microsoft Excel files to begin developing PowerCenter mappings. This book assumes you have a working knowledge of Microsoft Excel.

Mapping Architect for Visio Guide

The PowerCenter® Mapping Architect for Visio Guide is written for developers and architects responsible for designing PowerCenter mappings. The PowerCenter Mapping Architect for Visio Guide assumes that you have a solid understanding of PowerCenter and data integration concepts. This guide also assumes that you are familiar with Microsoft Office Visio.

Message Reference

The Informatica Message Reference is written for all Informatica users. This guide contains troubleshooting information for all aspects of data warehouse development, including source analysis, transformation development, mapping development, and running sessions. This guide assumes you have knowledge about your operating systems, …

New Features Guide

The Informatica New Features and Enhancements Guide is written for all Informatica software users. This guide lists the new features and enhancements in Informatica products.

New Features Guide

The Informatica New Features and Enhancements Guide is written for all Informatica software users. This guide lists the new features and enhancements in Informatica products.

Performance Tuning Guide

The PowerCenter® Performance Tuning Guide is written for PowerCenter administrators and developers, network administrators, and database administrators who are interested in improving PowerCenter performance. This guide assumes you have knowledge of your operating systems, networks, PowerCenter, relational database concepts, and flat …

PowerCenter Repository Reports

PowerCenter Repository Reports

PowerExchange Interfaces for PowerCenter

The PowerExchange Interfaces for PowerCenter publication describes the Informatica® PowerExchange® Client for PowerCenter (PWXPC) and ODBC interfaces between PowerExchange and PowerCenter®. This publication is intended for developers and administrators who are responsible for creating, running, and administering workflows and sessions …

Profile Guide

The Informatica Profile Guide is written for Informatica Analyst and Informatica Developer users. It contains information about how you can use profiles to analyze the content and structure of data. Use column profiles to determine the characteristics of columns, such as value frequency, percentages, and patterns, in a data source.

Release Guide

The Informatica Release Guide lists new features and enhancements, behavior changes between versions, and tasks you might need to perform after you upgrade from a previous version. The Informatica Release Guide is written for all types of users who are interested in the new features and changed behavior. This guide assumes that you …

Release Guide

The Informatica Release Guide lists new features and enhancements, behavior changes between versions, and tasks you might need to perform after you upgrade from a previous version. The Informatica Release Guide is written for all types of users who are interested in the new features and changed behavior. This guide assumes that you …

Release Notes

This document contains important information about restricted functionality, known limitations, and bug fixes for Informatica 10.1.1.

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 …

Security Guide

The Informatica Security Guide contains information about security in the Informatica domain. It contains information that you need to manage security for the Informatica domain and the Informatica clients that connect to the domain. This book assumes that you have knowledge of the Informatica domain and the Informatica Administrator. It also …

Transformation Guide

The PowerCenter® Transformation Guide is written for the developers and software engineers responsible for implementing your data warehouse. The PowerCenter Transformation Guide assumes that you have a solid understanding of your operating systems, relational database concepts, and the database engines, flat files, or mainframe system …

Transformation Language Reference

The PowerCenter Transformation Language Reference is written for the developers who are responsible for building mappings. The PowerCenter Transformation Language Reference assumes you have knowledge of SQL, relational database concepts, and the interface requirements for your supporting applications.

Upgrading from Version 10.0

Upgrading from Version 10.0 is written for the system administrator who is responsible for upgrading the Informatica product. This guide assumes that you have knowledge of operating systems, relational database concepts, and the database engines, flat files, or mainframe systems in your environment. This guide also assumes that you are …

Upgrading from Version 10.1

Upgrading from Version 10.1 is written for the system administrator who is responsible for upgrading the Informatica product. This guide assumes that you have knowledge of operating systems, relational database concepts, and the database engines, flat files, or mainframe systems in your environment. This guide also assumes that you are …

Upgrading from Version 9.5.1

Upgrading from Version 9.5.1 is written for the system administrator who is responsible for upgrading the Informatica product. This guide assumes that you have knowledge of operating systems, relational database concepts, and the database engines, flat files, or mainframe systems in your environment. This guide also assumes that you are …

Upgrading from Version 9.6.1

Upgrading from Version 9.6.1 is written for the system administrator who is responsible for upgrading the Informatica product. This guide assumes that you have knowledge of operating systems, relational database concepts, and the database engines, flat files, or mainframe systems in your environment. This guide also assumes that you are …

Web Services Provider Guide

The PowerCenter® Web Services Provider Guide provides information about the Web Services Provider and the PowerCenter web services hosted by the Web Services Hub. This guide also provides information about how to turn PowerCenter workflows into web services and examples for how to create client applications that use the web services …

Workflow Basics Guide

The PowerCenter® Workflow Basics Guide is written for developers and administrators who are responsible for creating workflows and sessions, and running workflows. This guide assumes you have knowledge of your operating systems, relational database concepts, and the database engines, flat files or mainframe system in your environment. …

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 …

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

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.

Connecting to Oracle Autonomous Data Warehouse Cloud from Informatica Developer or PowerCenter

You can configure an Oracle connection to connect to Oracle Autonomous Data Warehouse Cloud (Oracle ADWC) from Informatica® Developer or PowerCenter®. This article describes how to configure connectivity to Oracle ADWC.

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.

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.

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

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

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 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 Configure PowerCenter 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 on Kubernetes.

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.

How to Implement PowerCenter on the Microsoft Azure Cloud Service

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

How to Install Informatica 10.2 HotFix 2 Using a Docker Utility

Informatica provides the Docker utility to install the Infomatica domain quickly. This article describes how to install Informatica using Docker image.

How to Install Informatica Using a Docker Utility

Informatica provides the Docker utility to install the Infomatica domain quickly. This article describes how to install Informatica using Docker image.

How to Install PowerCenter on the Google Cloud Platform

You can use all the features of PowerCenter® on a Google Compute Engine virtual machine instance. This article describes how to install PowerCenter on a Google Compute Engine virtual machine instance. This article assumes that you have basic working knowledge of the Informatica Services, Google Cloud Platform, and Google Compute Engine.

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.

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

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.

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 …

Reporting Options for Data Validation Option in PowerCenter 10.1

You can generate reports with Data Validation Option. This article describes the different reporting options for Data Validation Option. This article also describes how to install and configure a standalone JasperReports Server for the Data Validation client to generate reports.

Supported Upgrade Paths to Informatica 10.1.1

Informatica provides a list of supported upgrade paths for users who want to upgrade their Informatica product. This article describes the supported upgrade paths to upgrade to Informatica 10.1.1 and 10.1.1 hotfix releases.

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.

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.

Updated June 2018

Download Documentation Set
Explore Informatica Network
Communities
Knowledge Base