PowerCenter can load data into the following targets:
Relational.
Oracle, Sybase ASE, Sybase IQ, Informix, IBM DB2, Microsoft SQL Server, SAP HANA, and Teradata.
File.
Fixed and delimited flat file and XML.
Application.
You can purchase additional PowerExchange products to load data into business sources such as Hyperion Essbase, WebSphere MQ, IBM DB2 OLAP Server, JMS, Microsoft Message Queue, PeopleSoft EPM, SAP NetWeaver, SAP NetWeaver BI, SAS, Siebel, TIBCO, and webMethods.
Mainframe.
You can purchase PowerExchange to load data into mainframe databases such as IBM DB2 for z/OS, IMS, and VSAM.
Other.
Microsoft Excel, Microsoft Access, and external web services.
You can load data into targets using ODBC or native drivers, FTP, or external loaders.
The targets mentioned is a non-exhaustive list. For more information about PowerCenter targets, see the