Siebel EIM – USING SYNONYMS
Performance is always a major issue in most of the Siebel Intallations. In a project where large scale EIM Processing is needed, rest assured, Performance would be the from amongst the most discussed topics, at least from the Acceptance Testing phase, if not before!
EIM Data loads can turn out to be for millions of records, and many tens of GBs of Data being imported is a common sight (talking in terms of the Oracle Database Data File footprint). The customer has to be around that size, if he is actually going in for a Siebel CRM implementation I guess!
Siebel EIM Career – A day in Life
Consider this article as a simple overview of Siebel EIM. We will cover how a typical day in the life of a Siebel EIM Developer is like.
Usage of Siebel EIM is guaranteed as soon as a Siebel project is to be implemented, in most cases. The only exceptions that I can think of are the Siebel Upgrade projects in some cases, or in case the client never had any information organizing of Contacts and Leads for this line of business before (Rare, and highly unlikely!!).
Siebel EIM – Custom table mapping
This article is similar to my previous article (Siebel EIM – Custom column mapping). As a feedback to it, associates asked as to how we can actually map an entire custom table itself, rather than only custom columns. Here are the simple steps:
1. In object explorer select “Table” and query for base as well as for corresponding EIM table. For example here I am taking example of CX_ACCOUNT and corresponding EIM table EIM_ACCOUNT. Lock both of them.
Siebel EIM – Nomenclature of Custom Column
Previous post regarding new custom columns mapping in EIM table seems very useful for Siebel developers. Especially, the ones that are planning a new move to this territory of Siebel. Brijesh has written it beautifully which you can read from the link below:
SIEBEL EIM – CUSTOM COLUMN MAPPING
I have also applied the same tips given in SIEBEL EIM – CUSTOM COLUMN MAPPING. In one of our implementations, we have number of custom columns in S_ORDER table and have the requirement to update two of the existing custom fields X_TEST_DUMMY_COLS_VALUE and X_TEST_VAL.
Siebel EIM – Custom column mapping
It’s a very basic concept explaining how we can generate EIM mapping for custom columns. You need to follow some steps as mention in the post below.
This topic was a Tutorial Request from one of the associates on GeeksBlogging@dotCOM. The associate had asked as to how do we map the custom columns created in the BC to the EIM tables.
1. In object explorer select “Table” and query for base as well as for corresponding EIM table. For example here I am taking example of S_ORG_EXT and corresponding EIM table EIM_ACCOUNT. Lock both these tables.
Siebel 7.x – Party Model Changes
After introduction of party model, the table structure (as far as EIM is concerned) have changed tremendously. The largest data model change involves the Party model, which I think is basis of post siebel 7 releases. Accounts, Organizations, Internal Divisions, Contacts, Employees, Positions, and Households are all party entities and are the logical extension table of S_PARTY and they all have the corresponding entry in S_PARTY base table and the data is brought into the business components through an implicit join (PLEASE NOTE THEY ARE NOT EXPLICIT JOINS).