Skip navigation
1 2 Previous Next

PowerCenter

27 posts

The Informatica Events Team is excited to announce our bi-annual Enterprise Architecture Summit. Join the virtual Enterprise Architecture Summit and come away with best practices, design principles, and key insights for enabling cloud data warehouses and lakes modernization. You’ll hear from industry experts and innovators on how to overcome migration challenges and modernize to cloud-native enterprise architectures.

 

Details

Topic: Modernize from Informatica PowerCenter to the Cloud with Next-Generation Enterprise Architectures

  • Date: October 12, 2021
  • Time: 1:30 PM – 3:30 PM CT
  • Duration: 2 Hours
  • Webinar Registration Link: https://reg.rainfocus.com/flow/informatica/arch21/regvirstart/login?cint=other_other_INFANetwork
  • Speakers:
    • Matt Renner, President of US Enterprise Commercial, Microsoft
    • Jitesh Ghai, Chief Product Officer, Informatica
    • Pratik Parekh, GVP & GM, Cloud Modernization, Informatica
    • Josh Alpern, VP, Domain Expert Group, Informatica
    • Ron Lunasin, Sr. Director, Product Management, Informatica
    • Jeff Rydz, Global Segment Leader for Cloud Modernization, Informatica
  • Modernizing data warehouses and lakes to the cloud requires a flexible, cloud-native enterprise architecture that accelerates time to value while minimizing costs and risks.
  • Join the virtual Enterprise Architecture Summit and come away with best practices, design principles, and key insights for enabling cloud data warehouses and lakes modernization. You’ll hear from industry experts and innovators on how to overcome migration challenges and modernize to cloud-native enterprise architectures.
  • Exclusive! Join Informatica experts and fellow architects for a live Q&A.

 

Agenda

1:30 PM CT: Welcome & Opening Remarks: Architecting for Digital Transformation with an Intelligent Data Management Cloud

Jitesh Ghai, Informatica, Chief Product Officer 

To architect for digital transformation, take a comprehensive, AI-powered platform approach.

 

Partner Fireside Chat: Migrating and Modernizing to Cloud-Native Architectures with Microsoft

Matt Renner,  President - US Enterprise Commercial, Microsoft

Jitesh Ghai, Informatica, Chief Product Officer

Join us for a discussion of converging trends in cloud analytics and discover how migration and modernization with Microsoft can help you design for modern cloud-native architectures.

 

Deep Dive and Demo: Migrating to Cloud Data Warehouses and Lakes

Pratik Parekh, GVP & GM, Cloud Modernization, Informatica

Ron Lunasin, Sr. Director for Solution Architecture, Informatica

Discover key capabilities, design principles, architecture, and best practices for migrating to cloud data warehouses and lakes, including an overview of modernization tools that intelligently automate migration from on-premises data management to cloud services.

 

Customer Perspective: Insights from the Cloud Modernization Journey

Hear insights and best practices from a data innovator on their experience migrating from on-premises PowerCenter to a modern, cloud-native platform.

 

Closing Remarks: The Time to Modernize Is Now

Jeff Rydz, Global Segment Leader for Cloud Modernization, Informatica

 

3:00 PM CT: Exclusive! Live Q&A

Join Informatica experts and fellow architects for a live Q&A session.

Are you a PowerCenter developer or architect?

 

PowerCenter is an industrial strength, trusted ETL tool for building enterprise data warehouses, such as Oracle, Netezza, or Teradata. However, your organization is making a decision to modernize to a cloud-native data warehouse such as Snowflake. 

 

Get the maximum value by modernizing PowerCenter to a cloud-native data management platform. Learn how by attending this webinar series that provides the details, including an automated migration program, financial incentives, and expert support from the people who created PowerCenter. 

 

Take the next step in your career by modernizing your data management to the cloud!

 

Date:Thursdays, September 16, 23, 30
Time:1:00pm to 1:30pm EST
Location:Zoom Conference

 

Session 1: How to Overcome Cloud Challenges with a Cloud Native Solution

Speakers: Jeff Rydz and Michael Gultz

 

Session 2: The Best Way to Modernize from PowerCenter to the Cloud
Speakers: Ron Lunasin, Jeff Rydz, and Josh Alpern

 

Session 3: The Latest Cloud-Native Innovations in Action
Speakers: Jeff Rydz and Josh Alpern
Demo by Sumeet Agrawal

 

This 3-part webinar series highlights how an independent, intelligent, cloud-native data management platform addresses today’s customer challenges with cost overruns, resource constraints, and complexity. Session 2 provides details on Informatica’s migration factory and our overall PowerCenter to cloud modernization program. Session 3 highlights the benefits of going cloud-native, such as serverless, ELT, elastic scaling, and much more.

 

Click on the Registration link to register for this webinar series!

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

Filter Blog

By date: By tag: