PowerExchange for Siebel User Guide for PowerCenter

10.5.5
- 10.5.4
- 10.2

Back Next

Siebel Source Definitions

When you connect to Siebel, the wizard lists a hierarchy of business objects and business components.

When you import a Siebel source definition, you import fields of a Siebel business component. In addition to importing predefined active fields of a Siebel business component, you can import the following types of special fields:

System field. A system field is a standard Siebel field for a business component that represents the data from the system columns.

Custom field. A custom field is a field that you can create to extract data from a field that exists in the Siebel business component.

Calculated field. A calculated field is a Siebel field that derives its value from a calculated expression. You import Siebel calculated fields as custom fields.

Formatted field. A formatted field is a field that you can create and use to extract data in the configured format. When you import a Siebel business component as a source definition, you can select the formatted fields and the PowerCenter Integration Service can read data of the formatted fields in the configured format. When you configure any field to retrieve data in a specific format, the datatype for the field changes to DTYPE_TEXT in the Siebel source definition.

The following table describes the details imported by the Designer when you import a business component as a source definition:

Source Definition Field	Description
Source Table	Business component name.
Column Name	The Designer displays the following attributes for each field: Field Name Datatype Length/Precision Scale Calculated Multi-value Multi-value link Comments

Rename Saved Search

Table of Contents

PowerExchange for Siebel User Guide for PowerCenter

PowerExchange for Siebel User Guide for PowerCenter

Siebel Source Definitions

Siebel Source Definitions