GeeKs Blogging @ dotCOM

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.

2. Select CX_ACCOUNT and right click for “EIM Table Mapping…”

3. “Interface Table Mapping” window will open now you have choice of column prefix name that is optional, because EIM will automatic take care of such thing. Second select EIM table that you have locked. Here it is EIM_ACCOUNT.

4. Click next and verify table and column and click finish. And let the siebel tool to map custom table.

5. Unlock both these tables.

6. Check for you custom table mapping. EIM will generate mapping for all unmapped custom columns for that particular table.

7. Once this mapping is generated apply and activate the same on server or if you are working on local then do it at your local DB.

This is all what you need for a custom table mapping.

Note: I don’t think that EIM will be able to populate Foreign Keys. I haven’t tried this much, but please verify this as per your requirement. My guess is that it won’t populate.

Related posts:

1. Siebel EIM – Custom column mapping It’s a very basic concept explaining how we can generate...
2. Siebel EIM – Nomenclature of Custom Column Previous post regarding new custom columns mapping in EIM table...
3. Siebel – Custom Applet Title There is an Applet title on the top of the...
4. Siebel – Case Insensitivity (CIAI) Wizard CIAI stands for Case Insensitive and Accent Insensitive in Siebel....
5. Query on the Long Column or Field A typical problem in any EAI project. Others too!! One...
6. Siebel – Symbolic Strings – Usage Symbolic Strings appear directly in Siebel Tools’ Object Explorer, an...
7. Siebel – millisecond dates on Applet I had discussed in my previous posts about invoking a...