Overview
PowerCenter can load data to base tables in Siebel using Enterprise Integration Manager (EIM) tables. Siebel EIM tables, also known as interface tables, are database tables that reside in a relational database. They act as staging areas between PowerCenter and base tables in the Siebel database. You use the Siebel Enterprise Integration Manager to load data from the EIM tables to the Siebel database.
You can use PowerCenter to load data to Siebel targets for data migration and bulk loading.
To load data to Siebel base tables, complete the following steps:
- Create target definitions.
- Create a mapping.
- Create and run a workflow.
- Load data to base tables in the Siebel database with the Siebel Enterprise Integration Manager.
To load data to EIM tables, you must have insert, update, and delete permissions.
Step 1. Create Target Definitions
Import EIM tables to PowerCenter as target definitions. There are multiple interface tables for different functional areas that you can load data to. See your Siebel documentation to find out what type of EIM tables you should load data to.
To import EIM table metadata into PowerCenter:
- In the Warehouse Designer, choose Targets-Import from Database.
- In the Import Tables dialog box, select the ODBC data source from the drop-down list that contains the EIM table definitions that you want to import to PowerCenter.
If you do not have a data source that contains EIM table definitions, you must create an appropriate data source. For information about creating ODBC data sources, see the PowerCenter Installation and Configuration Guide.
- Enter the user name and password needed to open a connection to the database, and then click Connect.
- Drill down through the list of database objects to view the available tables you can use as targets.
- Select the EIM tables you will use as target definitions, and then click OK.
- Choose Repository-Save.
Figure 1 shows the dialog box for importing EIM table definitions:
Figure 1. Import Tables Dialog Box
Step 2. Create a Mapping
After you create target definitions for the EIM tables, add the target definitions to a mapping. Because there are separate EIM table types for different functional areas, your mapping may contain more than one target definition. See your Siebel documentation to find out what type of EIM tables you should load the data to.
Figure 2 shows a sample mapping used to write metadata to EIM tables. It contains a source table that was imported from Siebel, a Source Qualifier transformation, and an EIM table. The EIM table will serve as the staging area between PowerCenter and the base tables in Siebel.
Figure 2. Sample Mapping
Step 3. Create and Run a Workflow
You must create a session and workflow to run the mapping. Configure the session properties to include the connection information necessary to load the data to a Siebel system database. When you run the workflow, the PowerCenter Server loads data to the EIM tables.
Figure 3 shows a sample of the connection information you configure in the session properties:
Figure 3. Mapping Tab in the Session Properties
Run the workflow. Once the workflow completes successfully, you can load the data from the EIM tables to the Siebel base tables.
4. Run the Enterprise Integration Manager
In Siebel, run the Enterprise Integration Manager. The Enterprise Integration Manager takes the data from the staging area and populates base tables in Siebel. For more information about using the Enterprise Integration Manager, see your Siebel documentation.