Informatica 9.6 includes the following new capabilities :

 

Informatica Platform
  • New Transformations: Normalizer, Sequence Generator, Stored Procedure, Lookup with Dynamic Cache
  • Ability to start workflow from Administrator, automatically recover workflow, and graphically monitor workflow from Administrator
  • DIS & MRS highly available leveraging primary/backup node configuration
  • Improved scalability by Partitioning benefiting Big Data Edition in native and Hive mode of execution
  • Improved Out of Process execution leveraging resource sharing and reuse
  • Ability to view object dependencies

 

Security enhancements for PowerCenter and Platform
  • Kerberos based authentication support providing single sign-on (SSO) and for windows two-factor authentication support
  • Secure communication (SSL) between domain and all platform services
  • New administrator group & lockout for administrator account
  • Domain audit reports for users, groups, roles, privileges and permissions
  • New access privileges for Analyst and Developer tools
  • Enhanced encryption key for passwords persisted within Informatica
  • OS level file security for key Informatica files

 

PowerCenter
  • HA file system persistence augmented with DB based persistence

 

PowerExchange for Databases
  • SSL certification for native source/target connectors for Oracle, DB2 &  SQL Server
  • Platform
    • New JDBC Connectivity
    • Oracle Database, IBM DB2 & SQL Server
    • Improved scalability by Partitioning benefiting PWX for DB2 and PWX for Oracle
    • Calling Stored Procedure through SQL Tx with Result set
  • PowerCenter
    • Generic ODBC PDO is no longer supported
    • Kerberos authentication support for Oracle, DB2, SQL Server & Sybase

 

PowerExchange for Data warehouses
  • Teradata
    • PC& Platform: TTU 14.10 certified
    • PC: Replace custom characters for unsupported TD characters
    • PC: NoSpool feature
    • PC: TPT Export - Multiple Instances Support (undocumented)
  • Greenplum
    • PC: Migration ‘Postgres ODBC driver’ to ‘Progress ODBC’
    • PC & Platform: Progress (Datadirect) ODBC driver for Greenplum v7.1
  • Netezza 7.0
  • SAS
    • PC: Directly read from “*.sas7bdat” data files without the need of SAS server


PowerExchange for SAP
  • PC & Platform: Migrated from Classic RFC libraries to NetWeaver RFC Libraries
  • PC: Secure Network Communication with NetWeaver RFC libraries
  • PC: New ABAP Security features in ABAP Table reader
  • PC: New SAP table reader streaming method with NetWeaver RFC libs by deprecating old CPIC based ABAP programs
  • PC: BW Staging BAPI Partitioning support for 7.x data sources
  • PC: BCI enhancements -
    • 3rd party namespaces
    • delta extraction with timestamp based pointers
  • PAM
  • Additions: SAP NW 7.4, BW 7.4, HANA SP05 support
  • Drop: SAP R/3 4.6c,4.6d, 4.7 (deprecated)

 

PowerExchange for Social Media
  • PC: EOL announcement for PowerCenter based Social Media(LN, TW & FB)
  • Platform:
    • Search and extract data from Facebook Pages and Groups using PWX for Facebook in Informatica Developer
    • Search for multiple user-id in Facebook
    • Configure internet proxy server for Developer Design time in PWX for Social Media(FB, LN, TW, DS)

 

PowerExchange for Microsoft Dynamics CRM
  • PowerCenter – PWX for MSD CRM
    • CRM 2013 Online support
    • Authenticate using Office365
    • HTTP compression support
    • Load into MSD CRM using Bulk API
    • Join two sources from MSD CRM
    • Specify row limit while fetching data from CRM
    • Update the ‘business unit’ of an entity
    • Configure the location of the KRB5.conf & LOGIN.conf files

 

PowerExchange for Salesforce.com
  • Platform – Salesforce.com
    • Source Filter support
    • Uncached Lookup support

 

PowerExchange for Web Services Consumer
  • PC
    • SOAP 1.2 support
    • NTLM v2 support
    • Sharepoint WebServices support
  • Platform
    • RESTful Web Services (JSON & XML)
    • Support WSDL with input only operation
    • NTLM v2 support
    • Sharepoint WebServices support

 

Informatica Connector Toolkit
  • Simplified tooling and code-generation for new on-premise adapters
  • Conversion of cloud adapters for on-premise use

 

Business Glossary:
  • New business-friendly user experience for authoring and managing business terms
  • Collaboration features including change notification and commenting
  • Support for controlled vocabularies, including typed relationships, taxonomies and classifications
  • Per-glossary customization, permissions model, and delegation of administration

 

Data Quality
  • New business focused Analyst Tool interface
    • Customizable UI driven by user role privileges
    • Enhanced filtering and searching capabilities
  • Business Rule Builder
    • Business friendly rule building interface
    • Automated creation of executable objects from logical definitions
  • Universal Record ID
    • Persisted match keys for improved matching performance and usability

 

PowerExchange / CDC
  • Express CDC for Oracle:  Improved performance, Physical DataGuard support
  • Archive only support for Express CDC
  • Threading support for DB2 LUW

 

PowerExchange Mainframe
  • DB2 v11 support
  • IMS V13 Support
  • IPv6 support
  • Adabas: Spanned Records support
  • z/OS Pass-phrase security
  • Operational/Performance improvements
    • Look-up support for both Datacom & IDMS
    • Runtime selection of IMS connectivity (DLI Batch/ODBA)
    • DB2 performance improvements around connection sharing
  • Support for batch generation of PowerExchange Datamaps via INFACMD

 

PowerExchange for Lotus Notes
  • Ability to select multiple fields in Lotus Notes Import
  • Parameterization support

 

PowerExchange for Siebel
  • Siebel v8.2 support

 

PowerExchange for JDE World
  • JDE World v9.3 support

 

Data Explorer
  • Discovery Search – Find all managed data assets and all related assets
  • Enterprise Discovery Curation – Enable data analysts to curate the results of data discovery
  • Enterprise Discovery in Analyst Tool – Enable data analysts to perform enterprise discovery from their browser

 

Data Transformation
  • Mapping/mapplet developed on Informatica Platform and containing Data Processor can now be exported to PowerCenter
  • Improved JSON handling - support reading & writing JSON, and mapping JSON to/from relational ports
  • Data Processor wizards

 

Big Data – Hadoop & NoSQL
  • Support for following Hadoop distributions for PowerCenter execution on Hadoop and PowerExchange connectivity to HBase, HDFS & Hive:
    • HortonWorks 1.3.2
    • MapR 2.1.3
    • MapR 3.0.1 and
    • Cloudera 4.2
  • PowerExchange for HBase:
    • Ability to read and write data in bulk from a HBase table
    • Metadata inference -- Ability to sample data from a HBase table to infer schema
    • Ability to read all keys and values of a column family in a HBase table
    • Ability to write multiple keys and values to a column family in a HBase table
    • All of the above features will be supported in native and Hive mode of execution
    • The HBase version supported is different for each Hadoop distribution
  • PowerExchange for Hive:
    • Support write to dynamic partitions of a Hive table in Informatica platform
    • Support append of rows when data is written to a Hive table (Hive version 0.9 or above) in Informatica platform
    • Support for following Hadoop distributions (in addition to what is mentioned above on Hadoop distribution) in PC PWX
      • IBM BI 2.1 (Hive 0.9) and
      • Pivotal HD 1.1 (Hive 0.11)
    • Write complex file (XML, JSON etc.) using Data Processor and complex file writer transformations in native and Hive mode of execution
    • Support of Normalizer transformation in Hive mode of execution
    • Support generation of unique ID in Expression transformation. This is supported in native and Hive mode of execution.

 

Data Services
  • Improved performance for high volume scenarios
  • Pushdown optimization support for Select distinct, Union, Intersect, SQL Override, Hive
  • Support for limit construct in SQL
  • Tableau certification

 

Platform Support

 

Please refer to the PAM available at https://mysupport.informatica.com/community/my-support/products/informatica_platform/informatica-9.6.0/product-availability-matrices

 

Release Notes Link

 

PowerCenter Release Notes Link

PowerExchange Release Notes Link

Data Transformation Release Notes Link

HIX Release Notes  Link

NACHA Release Notes Link

SEPA Release Notes Link

HParser Release Notes Link

PowerExchange for DataSift 9.6.0 Release Notes     

PowerExchange for Email Server Release Notes for PowerCenter         

PowerExchange for Essbase 9.6.0 Release Notes for PowerCenter      

PowerExchange for Facebook 9.6.0 Release Notes     

PowerExchange for Greenplum Release Notes for PowerCenter

PowerExchange for HBase 9.6.0 Release Notes

PowerExchange for HDFS 9.6.0 Release Notes

PowerExchange for Hadoop 9.6.0 Release Notes for PowerCenter       

PowerExchange for Hive 9.6.0 Release Notes

PowerExchange for JD Edwards World 9.6.0 Release Notes     

PowerExchange for JMS 9.6.0 Release Notes for PowerCenter

PowerExchange for LDAP 9.6.0 Release Notes for PowerCenter

PowerExchange for LinkedIn 9.6.0 Release Notes        

PowerExchange for Lotus Notes 9.6.0 Release Notes for PowerCenter 

PowerExchange for MSMQ 9.6.0 Release Notes for PowerCenter         

PowerExchange for Microsoft Dynamics CRM 9.6.0 Release Notes for PowerCenter     

PowerExchange for MongoDB 9.6.0 Release Notes     

PowerExchange for MongoDB 9.6.0 Release Notes for PowerCenter     

PowerExchange for Netezza 9.6.0 Release Notes for PowerCenter        

PowerExchange for Oracle E-Business Suite 9.6.0 Release Notes for PowerCenter       

PowerExchange for PeopleSoft 9.6.0 Release Notes for PowerCenter  

PowerExchange for SAP NetWeaver Release Notes     

PowerExchange for SAP NetWeaver Release Notes for PowerCenter    

PowerExchange for Salesforce 9.6.0 Release Notes

PowerExchange for Salesforce 9.6.0 Release Notes for PowerCenter   

PowerExchange for Siebel 9.6.0 Release Notes for PowerCenter

PowerExchange for TIBCO 9.6.0 Release Notes for PowerCenter

PowerExchange for Teradata Parallel Transporter API 9.6.0 Release Notes

PowerExchange for Teradata Parallel Transporter API 9.6.0 Release Notes for PowerCenter       

PowerExchange for Twitter 9.6.0 Release Notes

PowerExchange for Web Content-Kapow Katalyst 9.6.0 Release Notes

PowerExchange for Web Services 9.6.0 Release Notes for PowerCenter

PowerExchange for WebSphere MQ 9.6.0 Release Notes for PowerCenter    

PowerExchange for webMethods 9.6.0 Release Notes for PowerCenter