Why do users need to populate PARTY_UID in the S_PARTY base table while using Enterprise Integration Manager

PARTY_UID requires users to populate it with a unique value. The PARTY_UID column is used by several users to store a unique legacy system identifier.
The following are benefits to this approach:

a) Allows updating information that tends to change (Name for example)
 

b) Allows greater control of the data manipulation (loading, updating, exporting etc) processes in an automated fashion.

 

What is the difference between the S_REVN table and the S_OPTY_POSTN table

S_REVN table was introduced in Siebel version 7.0 which is used to store Revenue data. For example Revenue by an employee on an Opportunity, an Agreement, a Service Request, etc.

S_REVN table replaces S_OPTY_PROD and S_OPTY_POSTN table in Siebel version 6.0.

As of Siebel version 7.0, S_OPTY_PROD is obsolete and S_OPTY_POSTN is no longer used to store revenue records.

How can users define multiple Extended Parameters values when running Enterprise Integration Manager (EIM) from the command prompt in a batch file

To define multiple Extended Parameters values, use a backslash before quote. Reference the example to see how to use this feature:

i:\sbsrvr\bin\srvrmgr.exe /g gateway /e entServer /s SIEBDEVSRVR /u sadmin /p passwd /c "START TASK FOR COMPONENT EIM WITH CONFIG=htcontacts_tpl2.ifb, ExtendedParams=\"BatchNum1=200001,BatchNum2=200002-200003\", CONNECT=SiebSrvr_CRMSIEBDEV, ERRORFLAGS=1, TRACEFLAGS=0, SQLFLAGS=0"

How are index hints used in an EIM process

Enterprise Integration Manager (EIM) interacts with data objects (tables and columns) via SQL statements. How those queries are executed by the database in use is directly related to the EIM performance. Since optimization modes used by Siebel application differ among database platforms, index hints usages by EIM are different.

There are two EIM parameters related to index hints:

 USE ESSENTIAL INDEX HINTS (TRUE by default)
USE INDEX HINTS (FALSE by default)

How should EXPORT MATCHES and DELETE MATCHES be used in Siebel?

The syntax of EXPORT MATCHES and DELETE MATCHES has been changed in version 7.x./8.x This information was not available in the Siebel Bookshelf.

The following are the correct syntax for the EXPORT MATCHES and DELETE MATCHES parameters:

 

If the interface table's target table is not S_PARTY:

- It allows syntax of:

How can users generate an Enterprise Integration Manager Log file in Siebel

In Siebel application, follow the steps below to generate an Enterprise Integration Manager (EIM) detailed log file:

1. From User Interface, navigate to View > Site Map > Server Administration > Components


2. Select Enterprise Integration Manager as the component and choose the tab 'Component Event Configuration'.
 

3. Find the following 'Event Type':

SQL Tracing
SQL Summary
Task Configuration
Component Tracing.

Recent content