Authors: MySupportContentAdmi... Skip navigation

Informatica 9

8 Posts authored by: MySupportContentAdmin

Highlights of this release:

 

Bug fixes for the following products:

  • Informatica Data Services
  • Informatica Data Quality
  • Informatica Data Explorer
  • Informatica Self-Service Data Integration (Data Integration Analyst Option)
  • Informatica Data Transformation
  • PowerCenter
  • Metadata Manager
  • PowerExchange

 

PowerExchange: Toleration Support for DB2 V10 CDC

 

Data Transformation: B2B Data Transformation provides a new pre-processor which supports Excel 2003/2007/2010 versions. The new pre-processor support the following Excel formats:

  • xls
  • xlsx
  • xlsm
  • Mac 2011 files

 

Profiling/ Informatica Data Explorer (IDE) 9.1.0 HotFix 2

  • Overlap discovery (gap filled from IDE Legacy).
  • Synchronization of metadata of Data Objects (relational/flat file) with external source (Analyst enhancement).
  • Synchronization of Profiles/Scorecards/Profile Models with any underlying changes in Data Object and Rule metadata (Analyst and Developer).
  • Exporting Profile Results from Informatica Developer to your local computer (instead of to the IDE server machine).

 

Data Services

  • Easily expose flat file and relational physical data objects as web services.
  • Ability to directly deploy reusable objects (data objects, transformations, and mapplets) as web services.
  • Certification of OBIEE for accessing data from published SQL data services.

 

Localization

  • PowerCenter is localized into Japanese and Brazilian Portuguese.
  • PowerExchange and Metadata Manager are localized into Japanese.
  • PowerCenter and PowerExchange documentation is available in Brazilian Portuguese.
  • Analyst Tool is available in German, French, Spanish and Simplified Chinese.
  • Analyst Tool online help is available in German and French.
  • DxT is available in Spanish and Simplified Chinese.

 

Release notes:

Informatica 9.1.0 HotFix 2 (ENGLISH)

 

Informatica 9.1.0 HotFix 2 (GERMAN)

 

Informatica 9.1.0 HotFix 2 (FRENCH)

 

Informatica 9.1.0 HotFix 2 (PORTUGUESE)

Highlights of this release:

 

Bug fixes for

  • Informatica Data Services
  • Informatica Data Quality
  • Informatica Data Explorer
  • Informatica Self-Service Data Integration (Data Integration Analyst Option)
  • Informatica Data Transformation
  • PowerCenter
  • Metadata Manager
  • PowerExchange

 

IDS

  • Enhanced Web Services capabilities such as improved performance and scalability, advanced schema support and other usability enhancements such as the ability to easily expose reusable objects as web services.
  • Integration with MDM Informatica Data Director provides the ability to integrate detailed operational data from an SQL data service with Informatica Data Director to give data stewards access to a complete view of data. Data stewards can view virtual table data on a custom tab when they select a master record in Informatica Data Director.

 

AT Enhancements

  • Analysts can now export the mapping specification logic as a mapplet or mapping to PowerCenter
  • Analysts can extract data from multiple sources and export it to a flat file target
  • Analysts can publish the mapping specification as a Virtual Table that can be accessed through ODBC
  • Analysts can now include lookup transformations in their mapping specification logic

 

Jaspersoft integration: Basic INFA-Jaspersoft integration built and implemented including installer integration and single sign-on

 

Hadoop Connectivity for PowerCenter (PowerExchange for Hadoop)

  • Read and Write from/to HDFS (Hadoop File System) natively as source/targets within PowerCenter
  • Support for basic Hive metadata population (so data persisted into HDFS can be queried via Hive)
  • Support delimited flat file format only for input and storage (users can pre/post process the data within PowerCenter to such format using any supported transformations)

 

Monitoring Reports: More in-built reports for Web Services and Data Services, providing key operational metrics

 

Various certification: See PAM for details

 

Release notes:

Informatica 9.1.0 HotFix 1 (ENGLISH)

Informatica 9.1.0 HotFix 1 (PORTUGUESE)

PowerExchange for Hadoop

PowerExchange 9.1.0 HotFix 1 (ENGLISH)

PowerExchange 9.1.0 HotFix 1 (PORTUGUESE)

Please raise a Shipping SR to get Informatica 9.1.0 products.

 

Informatica 9.1.0 includes the following products:

  • Informatica Data Services 9.1.0 (includes Web Services)
  • Informatica Data Quality 9.1.0
  • Informatica Data Explorer 9.1.0
  • Informatica Self-Service Data Integration 9.1.0 (new product)
  • PowerCenter 9.1.0
  • Metadata Manager 9.1.0
  • PowerExchange 9.1.0
  • PowerExchange for Oracle E-Business Suite 9.1.0
  • PowerCenter Dual Load Option for Teradata 9.1.0
  • PowerExchange for Email Server 9.1.0
  • PowerExchange for Essbase 9.1.0
  • PowerExchange for JD Edwards Enterprise One 9.1.0
  • PowerExchange for JD Edwards World 9.1.0
  • PowerExchange for LDAP 9.1.0
  • PowerExchange for LotusNotes 9.1.0
  • PowerExchange for Siebel 9.1.0
  • PowerExchange for Teradata PT 9.1.0

 

 

Platform Support

 


Refer to the Platform Availability Matrix (PAM)

 

Note

 


The following adapters will be available by the end of April:

  • PowerChannel 9.1.0
  • PowerExchange for SAS 9.1.0

 

 

 

Release notes

 

This HotFix includes:

  • Informatica Data Services
  • Informatica Data Quality
  • Informatica Data Explorer Advanced Edition
  • PowerCenter
  • Metadata Manager

 

Highlights of this version:

  • Informatica Data Services Enhancements
  • Informatica Data Quality Enhancements
  • Informatica Data Explorer Advanced Edition Enhancements

 

Note:

9.0.1 HotFix 2 has a full installer. Informatica provides a hotfix installer for the Informatica services and the Informatica clients. Apply 9.0.1 HotFix 2 to the 9.0.1 Informatica Developer Client. You cannot connect to the Informatica domain using Informatica Developer from a previous version.

 

Platform Support:

For more information on platforms supported in this release, see product availability matrix.

 

Release Notes:

Informatica 9.0.1 HotFix 2 (English)

Informatica 9.0.1 HotFix 2 (Japanese)

Informatica 9.0.1 HotFix 2 (Portuguese)

Informatica 9.0.1 HotFix 1 is now available.

 

This hotfix release includes:

 

  • Informatica Data Services
  • Informatica Data Quality
  • Informatica Data Explorer Advanced Edition
  • PowerCenter
  • Metadata Manager

 

Highlights of this release:

  • Extended PAM support – Win 2008 R2, SQL 2008 R2 and Win IA64 (v2003)
  • Bug fixes and minor enhancements. See release notes for details.

Release notes:

Informatica 9.0.1 HotFix 1


Note:

Informatica provides a hotfix installer for the Informatica services and the Informatica clients. Apply 9.0.1 HotFix 1 to the 9.0.1 Informatica Developer Client. You cannot connect to the Informatica domain using Informatica Developer from a previous version.

In accordance with Informatica's product support lifecycle detailed in the Informatica GCS Guide to Services, Policies and Procedures and in the End User License Agreement (EULA), support for an Informatica release ends 18 months after the General Availability (GA) of the next major release.

 

Please refer to the Informatica Products EOL Notification for further updates.

 

If you have questions, please email infagcsalert@informatica.com.

Is Informatica 9.0.1 generally available?

Informatica 9.0.1 is generally available starting June 18, 2010.

Is Informatica 9.0.1 available globally at the time of the launch?

The Informatica 9.0.1 GA release will be shipped globally in English, Brazilian and Portuguese. Localized software and documentation for other languages will be rolled out in phases.

Is documentation available?

All release notes and product documentation are available on My Support. You can also search the documentation using the Informatica Knowledge Base.

 

Where can I find more information?

 

Additional information can also be found at the Informatica 9 website, www.informatica.com/9

More feature specific multimedia demos will be available soon in the Multimedia KB section of My Support.

 

If you have further questions not covered by this document you can post them on the Informatica 9.0.1 user forum. You can also search the Informatica knowledge base or open a service request with Informatica support.

How can I receive the Informatica 9.0.1 software install?

Open a Shipping Service Request on My Support.

Installation and Upgrade

Can I upgrade from previous versions to Informatica 9.0.1?

You can upgrade all currently supported versions of PowerCenter Editions (Standard, Advanced and Real Time Editions) including Metadata Manager, Data Analyzer, Data Quality and PowerExchange.

What is the end of life policy for PowerCenter 8.x?

The end of life for PowerCenter versions 8.1.x, 8.5.x and 8.6.x will be December 2011. Please refer to the Informatica Products EOL Notification document for further updates.

What operating systems and databases are supported by Informatica 9.0.1?

Refer to the Product Availability Matrices section of My Support for all platform compatibility details.

Are 32-bit platforms supported with Informatica 9.0.1?

Informatica 9.0.1 32-bit is available for the Windows and Linux operating systems only.


Informatica 9.0.1 64-bit is available on all operating systems including Windows and Linux.

For more details on the 32-bit support policy refer to the EOL Announcement for 32bit UNIX PowerCenter. For further assistance contact your account representative.

Will Informatica 9.0.1 follow the same (feature-based) license structure of previous versions?

Informatica 9.0.1 will continue to have features that are enabled by license. The new tools (Informatica Developer and Informatica Analyst) are licensed differently and you need to contact your account representative for more details.

Will Informatica 9.0.1 follow that same HotFix release cycle as in previous versions?

Informatica will continue to support the same release cycle including HotFixes.

New Features

What new features are there in Informatica 9.0.1?

Informatica 9.0.1 includes significant new functionality in the areas of SOA-based data services, pervasive data quality and business/IT collaboration.

 

The Informatica 9 microsite includes more information regarding these new functionalities, www.informatica.com/9.

Are there new client tools available with Informatica 9.0.1?

Informatica 9.0.1 includes the Informatica Developer and Informatica Analyst client tools. The Informatica Developer tool is eclipse-based and supports both data integration and data quality for enhanced productivity.


The Informatica Analyst tool is a browser-based tool for analysts, stewards and line of business managers. This tool supports data profiling, specifying and validating rules (Scorecards), and monitoring data quality.

Have the Informatica Services changed?

The PowerCenter Administration Console has been renamed the Informatica Administrator. The Informatica Administrator is now a core service in the Informatica Domain that is used to configure and manage all Informatica Services, Security and other domain objects (such as connections) used by the new services. The number of objects stored in the domain database has increased significantly to accommodate these new requirements.

Is the core architecture of PowerCenter 9.0.1 changed from 8.x?

The basic architecture of the core PowerCenter tools has not been changed in 9.0.1.

Can the same client tool be used to work with Data Quality and Data Explorer in version 9.0.1?

Yes, data quality and data profiling can be used in a unified manner in the Informatica Analyst as well as the Informatica Developer tool.

Is Data Quality integrated with the Informatica Administrator?

With Informatica 9.0.1 Data Quality, PowerCenter, PowerExchange and Data Services are all integrated into the Informatica Administrator.

Are mappings compatible between the Informatica Analyst tool and the Informatica Developer tool? Is it possible to import Informatica Analyst mappings into the Informatica Developer?

Yes, the mappings and rules are shared between Informatica Analyst and Informatica Developer with unified metadata underneath.

Does Informatica Developer interact with Informatica PowerCenter? Can Informatica Developer generate a mapping that can be accessed in PowerCenter Designer?

Informatica Developer will allow you to create Logical Data Objects that can be used as Data Sources in Informatica PowerCenter Designer. You can also export from the developer and import as a mapplet in the PowerCenter Designer.

What's new in PowerExchange 9.0.1?

PowerExchange 9.0.1 contains many new enhancements for the various different backend systems. Following are some of the examples:

·        PowerExchange Services can now be easily managed using the Informatica Administrator

·        PowerExchange connections (including mainframe connections such as VSAM and IMS) can also be managed from Administrator and used with the new services

·        Connection pooling

 

 

 

 

How has Reference Table Manager changed in Informatica 9.0.1?

The Reference Table Manager has an improved user interface, more sophisticated audit capabilities, integration with Data Quality dictionaries and support for name and location parameterization.

Are the PowerCenter client tools web based in Informatica 9.0.1?

The PowerCenter 9.0.1 Designer, Repository Manager and Workflow Manager continue to be a thick client tools.

Can web services be used for real time dashboarding?

The data services capabilities in Informatica 9.0.1, both over SQL and web services, can be used for real time dashboarding.

Does Informatica 9.0.1 comply with the ISO 27001:2005 security standard?

Informatica 9.0.1 supports security at both the Data Services level, and at the underlying application and database levels.
However, Informatica 9.0.1 is not certified with any ISO standards at this point.

Informatica 9.0.1 includes:

 

  • Informatica Data Services
  • Informatica Data Quality [includes Informatica Analyst]
  • Informatica Data Explorer
  • Informatica Data Explorer Advanced Edition
  • PowerCenter [Standard Edition, Real Time Edition, Advanced Edition]
  • PowerExchange [including Neoview and Netezza]
  • Metadata Manager

 

Following are the highlight of this release:

 

DI Tools and Platform

  • Platform – Theme: Production Readiness
    • Upgrade support from PowerCenter (8.1.x, 8.5.x, 8.6.x, 9.0.0)
    • I18N Support – Simultaneous release in Brazilian Portuguese
    • Additional connectivity – VSAM, IMS, SAP Table Reader – for IDS & IDQ/IDE
    • Parameterization (only for deployed objects)
    • Data source simplification
    • Metadata Reporting
    • License Compliance
  • IDS – Theme: Competitive Parity
    • Pass-through Security
    • Column-level Security
    • Unstructured Data Support (UDO)
  • PowerExchange
    • CDC Support for Oracle Transparent Data Encryption and Oracle Materialized Views
    • Performance improvements
  • Metadata Manager & Business Glossary – Ready for prime time
    • BG Change notifications through email
    • Impact Summary (fka where-used analysis)
      Lineage diagram enhancements
    • Export and import of XML files for resource configuration and content
      Command line for all relevant UI actions
    • Improved Performance, scalability, longevity

 

Data Quality

 

  • IDQ – Theme: Enterprise Scale
    • IDQ Upgrade Utility – support for migrating plans/mappings from 8.6.2 or 9.0.0 to IDQ 9.0.1
    • GAV SERP & CASS Certified (limited platform support)
    • GAV Performance improvements: Multi-threaded AV engine 
      Decision Transformation (if/then/else)
    • Object Import/Export improvements (UI based, RTM support)
    • Parameterization of Reference Tables (only for deployed objects)

 

  • IDE – Theme: Enterprise Scale
    • Profiling performance improvements
      • ‘Live’ Drilldown of Rules, Scorecards
      • Auto purge of profiling results
      • ‘Incremental’ Profiling
    • Profiling of SAP, VSAM and IMS sources
    • Grouping of scorecards
    • Upgrade support for profiles/scorecards from 9.0.0 to 9.01

 

For product availability and compatibility details view the Informatica 9 Product Availability Matrices or the Informatica 9 Product Documentation Center.