2
Jun
2009
Siebel EIM – Custom column mapping
by brijeshIt’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.
2. Select S_ORG_EXT 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 it will be automatic taken care by EIM. Second select EIM table that you have locked. Here it is EIM_ACCOUNT.
4. Click next and verify table and column and click finish.
5. Unlock both these tables.
6. Check for you custom column mapping. EIM will generate mapping for all unmapped custom columns.
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.
Your entire table mapping is completed now enjoy with your custom column.
Related posts:
- Siebel EIM – Custom table mapping This article is similar to my previous article (Siebel EIM...
- Siebel EIM – Nomenclature of Custom Column Previous post regarding new custom columns mapping in EIM table...
- Query on the Long Column or Field A typical problem in any EAI project. Others too!! One...
- Siebel – Custom Applet Title There is an Applet title on the top of the...
- Siebel – Case Insensitivity (CIAI) Wizard CIAI stands for Case Insensitive and Accent Insensitive in Siebel....
- Siebel 7.x – Party Model Changes After introduction of party model, the table structure (as far...
- Siebel – Symbolic Strings – Usage Symbolic Strings appear directly in Siebel Tools’ Object Explorer, an...
Hi Brijesh,
Nice piece of info. I guess it would be better if you could extend this to include as to how do we map a new BASE TABLE itself to the EIM tables. Do we just go ahead and create a new EIM table itself?
[...] posts:Siebel EIM – Custom column mapping It’s a very basic concept explaining how we can generate…Siebel EIM – Nomenclature of [...]
I have about 5 or 6 simple configurations that my organization uses to import call lists in to Siebel, these configurations sometimes change slightly, but not very often. Ex. Org Name, Street Address, City, State, Postal Code, Main Phone Number, etc.
I have a .NET application that builds/supresses call lists from external spreadsheets and a reporting copy of our production database. The data in the resultant tables are tightly controlled and validated.
I want to create an SSIS package that uses .NET assemblies to programmatically populate EIM tables according to one of say 5 or 6 possible configurations and generate an email to the Siebel Administrator informing them that an EIM job is ready.
Has anyone had any experience with something similar? How do I populate an EIM table from another table in a different database?
Hi Aaron,
Create a DBLink, and using DBLink we can pull the Data from Different Database and populate into EIM Table