Getting Started

10.4.0
- 10.5.6
- 10.5.1
- 10.5

Back Next

PowerCenter Source and Target

In this tutorial, you create mappings to read data from relational tables, transform the data, and write the transformed data to relational tables. The PowerCenter Client uses ODBC drivers to connect to the relational tables.

You must have a relational database available and an ODBC data source to connect to the tables in the relational database. You can use separate ODBC data sources to connect to the source tables and target tables.

The following table can be used to record the information you need for the ODBC data sources:

ODBC Data Source Information	Source Connection	Target Connection
ODBC Data Source Name
Database User Name
Database Password

The following table can be used to record the information you need to create database connections in the Workflow Manager:

Workflow Manager Connectivity Information	Source Connection Object	Target Connection Object
Database Type
User Name
Password
Connect String
Code Page
Database Name
Server Name
Domain Name
You may not need all properties in this table.

The following table lists the native connect string syntax to use for different databases:

Database	Native Connect String	Example
IBM DB2	dbname	mydatabase
Microsoft SQL Server	servername @dbname	sqlserver@mydatabase
Oracle	dbname .world (same as TNSNAMES entry)	oracle.world
Sybase ASE	servername @dbname	sambrown@mydatabase
Teradata	Teradata* ODBC_data_source_name or ODBC_data_source_name@db_name or ODBC_data_source_name@db_user_name	TeradataODBC TeradataODBC@mydatabase TeradataODBC@sambrown

Rename Saved Search

Table of Contents

Getting Started

Getting Started

PowerCenter Source and Target

PowerCenter Source and Target