Communities
My Support
Marketplace
Worldwide
Australia / NZ
Brazil
Canada
China
France
Germany
Hong Kong
India
Italy
Japan
Korea
Latin America
Netherlands
Portugal
Russia
Southeast Asia
Spain
Sweden
Switzerland (French)
Switzerland (German)
Taiwan
United Kingdom
United States
More
Vision
Return on Data
Big Data
Social Data and Devices
OLTP and Analytics
Hadoop
A Platform Approach
Analysts Support Informatica
Latest Release
Controlling the Cloud
Best Practices
Integration Competency Centers
Lean Integration
Lean Data Management
Informatica Blog
Products
Application ILM
Data Archive
Data Subset
Data Warehouse Advisor
ILM Nearline
B2B Data Exchange
B2B Data Exchange
B2B Data Transformation
HParser
Cloud Data Integration
Complex Event Processing
RulePoint
Proactive Monitoring
Data Masking
Dynamic Data Masking
Persistent Data Masking
Data Quality
AddressDoctor
Data Explorer
Data Quality
Data Replication
Data Replication
Fast Clone
Data Virtualization
Data Services
Enterprise Data Integration
PowerCenter
PowerExchange
Master Data Management
Master Data Management
Identity Resolution
Cloud MDM
Messaging
Ultra Messaging Streaming Edition
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Solutions
Enterprise Data Integration & Management
Data Governance
Data Migration
Data Quality
Data Synchronization
Data Warehousing
Identity Resolution
Master Data Management
Service Oriented Architecture
Cloud Data Integration
Software as a Service
Infrastructure as a Service
Solutions for Applications
Application Sustainability
Application Modernization
Application Innovation
Application Information Lifecycle Management
Database Archiving
Test Data Management
Data Privacy
Application Retirement
B2B Data Exchange
Data Aggregation
Trading Partner Gateway
Business Solutions
Governance, Risk, and Compliance
Mergers and Acquisitions
Customer Acquisition and Retention
Industry Solutions
Banking and Capital Markets
Energy and Utilities
Healthcare
Insurance
Life Sciences
Manufacturing
Public Sector
Retail
Telecommunications
Transportation
Customers
Featured Customer Stories
Australia's Liquor Marketing Group (LMG) Transforms Business
Advent Software Relies on Informatica for Cloud Integration
View Customer Roster
More Customer Stories and Videos
UMass Memorial Health Care
Improving decision making and clinical outcomes
PDI
Increasing sales effectiveness
Kelley Blue Book
Enhancing user experience
Netherlands Ministry of Defense
Saving $65 million annually
Services & Training
Informatica University
Contact
Course Directory
Course Formats
Pricing
FAQ
Professional Services
Service Offerings
Velocity Methodology
Accredited Partners
Certification
Data Integration
Data Quality
Master Data Management
Velocity
Certification Frequently Asked Questions
Support Services
Global Support Centers
Support Programs
Resource Library
Go to the Resource Library
View the Upgrade Center
Analyst Reports
Assessment Tools
Books & Articles
Brochures & Datasheets
Demos & Chalk Talks
Webinars
White Papers
Company
About Informatica
Leadership
Awards and Recognition
Corporate Citizenship
Partners
Become a Partner
OEM Program
Careers
News & Events Calendar
In the News
Press Releases
Events & Webinars
Press Room
Investor Relations
Contact/Locations
CONTACT US
Blogs
Facebook
Twitter
Share
Print
Close
Informatica Blogs
Informatica Corp.
The Biggest Dirty Little Secret in IT
Informatica Corp.
A key growth milestone for the Informatica Marketplace
Informatica Corp.
Marge Breya and Rick Smolan Discuss the Growing Amount of Data
Informatica Corp.
Why Big Data Leaders are Made and Not Born
Informatica Corp.
An EMR isn’t enough, Part I
Informatica Corp.
Stepping Up to the Big Data Integration Challenge
Close
Informatica on Facebook
Informatica Corp.
The Biggest Dirty Little Secret in ITThe Biggest Dirty Littl
Informatica Corp.
Last week Informatica Corp. CMO, Marge Breya spoke with Rick
Informatica Corp.
A key growth milestone for the Informatica MarketplaceInform
Informatica Corp.
Did you know that Informatica Marketplace has over 1,000 app
Informatica Corp.
Marge Breya and Rick Smolan Discuss the Growing Amount of Da
Informatica Corp.
Less than two weeks until Informatica World! There are more
Close
Informatica on Twitter
Follow Us
Close
Share
Facebook
Twitter
Linkedin
Email
More
Resource Library
>
Upgrade Center
> PowerCenter
PowerCenter Upgrade Center
Overview
Features
9 + 5 Reasons to Upgrade to Informatica PowerCenter 9.5
Increase Agility in Delivering Critical Data and Reports to the Business
Access, profile and merge existing data and “big” data in real-time to deliver new insights rapidly with the
PowerCenter Data Virtualization Edition
.
Harness the Power of Big Data
Leverage leading
Hadoop
distributions with enhanced capabilities loading to, processing on, and extracting from Hadoop.
Connect with Social Media Data
Capture feedback from social media streams with a streaming API for incoming data feeds, including enhanced
Facebook, Twitter and Linkedin
connectivity now optimized for
data services
,
data quality
,
profiling
and
MDM
use cases.
Enable true business-IT collaboration
Empower the analyst to directly find the business terms and data using Business Glossary and define mappings they need from higher level specifications with the
Data Integration Analyst Tool
.
Analysts can now perform simple data integration tasks on their own with guided mappings that auto-map source to target, provide join recommendations, and preview data midstream.
Simplify Web services development
Build Web services from WSDL or existing data objects, transformations and mapplets, handle complex data types, consume RESTful Web services and reuse services much more easily than ever before with the new
Data Services Web Services Option
.
Boost productivity with metadata management
Manage change better while preserving data integrity with
Metadata Manager
and
Business Glossary
’s optimized data lineage and impact analysis..
Test changes and upgrades up to 10x faster and increase test coverage with the Informatica Data Validation Option
Any time you move or transform data, you run the risk of introducing errors. Become 10x more productive and reduce the risk of negatively impacting the business while increasing test coverage at the same time with the
Informatica Data Validation Option
.
Validate Your Production Data with the Informatica Data Validation Option
Schedule automatic data reconciliation of any data updates to production systems and help identify issues before they impact the business using the
Informatica Data Validation Option
.
Proactively Identify Data Integration Risks
Protect data integration projects by leveraging more than 25 pre-built rules and template that can help identify and alert on situations that may lead to process failures with
Proactive Monitoring for PowerCenter Operations
.
Minimize risk through data governance
Implement data governance with
Business Glossary
,
Metadata Manager
, and
integrated data quality
support, now with approval workflow and change notifications for business terms for Business Glossary.
Improve mainframe access and performance
Maximize your mainframe investments with access and performance enhancements including
real-time change data capture
,
VSAM partitioning
, DB2 bulk loading and high availability. Reduce MIPS cost by offloading processing to zIIP processors.
Harden your real-time operations
Take advantage of improvements to
PowerCenter Real Time Edition
including
real-time change data capture
enhancements, even greater Web services scalability, and guaranteed once-only message delivery.
Bullet-proof your security
Secure your data integration environment with centralized user and role administration, enhanced
LDAP integration
, SSL remote access and support for Internet Protocol version 6 (IPv6).
Support mission critical 24x7 operations
Access, integrate and deliver your critical data whenever you need it with enhanced capabilities including high availability for PowerExchange and dynamic lookup cache for real-time data.
PowerCenter 9.5
PowerCenter Advanced Edition: Metadata Manager
Capabilities:
Delivers new XConnects – SAP Netweaver Business Warehouse, IBM Rational Data Architect, and BI and data modeling sources
Includes new XConnect certifications – IBM Cognos 10, CA ERwin 8, MicroStrategy 9.2.1, Oracle Business Intelligence Enterprise Edition 11g, Sybase PowerDesigner 16 and Embarcadero ER/Studio 8.5.1
Delivers new, easy-to-use custom XConnect with better manageability of loads via validation and user-friendly logging
Benefits:
Expands metadata management connectivity
Informatica Data Integration Analyst Option
Capabilities:
Enables guided mappings that auto-map source to target, provides join recommendations, and previews data midstream in the mapping
Embeds profiling within mapping specifications, increasing analyst productivity and understanding of data
Enables SQL query interface for mapping specifications for those analysts who prefer to validate mapping logic using SQL
Provides descriptions that improve collaboration between analysts and developers
Benefits:
Increases productivity for self-service and collaboration for analysts
PowerCenter Pushdown Optimization Option
Capabilities:
Supports SQL-based error tables in Teradata
Supports SQL MERGE for Teradata
Supports case-insensitivity in aggregation on Teradata
Supports subquery when using SQL overrides on Teradata
Benefits:
Increases support for pushdown optimization in Teradata
PowerCenter Data Validation Option
Capabilities:
Includes functionality focused on operational production validation scenarios
Incremental data validation
Enhanced management reports and dashboards with drill down capabilities
User authentication via PowerCenter domains
Extends data connectivity with Salesforce.com, SAS, SAP Transparent Tables, IBM DB2 zOS, and IBM Netezza
Includes join wizard for complex table joins and heterogeneous tables
Benefits:
Lowers risk of production failures when rolling out new data integration processes to production systems