Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Targets

Targets

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
PowerCenter documentation
at docs.informatica.com.

0 COMMENTS

We’d like to hear from you!