Skip navigation
  • PowerExchangefor Social Media (LinkedIn, Twitter and Facebook) on PowerCenter
    • Removed PWXforSocial medial installers and documentation from the installer
  • PowerExchangefor Microsoft Dynamics CRM on PowerCenter
    • PAM addition: Microsoft Dynamics CRM 2013(Active Directory and Passport authentication)
  • PowerExchangefor MongoDB
    • Improved Read and Write Performance(Read Performance improved 1.5X while Write Performance improvements up to 17X.)
  • Data Transformation:
    • New XmlToXlsx document processor, to support generation of Excel 2007/2010 .xlsx documents
  • .PAM Changes
    • Support of Netezza 7.0.3 in AIX platform
    • IBM JDK 1.6 SR15
  • Tomcat upgrade to v7.0.50
  • Bug fixes for
    • Informatica PowerCenter
    • InformaticaData Services
    • InformaticaData Quality
    • InformaticaData Explorer
    • InformaticaSelf-Service DataIntegration (Data Integration Analyst Option)
    • InformaticaData Transformation
    • Metadata Manager
    • PowerExchange
    • PowerConnect

 

Release notes:

Informatica - 9.5.1 HotFix 4 - Release Notes - (English)

Informatica B2B Data Transformation - 9.5.1 HF4 - Release Notes - (English)

Informatica PowerExchange - 9.5.1 HotFix 4 - Release Notes - (English)

This version of PowerExchange for UM includes the following enhancements:

 

  • Support for Ultra Messaging Streaming (UMS) and Ultra Messaging Persistence (UMP) editions of Ultra Messaging as a source and a target. This support is in addition to prior support for Ultra Messaging Queuing (UMQ) edition.
  • Ability to publish on TCP streams or topic streams using Unicast Immediate Messaging (UIM).
  • Wildcard receiver support to allow receiver to subscribe to multiple topics when using PowerExchange for UM with Ultra Messaging Streaming (UMS) as a source.

Informatica PowerExchange for Ultra Messaging - 9.5.1 - Release Notes for PowerCenter - (English)

PAM - Informatica 9.5.1 HotFix 3 - PowerExchange for MOM

Release Highlights:

 

  • Support for SQL Server
  • Support for CAG Version 4.6
  • Support for Data extraction from the following views introduced in CAG 4.6
    • MasterData.DomainConcepts_v;
    • MasterData.DomainsHierarchy_v;
    • MasterData.MetricsResults_v;
    • MasterData.PopulationClassification _v.
  • Support for extraction from new fields added to the existing CAG views
    • Fact.LaboratoryResult_v.LabEventText;
    • Fact. MaterialRole_v. MaterialQuantity_Value;
    • Fact. MaterialRole_v. MaterialQuantity_UnitCode;
    • Fact. MaterialRole_v. MaterialQuantity_UnitCodeSystem;
    • Fact. MaterialRole_v. MaterialQuantity_Conversion.
  • Ability to save last 10 PowerCenter sessions and last 10 PowerCenter workflows worth of log files to simplify potential troubleshooting

 

 

Informatica PowerCenter Integration Pack For dbMotion - 1.2 - Release Notes - (English)

PAM - Informatica 9.5.1- Informatica PowerCenter Integration Pack for dbMotion 1.2

Informatica 9.5.1 HF3 includes the following new capabilities :

 

 

Power Exchange for MongoDB – New Product

 

  • ODBC connectivity to MongoDB(versions 2.2.x and 2.4.x) for reading and writing data
  • Schema inference from sampling data in collections.
  • Support for nested documents, arrays and arrays of nested documents
  • Support for reading and writing documents as JSON.
  • Read Load Distribution through MongoDB “Read Preferences” support.

 

 

Informatica PowerExchange for MongoDB - 9.5.1 HotFix 3 - Release Notes - (English)

Informatica PowerExchange for MongoDB - 9.5.1 HotFix 3 - Release Notes for PowerCenter - (English)

 

Power Exchange for Hadoop.

  • Power Exchange for Hadoop now supports the ability to read and write to HDFS when IBM BigInsights 2.1 is installed on the Hadoop cluster.

 

Admin Account Lock out

  • The Account lockout feature was introduced in 9.5 release. With this feature the domain Administrator can enable a user’s account to be lockout out and access disabled to the Informatica domain and tools after a configurable number of consecutive failed login attempts.
  • The feature can be enabled, configured and locked users unlocked by a user with the Security administrator privilege within the Administrator tool.
  • The feature only applied to non-Administrative users.
  • Starting 9.5.1 HF3 there is an ability to also enable the account lockout feature for Administrative users.
  • This is done via updateDomainOption command or via AdminLockoutEnabled custom property.
  • A locked Administrator account can then subsequently be un-locked via the infasetup command.

 

Tomcat Upgrade:

  • The Tomcat web server has been updated to version 7.0.42. Upgrades to the Tomcat version packaged within Informatica releases are in keeping with Informatica’ s support statement for the same.”

 

Important Bug fixes (see release notes)

 

Informatica - 9.5.1 HotFix 3 - Release Notes - (English)

Informatica PowerExchange - 9.5.1 HotFix 3 - Release Notes - (English)

PAM for Informatica 9.5.1 HotFix 3

New Hadoop Distributions

  • Power Exchange for Hadoop
    • PWX for HDFS
      • Support for MapR 2.1.2
      • Support for Hortonworks 1.1
        • Support for Pivotal 2.0.1 * (please contact Big Data Deal Desk).
      • PWX for Hive
        • Support for MapR 2.1.2
        • Support for Hortonworks 1.1 
        • Support for Pivotal 2.0.1 * (please contact Big Data Deal Desk).
  • PowerCenter on Hadoop (only available as part of PowerCenter Big Data Edition)
    • Support for MapR 2.1.2
    • Support for HortonWorks 1.1
  • Data Quality on Hadoop (requires PowerCenter Big Data Edition)
    • Support for MapR 2.1.2
    • Support for HortonWorks 1.1
  • Data Explorer on Hadoop (requires PowerCenter Big Data Edition)
    • Support for MapR 2.1.2
    • Support for HortonWorks 1.1
  • hParser (included in PowerCenter Big Data Edition)
    • Support for MapR 2.1.2
    • Support for HortonWorks 1.1
  • PWX for Salesforce (IDS/IDQ/BDE)
    • Adopted latest SFDC API version 27
    • Improved performance for bulk mode (3x times)
    • Custom SOQL parameterized
  • PWX for Social Media (IDS/IDQ/BDE)
    • Pagination support for large volume of data for Facebook, Twitter and Linkedin
  • PWX for Netezza ( PC )
    • Support for Netezza 7 (now called as IBM PureData System for Analytics  7)
  • PowerCenter/PowerExchange VSAM/Sequential hierarchical file support of multi-record writing.
  • PWX CDC Datacom Support of  CDC registration of  multi-record identifier datamaps 
  • PWX CDC DB2 LUW Performance Enhancements
  • PWX Express CDC for Oracle Archive Only Support
  • IDQ:
    • Bug fixes
  • IDS
    • Performance and Scale Improvements
  • Data Transformation
    • Bug fixes

JDK Upgrade:

 

  • Oracle JDK –  Oracle JDK 1.6.0_45  (from 1.6.0_43)
  • IBM JDK –  1.6.0 SR13   (from SR12)

 

 

 

You can the latest PAM from here.

 

Informatica - 9.5.1 HotFix 2 – Release Notes - (English)

 

Informatica - 9.5.1 HotFix 2 - New Features Guide - (English)

 

Get the Hotfix installers from the Download section

  Informatica 9.5.1 HF1 includes the following new capabilities

 

  • Informatica 9.5.1 – Data Quality and Hadoop
  • Ability to manually recover aborted/cancelled workflow from admin console and CLI

 

  • Data Transformation 9.5.1
    • Native support for JSON reading
    • New editor for X12 library customization
    • IDQ:
      • Ability to purge orphaned database tables in the Reference Table Warehouse (Database)
      • Developer UI for building, training and managing Classifier models
      • Port level Metadata lineage support
      • Bug fixes

 

  • Metadata Manager
    • Definition of linking rules at the model level
    • Menu options to export and import of resource configurations to/from file
    • Search type ahead

 

  • IDE
    • Metadata Manager Lineage for DQ Scorecards

 

  • PowerExchange for Salesforce.com 9.5.1 –New Product
    • Reading from SFDC Objects - Standard, Custom Objects and Related Objects, including reading of deleted records
    • Bulk read API support for volume processing
    • CDC feature – Time Period and Continuous option
    • Custom SOQL processing
    • Proxy Server support
    • Sorted Ports, Row limit &  Configurable Page/Batch Size

 

 

  • PowerExchange for Twitter 9.5.1 HF1
    • Upgrade to Twitter API version 1.1

 

  • PowerExchange for Twitter Streaming 9.5.1
    • Upgrade to Twitter API version 1.1
    • OAuth 2.0 authentication support

 


  • PowerExchange for LinkedIn 9.5.1
    • OAuth 2.0 authentication support

 

  • PowerExchange for DB2 9.5.1
    • PAM - DB2 10.1 support

 

 

Other enhancements/PAM support in this quarter(non-9.5.1 HF1 shipping)


      • PowerExchange for SAP 9.5.1 (PC)

 

      • AIX 7.1 Support ( updated in PAM as an EBF – contact GCS for details)

 

  • PowerCenter Big Data Edition and PowerExchange for Hadoop support Cloudera 4.1.x

 

 

HotFix Installers can be downloaded from  the Download section

 

Release Notes can be downloaded here

 

New Features Guide can be downloaded here

 

View the latest PAM here

Informatica 9.5.1 includes the following products and highlights

  • PowerCenter on Hadoop 9.5.1         
        • New product offering only available as part of the PowerCenter Big Data Edition (GA).
        • Data sheet:  https://connect.informatica.com/docs/DOC-15281
        • Design ETL logic using Informatica Developer without any hand coding or special knowledge of Hadoop.
        • Execute ETL transformations & mappings on a Hadoop cluster using MapReduce (massive scalability and processing power).
        • Provide connectivity between existing PowerExchange data sources and targets (relational, files, appliances, social media etc …) and Hadoop sources and targets (HDFS, Hive).
        • Centralized monitoring and logging to provide end to end traceability for Informatica jobs running on Hadoop.
        • Ability to import PowerCenter mappings, sources and targets to jump start Hadoop projects for existing PowerCenter users.
        • Supporting Cloudera and Apache distributions of Hadoop.
        • Integrated with B2B DT parser transformation for reading structured & unstructured data.
        • Integrated with DQ column profiling for Hadoop data sources (HDFS, Hive).
        • Integrated with DQ transformations including entity extraction (NLP) .
      • Data Services 9.5.1 (includes Web Services)
      • Data Quality 9.5.1         
        • Ability to classify data based on pre-built models
        • Control of Edit and Create access for Reference Tables
        • Match performance enhancement
        • Support of human task email notifications
        • Execution of Data Quality mappings on Hadoop
      • Data Explorer 9.5.1

       

        • Data Domain Discovery enhancements         
          • Data Domain by example
          • Copy/Export of Data domain rules
          • Export of Data domain discovery results
        • Enterprise Discovery enhancements         
          • Visualization improvements
          • Export of Enterprise discovery results
          • DDL generation
        • Scorecard enhancements         
          • Email alerting upon threshold changes
          • Weighted metrics and weighted average for metric groups
        • Other         
          • Midstream profiling on multi-output group transformation
          • New MX Views for Profiling runtime statistics, and Profile design-time details

       

      • Self-Service Data Integration 9.5.1- Data Integration Analyst Option
      • Data Transformation 9.5.1
      • PowerCenter 9.5.1
      • Metadata Manager and Business Glossary 9.5.1         
        • New XConnect for Informatica Platform (Informatica Data Services and Data Quality deployed mappings)
        • Lineage Diagram 5x performance improvement
        • Business Glossary Desktop
        • Improved change management of BG terms


      • PowerExchange 9.5.1         
        • PowerExchange for DataSift 9.5.1 (Mercury only)- New product
        • PowerExchange for Kapow 9.5.1 (Mercury only)
        • PowerExchange for Facebook 9.5.1 (PC & Mercury)
        • PowerExchange for Twitter 9.5.1 (PC & Mercury)
        • PowerExchange for Twitter Streaming 9.5.1 (PC & Mercury)
        • PowerExchange for LinkedIn 9.5.1 (PC & Mercury)
        • PowerExchange for Email Server 9.5.1 (PC)
        • PowerExchange for JD Edwards Enterprise One 9.5.1 (PC)
        • PowerExchange for JD Edwards World 9.5.1 (PC)
        • PowerExchange for Oracle E-Business Suite 9.5.1 (PC)
        • PowerExchange for Siebel  9.5.1 (PC)
        • PowerExchange for Essbase 9.5.1 (PC)
        • PowerExchange for PeopleSoft 9.5.1 (PC)
        • PowerExchange for LDAP 9.5.1 (PC)
        • PowerExchange for LotusNotes 9.5.1 (PC)
        • PowerExchange for Microsoft Dynamics CRM 9.5.1(PC)
        • PowerExchange for Relational Databases 9.5.1 (PC & Mercury)         
          • DataDirect ODBC 7.0 driver and JDBC 5.0 certification (PC & Mercury)
          • SQL Server 2012 support (PC & mercury)
          • Sybase IQ 15.3 & 15.4 support (PC)
          • HANA support using ODBC (PC & Mercury)

       

        • PowerExchange for Netezza 9.5.1
        • PowerExchange for Teradata PT 9.5.1 (PC & Mercury)         
          • Teradata 14.0 – Linux 64 only (PC & Mercury
          • LDAP support for TPT (PC)
          • TPT Support for Mercury
        • PowerExchange for  GreenPlum 9.5.1 (PC)         
          • Greenplum 4.2 support
          • Partitioning support
          • OS Pipe buffering
          • Parameterization attribute support
          • Session properties
          • Unicode support (data only)

       

        • PowerChannel 9.5.1 (PC)         
          • SQLServer 2012 support
        • PowerExchange for WS Consumer (PC & Mercury) 9.5.1
        • PowerExchange for SAP 9.5.1 (PC & Mercury)         
          • Staging BAPI 7.x support (PC)