X hits on this document

399 views

0 shares

1 downloads

0 comments

86 / 131

Installation and Configuration

If using the EIM KMS, it is required that the Siebel Srvrmgr Siebel utility is installed on the machine hosting the run-time Agent.

Working with the Siebel KMs Defining the Topology

The steps to create the topology in Oracle Data Integrator, which are specific to projects using Siebel KMs, are the following:

  • 1.

    Connect to your master repository using Topology Manager.

  • 2.

    Create a data server, based on the Oracle or Microsoft SQL Server technology (depending on the technology of the database), pointing to the instance that contains the Siebel data.

  • 3.

    Create a physical schema under this data server. This schema must point to the Oracle schema or Microsoft SQL Server database that contains the Siebel tables or EIM data structures you want to reverse-engineer.

  • 4.

    Create a logical schema for this physical schema in the appropriate context.

For more information on creating these elements in Topology Manager, please refer to the Oracle Data Integrator User’s Guide.

Warning! The Oracle schema or Microsoft SQL Server database containing the Siebel tables should not be defined as a work schema in the physical schema definition. Moreover, this schema/database must not be used as staging area for an integration interface.

Setting up the Project

Depending on the technology of the database that you will be using in your project, import the following KMs into your Oracle Data Integrator project, if they are not already in your project:

RKM Siebel <database> or RKM Siebel EIM <database> KM LKM Siebel to SQL (EIM) IKM SQL to Siebel Append (EIM)

Siebel Reverse-Engineering

To perform a Siebel Reverse-Engineering:

  • 1.

    Create a model based on the Oracle or Microsoft SQL Server technology and on the logical schema created when defining the Topology.

  • 2.

    In this Model, select the Reverse tab:

    • 1.

      Select Customized, and select, depending on the integration method you want use, the RKM Siebel <database> or RKM Siebel EIM <database> KM.

    • 2.

      Configure the RKM options as follows when using the

      • a.

        RKM Siebel to Oracle or the RKM Siebel MSSQL: Business Object: Specify the mask to filter the Business Objects to reverse-engineer. For example: Account, Acc%, Customer, Employee, %mpl%. The percent sign (%) returns all Business Objects.

Knowledge Modules Reference Guide

86/131

Document info
Document views399
Page views402
Page last viewedThu Dec 08 12:52:34 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments