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. Naming Conventions
  11. Glossary

Getting Started

Getting Started

PowerCenter Source and Target

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

0 COMMENTS

We’d like to hear from you!