Access and Deliver Enterprise Data Quickly, Easily, Cost-Effectively

Informatica PowerExchange is a family of products that enables your IT organization to retrieve all sources of enterprise data without having to develop custom data-access programs. By accessing mission-critical operational data where it's stored and delivering it where and when it's needed, your IT organization can maximize its limited resources and the business value of its data.

  • Lower development costs by supporting rapid impact assessment and deployment as changes arise, through automated metadata capture
  • Prevent unauthorized access to sensitive data by accessing data directly, rather than extracting files and transferring them to less-secure environments
  • Maximize return on investments by supporting rapid access to standards-based sources and targets, enhancing business agility

Informatica PowerExchange Key Features

Accelerated Access to Enterprise Data

  • Requires no specialized programming skills to update enterprise data, minimizing administrative effort
  • Employs flexible object filtering techniques to rapidly locate needed data
  • Uses a point-and-click interface to accelerate development and reduce errors

Optimized for Each Environment

  • Supports native datatypes and special features of each environment
  • Uses available native interfaces and high-speed APIs
  • Exposes the capabilities of each application with a purpose-built GUI

PowerExchange for Databases and Data Warehouses

Informatica PowerExchange for Databases and Data Warehouses provides access to all major enterprise database systems and data warehousing environments.

More Info

Supported Applications and Interfaces

Supported Applications and Interfaces
Enterprise Data Stores Source Target CDC Option
Adabas for UNIX, Windows  
Adabas for z/OS *
Binary Flat Files  
C-ISAM    
Datacom  
DB2 for i5/OS
DB2 for Linux,
UNIX and Windows
DB2 for z/OS
Essbase  
IDMS   *
IMS DB
Informix
Dynamic Server
 
ODBC  
Oracle
SQL Server
Sybase  
VSAM

* Supports log-based change capture

Data Warehouse Environments Source Target Interfaces Supported
Netezza Performance Server ODBC
Teradata TPT, ODBC
HP Neoview ODBC, ODBC, Transporter
EMC Greenplum  

PowerExchange for Enterprise Applications

Informatica PowerExchange for Enterprise Applications provides access to all major enterprise and packaged applications, whether they are on-premise, outsourced, or hosted software-as-a-service (SaaS).

More Info

PowerExchange for Hadoop

Informatica PowerExchange for Hadoop provides access to support data-intensive distributed applications.

More Info

PowerExchange for Mainframes

Informatica PowerExchange for Mainframes provides access to enterprise data housed on z/OS and z/Linux in popular relational and pre-relational systems.

More Info

PowerExchange for Messaging Systems

Informatica PowerExchange for Messaging Systems provides access to the message-oriented middleware (MOM) used in many high-performance, event-driven, and enterprise application integration (EAI) architectures.

More Info

PowerExchange for Midrange

Informatica PowerExchange for Midrange Systems provides access to enterprise data stored on i, i5/OS, and OS/400 systems.

More Info

PowerExchange for Social Media Networks

Informatica PowerExchange for Social Media provides access to data from popular social networks.

More Info

PowerExchange for Technology Standards

Informatica PowerExchange for Technology Standards provides access to data via industry-wide technology standards, such as email, LDAP, and Web services.

More Info

Change Data Capture Option

Satisfy Requirements for Up-to-the-Minute Data with Change Data Capture

The Informatica PowerExchange Change Data Capture Option captures changes in a number of environments as they occur, enabling your IT organization to deliver up-to-the-minute data to the business. Based on patented technology, this option recognizes business events—such as customer creation or order shipment data—by capturing the database inserts, updates, and deletes underlying these events as soon as they occur. This captured stream of database activity can be delivered to multiple targets in real time, without intermediate queues or staging tables. Event-driven data captured by this option can be transformed and cleansed continuously and used to drive business processes. This option is available for all popular enterprise database systems.

  • Improve IT’s responsiveness to the business by supporting right-time access and delivery of data, regardless of its source
  • Enhance business agility by enabling business events, not technology, to drive business processes
  • Reduce IT costs by using fewer machine resources than batch data access requires and by relying on
    point-and-click development methods

Informatica PowerExchange Change Data Capture Option Key Features

  • Easy-to-use graphical interface that supports rapid impact assessment and deployment as changes arise, powered by automated metadata capture
  • Flexible, noninvasive capture changes from relational and pre-relational databases on mainframe, midrange, and commodity systems
  • Secure, codeless access to captured changes for accessing changes once and routing them to multiple targets without using staging tables or intermediate queues
  • Visibility into captured changes from committed transactions so that you can deliver the latest version of data—even when hundreds or even thousands of changes are made to it daily

Services & Training

Informatica offers a full range of services and training to help you maximize the value of the Informatica Platform in your environment.

Learn More About Services

PowerExchange Buzz

CDC PC Session Error
I am facing the following error while running CDC Session

PowerExchange Blocks

PowerExchange for SAP NetWeaver
By Informatica Platform

PowerExchange for Adabas
By Informatica Platform

All PowerExchange Blocks

Recent PowerExchange Connectors Customers

View All
  • AARP

    AARP needed a way to gather, integrate and leverage ever more data in the present while preparing for dramatic growth in the near future.

    AARP needed a way to gather, integrate and leverage ever more data in the present...
    EVERTEC

    By standardizing on the Informatica Platform, EVERTEC is helping its largest customer, Banco Popular, achieve the three critical goals that all financial service organizations aspire to: lower costs, meet compliance targets, and grow the customer base.

    By standardizing on the Informatica Platform, EVERTEC...
  • Millennium: The Takeda Oncology Company

    The company needed an efficient, cost-effective way to transition from an outdated customer relationship management (CRM) solution to a new Software-as-a-Service (SaaS) CRM system from Salesforce.com.

    The company needed an efficient, cost-effective way to...
    Florida Turnpike Enterprise

    To keep the highways in good repair for both ordinary traffic and weather-related evacuations, the FTE needs ready access to accurate, up-to-date data about traffic volumes, toll revenues, and safety procedures.

    To keep the highways in good repair for both ordinary traffic and...
  • Rochester Institute of Technology

    To make smart academic decisions and comply with federally mandated reporting requirements, the university needed to integrate dozens of separate databases into a single data warehouse of student information.

    To make smart academic decisions and comply with...
    3Com

    As a result of numerous mergers, each individual business unit had its own discrete information systems. To create a more holistic view of its global operations, 3Com needed to consolidate these systems into a single enterprise-wide reporting infrastructure.

    As a result of numerous mergers, each individual business unit had...
  • ACH Food Companies

    The company needed to absorb businesses they acquired more quickly and improve its ability to share data throughout the organization.

    The company needed to absorb businesses they acquired more quickly and improve...
    Foster's Group

    Foster’s wanted to consolidate and simplify its ERP systems, establishing a common set of business processes, and improving the quality of data throughout the enterprise.

    Foster’s wanted to consolidate and simplify its ERP...
  • AspenTech

    AspenTech used the Informatica platform to control its clients' supply chain integration costs.

    AspenTech used the Informatica platform to control its clients' supply chain...
    Oi

    To give sales, service, marketing, and management the business intelligence necessary to stay competitive in a heated market, Oi needed to manage its customer data faster and more effectively.

    To give sales, service, marketing, and management the...
  • CA Technologies

    The company needed to integrate the different opportunities within Salesforce CRM into one unified global picture of every customer relationship.

    The company needed to integrate the different opportunities within Salesforce CRM...
    BNSF Railway Company

    One of North America’s largest railway companies wanted to offer customers Web-based, self-service information to track shipments and place orders.

    One of North America’s largest railway companies wanted to...
  • Ensenda

    Ensenda manages a network of the top local delivery firms linked through its real-time technology that enables shippers to offer quality delivery experiences to their customers.

    Ensenda manages a network of the top local delivery firms linked through...
    HP

    Global IT giant HP wanted to cut its computing expenses while still maintaining near-total uptime for its decision-support applications. To do this, the company needed a strategy to standardize critical applications enterprise-wide and consolidate all of its data centers around the world into three sites in the southern US.

    Global IT giant HP wanted to cut its computing expenses while still...
  • Henry Schein

    Following several acquisitions, the company needed to integrate a broad range of data from multiple business units, each using their own technology platforms.

    Following several acquisitions, the company needed to integrate...
    Central Bank of Brazil

    To facilitate its oversight of Brazil's economy, the Central Bank needed to update and streamline its management processes.

    To facilitate its oversight of Brazil's economy, the Central Bank needed to...
  • Qualcomm

    Succeeding in this fast-moving market requires a seamless, holistic view of 14 business units around the globe — and that demands rigorous data integration from multiple sources.

    Succeeding in this fast-moving market requires a seamless, holistic view of...
    Responsys
  • Dana-Farber Cancer Institute

    The institute need a way to integrate vast volumes of different types of clinical and financial data into a format that’s more valuable for end users.

    The institute need a way to integrate vast volumes...
    HealthNow

    HealthNow New York looked to implement a unified data integration environment that would support its huge range of data integration use cases and service oriented architecture (SOA) strategy.

    HealthNow New York looked to implement a unified data integration environment that...
  • Highmark

    Highmark needed to consolidate and modernize its information systems, including several data warehouses it inherited from prior mergers and acquisitions.

    Highmark needed to consolidate and modernize its information...
    vente-privée.com

    With 6.5 million members in five European countries, the company must be able to track demand, inventory levels, turnover, and profit margins both in real time and over longer periods.

    With 6.5 million members in five European countries, the company must be...
  • Samsung Life Insurance

    When ongoing growth spurred the company to upgrade from a legacy mainframe to UNIX Oracle databases, Samsung Life needed a way to migrate enormous amounts of critical data quickly, reliably, and safely.

    When ongoing growth spurred the company...
    Westpac Life New Zealand

    Westpac created a project to establish a single source of the truth for insurance and business performance.

    Westpac created a project to establish...
  • U.S. Xpress Enterprise. Inc.

    High quality data on thousands of trucks enabled U.S. Xpress to dramatically cut gas costs and truck idle time to become greener.

    High quality data on thousands of trucks enabled...
    Aircelle

    To replace legacy systems from its seven locations in France, England, and Morocco with a single new SAP system, it needed to safeguard its business and technical data while still remaining on a tight timeline.

    To replace legacy systems from its seven...
  • Frost Bank

    Recently ranked number one in Texas for customer loyalty and satisfaction by J.D. Power, Frost Bank is a leading provider of banking, investment and insurance services in Texas.

    Recently ranked number one in Texas for customer loyalty and satisfaction...
    Con-way Freight Con-way Freight Leverages Informatica, MicroStrategy and Netezza to Create High-Efficiency Business Intelligence Solution Con-way Freight Leverages Informatica, MicroStrategy and Netezza to Create...
  • King Faisal Specialist Hospital and Research Center Informatica Platform transforms one of the premier hospitals in the Kingdom of Saudi Arabia into a more effective, knowledge-based healthcare organization; delivers real, lasting return on data. Informatica Platform transforms one of the premier hospitals in the Kingdom of Saudi Arabia... Ochsner Health System

    Southeast Louisiana’s largest healthcare delivery system standardizes on Informatica technologies to streamline patient care, improve patient outcomes, and increase the value of data at lower cost

    Southeast Louisiana’s largest healthcare delivery system standardizes on...
  • Grant Thornton

    Capitalizing on the reuse and real-time change data capture capabilities of the Informatica Platform, Grant Thornton has cut its data integration development and maintenance lifecycle in half. Real-time Web services can also now be launched quickly, easily, and at minimal risk.

    Capitalizing on the reuse and real-time change data capture capabilities...
Get DI PowerCenter
Certified