Preface
Product Overview
Before You Begin
Tutorial Lesson 1
Tutorial Lesson 2
- Creating Source Definitions
  - Viewing Source Definitions
- Creating Target Definitions and Target Tables
  - Creating Target Definitions
  - Creating Target Tables
Tutorial Lesson 3
Tutorial Lesson 4
Tutorial Lesson 5
- Creating a Mapping with Fact and Dimension Tables
- Creating a Workflow
Tutorial Lesson 6
Naming Conventions
- Suggested Naming Conventions
  - Naming Convention
Glossary
- PowerCenter Glossary of Terms

Getting Started

10.4.0
- 10.5.1
- 10.5

Back Next

Sources

PowerCenter accesses the following sources:

Relational.
Oracle, Sybase ASE, Informix, IBM DB2, Microsoft SQL Server, SAP HANA, and Teradata.

File.
Fixed and delimited flat file, COBOL file, XML file, and web log.

Application.
You can purchase additional PowerExchange products to access business sources such as Hyperion Essbase, WebSphere MQ, IBM DB2 OLAP Server, JMS, Microsoft Message Queue, PeopleSoft, SAP NetWeaver, SAS, Siebel, TIBCO, and webMethods.

Mainframe.
You can purchase PowerExchange to access source data from mainframe databases such as Adabas, Datacom, IBM DB2 OS/390, IBM DB2 OS/400, IDMS, IDMS‑X, IMS, and VSAM.

Other.
Microsoft Excel, Microsoft Access, and external web services.

Introduction

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal