Skip to main content

Search:
Mega Dropdown Menu

Databases and Data Warehouses

PowerExchange delivers high-performance access to all major enterprise database systems and data warehousing environments.

Skip navigation links

Get Real-Time Access to Enterprise Data

Whenever you need to access data in any of your enterprise databases, or load data into data warehouses or data marts, turn to PowerExchange for reliability, maintainability, and high performance.

Coding custom database access logic requires domain expertise that can be both scarce and costly. Programming errors can damage database integrity and require disruptive recovery processes.

By eliminating the need for coding, PowerExchange can eliminate these errors, dramatically boosting productivity and speeding development time. As the need for changes arises, PowerExchange speeds development and deployment of these changes, and provides additional benefits in governance and risk management.

Available for most enterprise databases, the PowerExchange CDC Option provides your IT organization with up-to-the-second data and can reduce hardware and network utilization.

No matter where your data is located, PowerExchange accesses it through high-performance native interfaces. A common set of PowerExchange skills is used to access all databases, which helps reduce IT costs.

Whenever you need to access your enterprise databases you can rely on PowerExchange.

Supported Databases 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