GeeKs Blogging @ dotCOM

Let's share…
  • Home
  • About
  • Contribute
  • How To – FAQs
  • Disclaimer
  • Terms & Conditions
9 Jun 2009

Siebel EIM – Custom table mapping

by brijesh


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...

Tags: Customization, EIM, Siebel, Tutorials



For regular updates, enter your email address below. We don't spam, we don't share with others!




This entry was posted on Tuesday, June 9th, 2009 at 11:15 AM and is filed under Siebel CRM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Siebel EIM – Custom table mapping”

  1. Yogesh says:
    February 24, 2010 at 12:45 PM

    Hey Brijesh
    How r you…
    I have a question do we have an option of mapping a single CUSTOM COLUMN rather than running the wizard for all existing CUSTOM COLUMN.

  2. Thota says:
    June 28, 2010 at 10:19 PM

    Hi,

    In EIM, one Base Table can be loaded with Multiple EIM Tables and one EIM table can be loaded with Mutiple base tables

    what is the criteria to select best EIM Table or Base Table in this case

    Thank You

Leave a Reply

Click here to cancel reply.


« Siebel – EAI Siebel Adapter Search Spec
Siebel Recruitment – Birlasoft »



  • Admin Controls

    • Log in
  • Talk to us

    • Bouquets, brickbats, suggestions, complaints?

    • Click here...
  • Authorships

    • We are currently looking out for active authors. Are you willing to contribute?

    • Please click here

    • Everyone's invited..
  • Subscribe by Email


    • For regular updates, enter your email address below. We don't spam, we don't share with others!

  • Sponsors

  • Subscribe

    • Entries (RSS)
    • Comments (RSS)
  • Siebel Bookshelf

  • Daily Dilbert

    •          
  • Categories

    • Admin Notifications (9)
    • Business Intelligence (2)
      • Actuate (2)
    • CRM (115)
      • CRM News (6)
      • Sage Software / ACT! (1)
      • Salesforce.com (2)
      • Siebel CRM (103)
    • EAI (2)
    • Events (1)
    • FUN 'n' FROLIC (6)
    • Hot Technologies (7)
    • IT News (47)
    • Meet the Author (9)
    • ORACLE (14)
      • Database (2)
      • Oracle Fusion Applications Stack (8)
    • Product Demostrations (5)
    • Uncategorized (4)
  • Tag Cloud

    Admin Admin Notifications Applet Author Introductions Business Component Calculated Function Certification CFG file Client Configuration Critique CRM Database Debugging EAI EIM eScript Fundamentals Fusion Middleware Google IT News License Login Microsoft ORACLE Oracle Fusion Applications Performance problems Product Defect Product Demostrations Salesforce Scriptless solutions Security Server Siebel Siebel Secrets SOA Tips Tools Tricks Tutorials Upgrade User Property Workarounds workflows



  • Archives

    • August 2011
    • July 2011
    • June 2011
    • May 2011
    • April 2011
    • November 2010
    • August 2010
    • May 2010
    • April 2010
    • March 2010
    • February 2010
    • January 2010
    • December 2009
    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • July 2009
    • June 2009
    • May 2009
    • April 2009
    • March 2009
  • Authors

    • Ankit Bhardwaj
    • Ashish Kaul
    • brijesh
    • Himanshu Bajpai
    • Madhvi Arora
    • nanpats
    • Nitin Jain
    • Prachi Sharma
    • Renuka Ankam
    • Vikas Luthra
  • Administrators

    • geeksblogging@gmail.com
    • admin@geeksbloggingat.com
  • Sponsors

Fresh Ideas

  • Login Failed in Dedicated Web Client : MVF Issue
  • Oracle Fusion Applications price list
  • Research to Development - Fusion Apps Series
  • Oracle ACE Program
  • HCM user Experience through UI - Fusion Apps series
  • "Managing Oracle Fusion Applications"
  • Microsoft *previews* Windows 8 - Part 2 now available !!
  • Let's upgrade Siebel CRM to Fusion Apps "right now" !!
  • Ness Technologies bought out by Citigroup Unit
  • Oracle #1 CRM Applications vendor ??

Just Said

  • Amit Sharma on Siebel – Installer hangs midway
  • Khadijah Mosinski on Salesforce.com not upto the mark?
  • Hamre319 on Highrise Customer Relationship Management
  • Nitin Jain on “Managing Oracle Fusion Applications”
  • zama racha on “Managing Oracle Fusion Applications”
  • Nishant Aggarwal on Siebel – License keys don’t work / are invalid
  • Nitin Jain on Siebel – SIA BC Utility Service – Invoke BC Method
  • Pedro Garcia on Siebel – SIA BC Utility Service – Invoke BC Method
  • Nitin Jain on “Managing Oracle Fusion Applications”
  • Nitin Jain on Microsoft *previews* Windows 8 – Part 2 now available !!

Most Commented

  • Siebel - SIA BC Utility Service - Loop multiple records
  • Siebel - Installer hangs midway
  • Siebel - Adding License Keys to Sample
  • Siebel - Popup Update Only
  • Siebel - Reading data directly from Siebel SRF
  • Siebel - Automatic User Logout
  • Siebel - EAI Queue - Usage
  • Siebel - Looping multiple records - Update records
  • Siebel - SIS OM PMT Service
  • Siebel Tools hangs when checking out objects

Old Favourites

  • Highrise Customer Relationship Management
  • Siebel - Autosave Opportunity data - Sample Code
  • Siebel - Autosave Opportunity data - The concept
  • Renuka Ankam
  • Siebel - Merge Records - Checklist
  • Siebel - Fetch Active view properties - III
  • Oracle 11g Certification coming soon
  • Siebel - Fetch Active view properties - II
  • Siebel - Fetch Active view properties
  • Siebel - Automating Merge Records by script - II

If you also want to write on GeeksBlogging@dotCOM, click here. Area of Specialization no constraint. Become Famous!


Entries (RSS) and Comments (RSS).