English
  • Shared Content for Data Engineering 10.1.1
  • All Products

This content is shared by multiple products within the Data Engineering product family. Visit the product pages to see content that is specific to each product.

Getting Started

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.

Release Information

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.

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 …

Help for Users

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 …

Data Discovery Guide

The Informatica Data Discovery Guide is written for Informatica Analyst and Informatica Developer users. It contains information about how you can use profiles to analyze the content, quality, and structure of data sources and perform data discovery to discover the metadata of source systems that include content and structure. Use profiles …

Developer Mapping Guide

Understand mapping concepts. Learn how to develop, run, and administer mappings. Create flexibility through mapping parameters and dynamic mappings. Optimize mappings through tuning and partitioning.

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.

Developer Transformation Guide

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

Developer Workflow Guide

The Informatica Developer Workflow Guide is written for developers and administrators who are responsible for creating and running workflows. This guide assumes that you have an understanding of flat file and relational database concepts, the database engines in your environment, and data quality concepts. This guide also assumes that you …

Performance Tuning Guide

The Informatica Performance Tuning Guide is written for administrators and developers who are interested in improving performance. This guide assumes you have knowledge of the operating systems, networks, client tools, relational database concepts, and flat files in your environment. For more information about database performance tuning …

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.

Web Services Guide

The Informatica Web Services Guide is written for data quality and data services developers. This guide assumes that you have an understanding of web services concepts.

Help for Administrators

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.

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.

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 …

Reference Material

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.

Database View Reference

The Informatica Database View Reference is written for Informatica Data Quality, Developer, and Business Glossary users.This guide assumes that you have an understanding of flat file and relational database concepts, the database engines in your environment, and data quality concepts.

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

Transformation Language Reference

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

Installation and Upgrade

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

Additional Guides

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 …

Release Notes

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

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 …

Configure

Configuring Git Version Control for Model Repository Service in 10.2 HotFix 1

You can integrate a Model repository with a Perforce, Subversion, or Git version control system. This article discusses how to integrate a Git system with a Model Repository Service in 10.2 HotFix 1.

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.

How to Create Ephemeral Clusters with Data Engineering 10.4.1

You can use a workflow to automate the creation of a cluster on supported cloud platforms. The workflow creates a cluster and runs mappings and other workflow tasks. When you include a Delete Cluster task, so that the cluster terminates when workflow tasks are complete, the cluster is known as an ephemeral cluster.

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.

Using Operating System Profiles in a Hadoop Environment

An operating system profile is a type of security that the Data Integration Service uses to run mappings. You can define an operating system profile as a user to run mappings. Use operating system profiles to increase security and to isolate the run-time environment for users.

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

Install Python for the Python transformation on Hadoop

Follow the steps to install Python on each Data Integration Service machine so that the Spark engine can run the Python transformation. This article uses Python 3.6.5 on Cloudera CDH 6.1, but you can follow similar steps for other Python and Hadoop distributions such as Amazon EMR.

Optimize and Tune

Improving the Performance of the Model Repository

The Model repository is a relational database that contains metadata about connections, applications and workflows, transformations and functions, and other objects. You can perform several tasks to improve the performance of the Model repository and its interactions with other Informatica services, and with databases and external clients.

Informatica Developer Tool Naming Conventions

This article provides standardized naming conventions for repository objects. Naming conventions improve readability for anyone reviewing or carrying out maintenance on repository objects. The application and enforcement of naming standards establishes consistency in the repository and creates a developer-friendly environment. In addition, …

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.

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.

Security

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

Install and Upgrade

10.5 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 Informatica installer.

How to Migrate Mappings from the Hive Engine

Effective in version 10.2.2, Informatica dropped support for the Hive engine. You can run mappings on the Blaze and Spark engines in the Hadoop environment or on the Databricks Spark engine in the Databricks environment. This article tells how to change the validation and run-time environments for mappings, and it describes processing …

Informatica 10.1: Migrating the Domain Configuration Repository While Upgrading

When you upgrade the Informatica domain, you can migrate the domain configuration repository to a different database. You might need to migrate the repository if the database type or version is no longer supported, if your organization requires all departments to use another database type, or if you want to use a secure database. This …

Informatica 10.1 Supported Upgrade Paths

Informatica 10.1 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.1.

Migrating the Domain Configuration Repository While Upgrading to Informatica 10.0

When you upgrade the Informatica domain, you can migrate the domain configuration repository to a different database. You might need to migrate the repository if the database type or version is no longer supported, if your organization requires all departments to use another database type, or if you want to use a secure database. This …

Migrating to a Supported Operating System While Upgrading to Informatica 10.1

When you upgrade an Informatica domain, you can migrate one or more installations to a different machine. You might need to migrate an installation if the operating system on the current machine is no longer supported. This article explains how to migrate an installation to a machine with a supported operating system, and how to upgrade the migrated node.

Additional Articles

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 with NetScaler for Web Applications

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.4.1 domain using Security Assertion Markup Language (SAML) v2.0 and the Citrix NetScaler 13.0 identity provider.

Enabling SAML Authentication with NetScaler for Web Applications in Informatica 10.4.1

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.4.1 domain using Security Assertion Markup Language (SAML) v2.0 and the Citrix NetScaler 13.0 identity provider.

Tuning the Performance of the Monitoring Model Repository

The monitoring Model repository is a relational database instance. The monitoring Model Repository Service monitors the Data Integration Service jobs, and stores the statistics in the monitoring Model repository. This article discusses the methods that you can use to improve monitoring Model repository performance.

Released December 2016

Updated August 2021

Download Documentation Set
Send Feedback
Resources
Communities
Knowledge Base
Success Portal