Skip navigation
1 2 Previous Next

PowerCenter

25 posts

For years, Informatica PowerCenter has been the gold standard for on-premises data integration. For many companies and organizations Informatica PowerCenter, together with an enterprise data warehouse, has served as the backbone of their analytics environment. These organizations have invested a tremendous amount of time, resource, and effort to build the data pipelines on which their businesses run. With the advent of cloud computing, these customers are embarking on a new journey to modernize their enterprise data warehouses to take advantage of all the cloud has to offer: scalability, agility, performance, and cost effectiveness. To accelerate the time to value for these new cloud data warehouse environments, it’s critical that these companies modernize not only their data warehouses but their PowerCenter deployments as well.

 

As a Cloud First Cloud Native company, Informatica understands the importance, and the challenge, that this modernization effort represents to our PowerCenter customers. That’s why we created the Cloud Data Warehouse Modernization Solution for PowerCenter. This solution is designed from the ground up to address our PowerCenter customers’ most pressing concerns and objectives as they modernize to the cloud and invest in cloud data warehouses such as Snowflake, Microsoft Azure Synapse, AWS Redshift, and Google Big Query.

 

This solution modernizes a customer’s PowerCenter deployment to Informatica’s cloud-native platform, Informatica Intelligent Cloud Services (IICS). Using a straightforward usage-based licensing model that incorporates all of Informatica’s cloud-native data integration services - including data quality, mass ingestion, elastic and serverless processing - IICS provides customers with the flexibility and agility they demand from a data management platform that was born in the cloud.

 

How do we help customers accomplish this modernization? With something called the Migration Factory. This is Informatica’s purpose-built tool that incorporates the highest degree of automation possible to migrate a customer’s PowerCenter data assets, including mappings, sessions, and workflows, to IICS. The Migration Factory is by far the fastest, least risky, and most economical option a PowerCenter customer has to modernize to the cloud. Expertise and guidance provided by Informatica’s Professional Services and Customer Success teams ensure that customers are able to maximize their value from the Migration Factory.

 

The solution also provides significant financial incentives to ease the cost of simultaneously running both PowerCenter and IICS during the modernization process before the customer’s transition to IICS is complete. And throughout the entire process, the world-class customer support that customers have come to expect from Informatica is not diminished in any way.

 

If you are a PowerCenter customer, you simply cannot afford to ignore or discard the investment you’ve made in PowerCenter as you pursue your own cloud strategy. Accelerate your success in the cloud by taking advantage of all the data integration content you’ve built instead of starting from scratch.

 

For more information, please refer to the Informatica Success portal.

Gartner Peer Insights recently announced the Customers’ Choice evaluation for the Data Integration market and with your help, this is an opportunity for us to show the IT community how Informatica impacts your business every day. 

 

Click here to submit your review!

 

The survey takes between 5-10 minutes to complete and the reviews are published anonymously. You will be asked to share your business email address and/or LinkedIn profile for Gartner’s verification purposes only.

 

As a bonus…

For a limited time, customers are eligible to receive a $25 Visa gift card once their PowerCenter review is approved as a thank you for your time and honest contribution.

 

Please reach out to Stephanie Lipcsik, SLipcsik@Informatica.com with any questions.

 

About Gartner Peer Insights


Gartner Peer Insights is an online ratings and reviews platform for enterprise IT software and services. The reviews are written and read by IT professionals and technology decision-makers like you.

 

**Note, government and public sector employees are not eligible for incentives per Gartner Community Guidelines

What are we announcing?

Informatica 10.2.0 HotFix1 PowerCenter zLinux support

 

Who would benefit from this release?

This release is the latest version of 10.2 for PowerCenter customers running zLinux

 

What’s in this release?

PowerCenter zLinux support on:

  • Operating system - Red Hat Enterprise Linux 6.9
  • Informatica Domain Database - Oracle 12cR2
  • PowerCenter Repository Support - Oracle 12cR2
  • PowerCenter Connectivity - PWX relational - Oracle, IBM DB2 and MS SQL Server
  • IDS Web Services
  • IBM z Series JDK - 8.0.5.20 

 

Please refer to the 10.2.0 HF1 Product Availability Matrix (PAM) for Informatica Platform for zLinux support details.

 

10.2.0 HotFix 1 Product Availability Matrix (PAM)

 

Informatica 10.2 HotFix 1 Release Notes

 

You can download the Hotfixes from here.

The Informatica Platform is a set of data services and information solutions powered by a state-of-the-art data management engine.   The end of support for the Informatica Platform includes the following products:

 

  • PowerCenter
  • Metadata Manager and Business Glossary
  • PowerExchange (PWX)
  • Data Quality (DQ)
  • Data Transformation (B2B DT)
  • Big Data Management (BDM)
  • Data Integration HUB (DIH)
  • B2B Data Exchange (DX) without OEM Cleo MFT products (see Informatica Product Lifecycle Guide for more details and DX end of life)

 

Support for all Informatica Platform products with versions 9.0.x, 9.1, 9.5.x, and 9.6.x will end on the following dates:

 

Version

Release Date

Minimum Support Period

End of Support

Extended Support*

Sustaining Support*

9.6.x

Jan 2014

31 Jan 2018

31 Mar 2018

31 Mar 2019

31 Mar 2021

9.5.x

Jun 2012

30 Jun 2016

31 Jul 2017

31 Jul 2018

Not Available

9.1

Mar 2011

31 Mar 2015

31 Jan 2017

31 Jan 2018

Not Available

9.0.x

Dec 2009

31 Dec 2013

31 Jan 2017

31 Jan 2018

Not Available

* Extended and Sustaining Support are available at an additional charge; Sustaining Support is not available for all product releases. For further information please contact: dlicare@informatica.com.

 

For more information on product lifecycle, extended support policy, and end of life details of various Informatica products, view the Informatica Product Lifecycle Guide.

This is a feature release of DVO with new capabilities focused on:

 

  • Security
  • Data Connectivity
  • Enhanced Test Generation
  • Improved Usability
  • Support for PowerCenter 9.6

 

New Features and Enhancements in DVO 9.6 include:

 

Security

 

  • User Authentication in Kerberos domain
  • Support for Oracle ASO for DVO repository
  • Encrypt user passwords in DVOcmd

 

Connectivity

 

  • Native PowerExchange support for Mainframe sources
    • IMS, ADABAS, VSAM, DB2 AS/400, MF flatfiles
  • Enhancements to SAP R/3 support to allow reuse of existing ABAP

 

Enhanced Test Generation

 

  • Aggregate View – ability to aggregate any types of data and use in tests
  • Full table/column metadata in spreadsheet exports

 

Usability

 

  • Enhancements to Error Row display for both string/text and numeric values
  • Override SQL View connections when used in Single Tables, Table Pairs or other Views

 

PAM For PowerCenter DVO 9.6.0

Informatica PowerCenter Data Validation Option - 9.6.0 - Release Notes - (English)

This is a feature release of DVO with new capabilities focused on Data Connectivity, Enhanced Test Generation and Improved Usability.

 

New Features and Enhancements in DVO 9.5.2 includes:

 

  • Connectivity
    • XML data support
  • Enhanced Test Generation
    • Drag/drop creation of Value Tests
    • Import Table Pair/Single Table tests from a spreadsheet
    • Export Table Pair/Single Table tests to a spreadsheet
    • Table Pair generation via Compare Tables when table names do not match
    • Table Pair editor to address issues during auto-generation of Table Pairs
  • Usability
    • Full expression editor wherever expressions are accepted
    • SQL View UI enhancements
    • Alias individual columns in a Join View
    • View detailed metadata for imported sources/targets
    • Additional metadata in Detailed Test Results report

 

Informatica PowerCenter Data Validation Option - 9.5.2 - Release Notes - (English)

This is a feature release of DVO with new capabilities focused on performance, metadata and usability. New Features and Enhancements in DVO 9.5.1 include:

 

Performance

 

  • Data Sampling
  • Caching Support

 

Metadata

 

  • Metadata import dialog
  • Metadata refresh improvements
  • Skip invalid objects during export

 

Usability

 

  • Access Session Log file from DVO GUI
  • Support for File Lists
  • SQL Views can be used in Join Views
  • New Bad Records Tab in Test results pane

 

 

Informatica PowerCenter Data Validation Option - 9.5.1 - Release Notes - (English)

Informatica PowerCenter Integration Pack for dbMotion 1.0 has been released to shipping and is available immediately.

 

 

 

Informatica PowerCenter Integration Pack for dbMotion 1.0:

 

  • Delivers ETL (extract, transform, and load) mappings and database schema to enable data transfer from dbMotion Clinical Analytical Gateway (CAG) temporary storage into a persistent data repository;

 

  • While CAG holds only subsets of data, Informatica PowerCenter Integration Pack data repository stores a complete copy of  the production dbMotion database;

 

  • Provides rapid time-to-value through out-of-the-box functionality.

 

 

The Release Notes can be downloaded here

 

The Solution Guide can be downloaded here

 

 

Regards,

 

MySupport Team

DVO 9.5 has been released to shipping and is available immediately

 

This is a significant feature release of DVO with new capabilities aimed at larger deployments and customers with complex testing needs, particularly in production environments.

 

New Features and Enhancements in DVO 9.5

Reporting           

  • New Jasper-based reports and dashboards        
  • Single Sign On (SSO) for Web-based Reports and Dashboards.   
  • Metadata Manager Table Report             

Testing Enhancements 

  • Auto-generate Tests based on Column Position               
  • Parameterization of WHERE clauses
  • Write out all error rows encountered in Testing/Reconciliation  

Additional Enhancements           

  • Copy individual objects via the GUI         
  • Validate PowerCenter expressions in the DVO GUI         
  • Join Expressions in Join View     
  • Authentication for Domain LDAP users 
  • New Licensing Mechanism      

 

 

The Release notes for DVO 9.5 is available here

The User Guide for DVO 9.5 can be downloaded here    

 

 

Regards,

MySupport Portal Team

DVO 9.1.4 includes the followings:

 

  • Updated UI navigation
  • New Connectivity – Salesforce.com, SAS, and Netezza
  • New Connectivity - SAP (transparent tables), DB2 z/OS PowerExchange support
  • Join View – GUI to create heterogeneous joins and use them in tests
  • Support for Percentage thresholds in tests
  • Authenticate users against PowerCenter domain
  • Compare Folders dialog enhancement

 

PowerCenter Data Validation Option 9.1.4.0 Release Notes

The highlights of this release are:

 

  • Significant performance improvements when importing or refreshing PowerCenter metadata in Data Validation Option (DVO). In some internal tests, the performance was upto 10x times more.
  • Naming conventions consistent with PowerCenter. DVO no longer has case sensitivity when importing PowerCenter repository connections.
  • PAM has been improved with PWX ODBC certification with the following:
    • Db2 z/OS
    • DB2 AS/400
    • MF flat files
    • IMS
    • Adabas
  • Added ability to send confirmation and failure email after DVO mapping runs.
  • Improved auto-generation of value tests

 

Informatica PowerCenter Data Validation Option Version 9.1.2.0 Release Notes

The PowerCenter 8.6.1 HotFix 14 is strongly recommended for all customers as it contains important fixes. This is the final HotFix for PowerCenter 8.6.1.

 

Note

For Windows Itanium 64-bit, PowerCenter 8.6.1 HotFix 13 is the final HotFix.

 

 

PowerCenter Version 8.6.1 HotFix 14 Release Notes

This is a feature and bugfix release that supports all versions of PowerCenter from 8.5, 8.6.x onward, up to and including 9.01, 9.1, 9.1H1 (with the exception of 9.0).

 

Highlights of this release:

 

  • Folders - You can organize single tables and table pairs by placing them in folders
  • Error reporting - If a test fails to run, Data Validation Option displays the test run error on the Tests tab.
  • Single Tables tab - The details area contains separate tabs for table pairs and single tables.
  • DVOCmd.exe contains new commands that allow you to create users and refresh repositories.
  • Reports for tests in a folder - You can run reports for all tests in a folder. Reports display the folder name, error messages, join expressions, and conditions, if applicable.
  • When you refresh a repository, you can refresh the entire repository, the connection objects, the folders, or the sources and targets.
  • Expressions in join conditions - When you join two tables in a table pair, you can enter a PowerCenter expression as a field in the join condition. Enter an expression to join tables with key fields that are not identical.
  • Pushing sorting logic to the database - To increase the performance of table pair and single table tests, you can push the sorting logic for joins to the source database. Pushing sorting logic to the database causes the database to sort records before it loads them to PowerCenter which minimizes disk input and output.
  • Large table processing - When you include a large table in a table pair, you can optimize the way Data Validation Option joins table data. You can specify which table Data Validation Option uses for the master or detail table. You can also use sorted output for the join.
  • Filter conditions - You can apply a filter condition to table pair and single table tests. If you apply a filter condition to a table pair test, Data Validation Option applies the filter condition after it joins the tables in the table pair.

 

Informatica PowerCenter Data Validation Option 9.1.0 Release Notes

PowerChannel 9.1 is built and certified with Informatica 9.1.

 

PowerChannel 9.1 Release Notes

Filter Blog

By date: By tag: