Authors: Vidya Skip navigation

Informatica 9.5.1

6 Posts authored by: Vidya
  • 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 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)