Informatica 9.6.1 : 2014 : September Skip navigation

Big Data Edition


  • Hadoop Distributions
    • Support for new versions: HW 2.1.x, MapR 3.1, Cloudera 5.1,Pivotal 1.1
    • Performance
    • Performance Enhancement in file parsing.
    • DB2 partitioning performance enhancement.
  • Security
    • Improved Kerberos support for Cloudera & Hortonworks.
  • Enhancement in Data warehousing Use case
    • Binary Datatype support for hadoop push down.
    • Improved Hive partition Support with Truncate partition option.
  • Hadoop Ecosystem update
    • Improvement on Kerberos Support.
    • Support of Namenode & Resource Manager HA
    • Cloudera Manager Integration.
    • Support of Fair & Capacity scheduler
  • Trial Versions
    • Big Data Trial Standbox for Hortonworks 2.1.3.


  • Ability to migrate all privileges, permissions, roles and groups from a native user to an LDAP user. Helps in rapid Kerberos adoption where native users are disabled.


PowerExchange  MF & CDC (PowerExchange Classic) for 9.6.1 HF1


PowerExchange now includes support for the following

  • CICS/TS 5.2
  • Microsoft SQL-Server 2014

Improved or Extended functionality for

  • PowerExchange Listener on UNIX & LINUX
    • Monitoring & Reporting features introduced for PowerExchange Listeners running on z-Series & Windows platforms in V9.6.0 has now been extended to include PowerExchange Listeners running on UNIX & LINUX platforms
  • Batch Metadata Import Utility (Createdatamaps)
    • Enhanced support around COBOL Copybook processing for VSAM & IMS data


Metadata Manager:


  • New Browser support – Internet Explorer 11.0 and Google Chrome 35
  • New Database versions - Microsoft SQL Server 2014 and Oracle Exadata  11g
  • Security enhancements to prevent displaying JDBC parameters while creating PowerCenter resource


Business Glossary

  • Export of relationship view diagram
  • Support for multi valued attributes display in Business Glossary Desktop


Probabilistic model editor:

  • UI
    • Search can now process wildcard characters
    • User can view number of times a label has been applied in the dataset
  • NER engine:
    • Upgraded Stanford NER engine from v1.2.6 to v3.4

Rule Specification:

  • New functional capabilities:
    • Get current date/time
    • Compare input date/time against current date/time
    • Convert a string containing date and time values to Date/time data type
    • Replace a reference table match with a custom string


Address Validator Transformation:

  • Two new output ports
    • Input data (xml)
    • Result data (xml)
  • Two new outputs in Software Evaluation and Recognition Program (SERP) Report for Canada addresses
    • Processing Date
    • CPC address data file date

Content Management Service:

  • On creation of a new CMS service, the following settings will be set to “ALL” by default
    • No Pre-Load countries
    • No Pre-Load Geocoding countries
    • No Pre-Load Suggestion List countries
    • No Pre-Load Address Code countries


PowerExchange for Relational Databases

  • Oracle 12c Multi-Tenancy: Certification for Multi-Tenant Sources and Targets (Applicable both for PC and IDS/IDQ)
  • DB2 BLU: Certification for in-memory BLU Acceleration from DB2 (Applicable both for PC and IDS/IDQ)
  • New PAM - SQL Server 2014: Added support for SQL Server 2014 (Applicable both for PC and IDS/IDQ)


PowerExchange for Hive

  • Hive Server 2 support: Support for read from Hive Server 2 on Cloudera, HortonWorks and MapR Hadoop distributions
  • Binary data type support: Support only in Hadoop mode of execution


PowerExchange for Data Warehouse


PowerExchange for Vertica (New Product: Applicable only to PC)

  • Native connectivity to only bulk load data to Vertica
  • Support for Vertica 7.0.x


PowerExchange for Netezza (New Product: Applicable only to IDS/IDQ)

  • Support for Netezza ODBC certification for read and write
  • Support for Netezza native functions in ODBC PDO


PowerExchange for Greenplum

  • GPDB ODBC certification and ODBC SSL support (Applicable only to IDS/IDQ)
  • GPDB native interface SSL support (Applicable both for PC and IDS/IDQ)
  • GPDB 4.3 certification (Applicable both for PC and IDS/IDQ)
  • Certification for connectivity to HAWQ using DataDirect Greenplum ODBC driver (for read and write) and gpload (for bulk write). This certification covers both native and Hadoop mode of execution. (Applicable only to IDS/IDQ)


PowerExchange for NOSQL Databases

  • PowerExchange for Cassandra (New Product: Applicable both for PC and IDS/IDQ)
    • ODBC connectivity to Cassandra for loading and extracting data
    • Support for CQL 3.0
    • Support for Collections: Sets, Lists and Maps through normalized Virtual Tables
    • Support for failover to secondary hosts


PowerExchange for Applications

  • PowerExchange for Tableau (New Product: Applicable only to IDS/IDQ)
    • Ability to generate TDE file and write to disk
    • In order to procure a PWX Tableau license, please contact PM (Venkat Lakshminarasimha) with details of customer and use case.
  • PowerExchange for 9.6.1HF1 (New Product: Applicable only to IDS/IDQ)
    • New native reader and writer (converged with the Informatica Cloud Salesforce connector)
    • Bulk reader and bulk writer
    • Read deleted and archived records
    • SFDC API v30 support
    • Deprecated older PWX for SFDC reader(i.e. PWX for 9.6.1 and prior versions)
  • PowerExchange for ODBC (Applicable only to PC. Certified from 9.6.1 onwards.)
    • SAP HANA on cloud (Amazon EC2) is now supported and certified by SAP ICC
  • PowerExchange for SAP (Applicable only to PC. Certified from 9.6.1 onwards )
    • Supported SAP BW Infoproviders objects are published - article288308
  • PAM additions in 9.6.1HF1
    • WebMethods 9.5
    • o IBM WebSphere MQ 8.0


  • Mapping pruning optimization
  • Support for Business Objects 4.0 and 4.1
  • Support for DG4ODBC


AWS certification:

  • Support for PowerCenter Standard Edition & Data Quality Standard Edition
  • Support for Scaling options – Grid, High Availability, Pushdown Optimization, Partitioning
  • Support for PowerCenter connectivity to RDS
  • Support for PowerCenter Domain & Repository in RDS for Oracle and SQL Server database


PAM additions in 9.6.1HF1

  • Windows Server 2012 R2 ( New Domain OS )
  • AWS certification ( First Public Cloud Certification)
  • Tomcat 7.0.55 ( Update )
  • Oracle JDK 1.7.0_55 ( Update )
  • Internet Explorer 11 support  ( New )
  • Safari 7 for Mac Support ( Limited to demos for MM/BG, fully supported in V10


Informatica 9.6.1 Hotfix 1 PAM

Informatica - 9.6.1 HotFix 1 - Release Notes - (English)

Informatica PowerExchange Adapters for Informatica - 9.6.1 HotFix 1 - Release Notes - (English)

Informatica PowerExchange Adapters for PowerCenter - 9.6.1 HotFix 1 - Release Notes - (English)

Informatica PowerExchange - 9.6.1 HotFix 1 - Release Notes - (English)


Click here to download the Hotfixes and other downloads.