Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Installing the Siebel Customer-Centric Enterprise Warehouse Environment > Process of Defining Your Installation Configuration >

Determining Source Requirements


This task is a step in the Process of Defining Your Installation Configuration.

Some source systems and database platforms require additional steps, as detailed in this section. To install PowerConnect for specific source systems, see the relevant PowerConnect User and Administrator Guide.

NOTE:  This section applies to customers using universal business adapters or SAP R/3.

Using the Universal Business Adapter

For source systems without prepackaged business adapters, you must provide flat file extracts. The flat files must conform to a template (located in the directory $Siebel\ETL\SrcFiles). Siebel Customer-Centric Enterprise Warehouse use the Universal Interface document to process and load the data into the data warehouse.

Using the SAP R/3 Source System

This section describes how to customize your Siebel Customer-Centric Enterprise Warehouse environment for a SAP R/3 source system.

Creating a Profile

The SAP R/3 administrator must create a profile in the R/3 system that allows you to use the integration features. This profile must include authorization for the objects and related activities listed in Table 6.

Table 6. SAP R/3 Integration Features
Integration Feature
Authorization Object
Activity

Import definitions, install programs

[S_DEVELOP]

All activities

Also must set Development Object ID to PROG

Extract data

[S_TABU_DIS]

READ

Run file mode sessions

[S_DATASET]

WRITE

Submit background job

[S_PROGRAM]

BTCSUBMIT, SUBMIT

Release background job

[S_BTCH_JOB]

DELE, LIST, PLAN, SHOW

Also must set Job Operation to RELE

Run stream mode sessions

[S_CPIC]

All activities

Generating ABAP Code

If you are extracting from SAP R/3, you must generate the ABAP code from the extract mappings. The mappings used to extract data from SAP R/3 all follow this naming convention, M_S_*_EXTRACT. For the mappings whose names fall into this category, you generate the ABAP codes. For more information on generating the ABAP codes, see the PowerConnect for SAP R/3 User and Administrator Guide.

Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide