Database Reference
In-Depth Information
Working with sources
Any file or table from where we can extract the data in PowerCenter is referred to as a
source. You can import or create the source definition.
Note
When you import the source definition in designer, we import only the metadata, that is,
column names, data type, size, indexes, constraints, dependencies, and so on. Actual data
never comes with the source structure in designer. The data flows through the mapping in a
row-wise manner when we execute the workflow in Workflow Manager.
PowerCenter allows you to work on various types of sources, as listed below:
•
Relational database
: PowerCenter supports relational databases such as Oracle,
Sybase, DB2, Microsoft SQL Server, SAP HANA, and Teradata
•
File
: Flat files (fixed width and delimited files), COBOL files, XML files, and Ex-
cel files
•
High-end applications
: PowerCenter also supports applications such as Hyperion,
PeopleSoft, TIBCO, WebSphere MQ, and so on
•
Mainframe
: Additional features of Mainframe such as IBM DB2 OS/390, IBM
DB2 OS/400, IDMS, IDMS-X, IMS, and VSAM can be purchased
•
Other
: PowerCenter also supports Microsoft Access and external web services
We have seen the components that PowerCenter supports. In the next section, we will learn
to import the relational database tables. Before that, a database connection needs to be ad-
ded to the designer screen as mentioned in the next section.
Adding a new ODBC data source
To add a new database data source connection to import tables, follow this procedure:
1. In the designer screen, navigate to
Tools
|
Source Analyzer
to open the Source
Analyzer tool, as indicated earlier.
2. Navigate to
Sources
|
Import from Database
.
3. To add a new database connection, click on the tab shown in the following screen-
shot:
