PowerCenter - Source

Card Puncher Data Processing


A Source is :

  • a database objects (table, views, synonyms)
  • or files (xml, …)

that provide source data.

Powercenter Workflow Manager Connections

PowerCenter accesses the following sources:

  • Relational. Oracle, Sybase ASE, Informix, IBM DB2, Microsoft SQL Server, and Teradata.
  • File. Fixed and delimited flat file, COBOL file, XML file, and web log.
  • 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.

Source Qualifier

Every mapping requires at least one of the following source qualifiers that determines how the Integration Service reads the source data:

  • Source Qualifier transformation. Represents data read from relational and flat file sources.
  • Normalizer transformation. Represents data read from COBOL sources.
  • Application Source Qualifier transformation. Represents data read from application sources.
  • Application Multi-Group Source Qualifier transformation. Represents data read from multi-group application sources.
  • XML Source Qualifier transformation. Represents data read from XML sources.

Type of source


You can purchase additional PowerCenter Connect products to access business sources such as:

  • IBM MQSeries,
  • IBM DB2 OLAP Server,
  • JMS,
  • Microsoft Message Queue,
  • PeopleSoft,
  • SAP NetWeaver,
  • SAS,
  • Siebel,
  • TIBCO,
  • webMethods,

Discover More
Card Puncher Data Processing
PowerCenter - Application Source Qualifier Transformation

Application Source Qualifier is a transformation that represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a workflow.
Card Puncher Data Processing
PowerCenter - DataType (Conversion)

The Designer displays two types of datatypes: Native datatypes. Specific to the source and target databases, flat files, or ERP systems. Native datatypes appear in the Source Analyzer and Target Designer....
Powercenter Designer Tools
PowerCenter - Designer

The Designer has the following tools that you use to analyze sources, design target schemas, and build source-to-target mappings: . Import or create source definitions. . Import or create target definitions....
Powercenter Integration Service
PowerCenter - Integration Service

The PowerCenter Integration Service is an application service that runs workflows and sessions for the PowerCenter Client. The Integration Service reads workflow information from the repository. The...
Powercenter Mapping Pass Through
PowerCenter - Mapping

Mapping depict the flow of data between source and targets. A Pass-Through mapping inserts all the source rows into the target. To create and edit mappings, you use the Mapping Designer tool in the...
Powercenter Pre Session Variable Assignment
PowerCenter - Mapping (Parameter|Variable)

When you use a mapping parameter or variable in a mapping, first you declare the mapping parameter or variable for use in each mapplet or mapping. Then, you define a value for the mapping parameter or...
Card Puncher Data Processing
PowerCenter - Repository Objects

You create repository objects using the and client tools. You can also view the objects in the Navigator window of the . source definitions. Definitions of database objects (table, views, synonyms)...
Powercenter Workflow Sample
PowerCenter - Sessions

A session is a type of workflow task. A session is a set of instructions that tells the integration service how to move data from sources to targets using a mapping. You create a session for each mapping...
Powercenter Designer Tools
PowerCenter - Source Analyzer

PowerCenter Source Analyzer help to import or create definitions. It's a part of
Powercenter Mapping Pass Through
PowerCenter - The Source Qualifier transformation

Every mapping that need to read data from relational or flat file sources, includes a Source Qualifier transformation, representing all data read from the source andtemporarily stored by the integration...

Share this page:
Follow us:
Task Runner