RKM Siebel EIM Oracle or the RKM Siebel EIM MSSQL:
USE_PROJECT: Set this option to YES to reverse-engineer projects as sub-models in Oracle Data Integrator.
REPOSITORY: Specify the Siebel Repository name. Default is Siebel Repository.
PROJECT_NAME: Specify the mask to filter the Siebel projects to reverse-engineer. For example: EIM Accounts and Quotes, EIM Activity, EIM A%. The percent sign (%) returns all Siebel projects.
Specify the reverse-engineering mask in the Mask field in order to select the tables to reverse. The Mask field, in the Reverse tab, filters reverse-engineered objects based on their name. The Mask field must not be empty and must contain at least the percentage symbol (%).
Click Apply, and then click Reverse.
You can follow the reverse-engineering process in the Execution Log.
Note: The reverse-engineering process may take several minutes or longer depending on the number of business object reverse-engineered.
At the end of the reverse-engineering, the applications and tables are represented as sub-models and datastores.
Features of the Reverse-Engineering
The RKM Siebel <database> process returns: The installed Business Objects as sub-models.
The Business Components as datastores with their columns and their constraints (Primary and Foreign Keys).
Comments on the reversed tables and columns. The RKM Siebel <database> EIM process returns: Projects as sub-models. EIM tables as datastores with their columns and their constraints (Primary and Foreign Keys).
Use Siebel as a Source in an Integration Interface
After performing a reverse-engineering using the RKM Siebel <database>, you can use Siebel data tables as a source for the integration interface.
Using Siebel as a source in these conditions is the same as using a standard Oracle or MSSQL database as a source in an interface. The Generic SQL, Oracle Database or Microsoft SQL Server KMs can be used for this purpose.
Use Siebel as a Source in an Integration Interface through EIM tables
To extract data from Siebel through the EIM tables, create an integration interface with EIM tables as a source. Select the LKM Siebel to SQL (EIM) and set the KM options as follows:
IFB_PATH: Specify the path where you want to create the EIM configuration file (.ifb). SRVRMGR_PATH: Specify the location of the Siebel srvrmgr binary. This parameter is mandatory. SIEBEL_GATEWAY: Specify the network address of the Gateway Server machine. SIEBEL_ENTERPRISE: Indicate the name of the Enterprise Server.
Knowledge Modules Reference Guide