EAI Data Maps – making Siebel Integration simple

When I first read about EAI data maps I didn’t thought they were of much use. That could probably be because of the fact that the integration in which I was involved requirement was quite complex hence couldn’t be fulfilled with the help of data maps.

But recently I was working on an EAI requirement that required major time transformation of XML between what Siebel could generate and what was required by the external system.

So, my obvious first choice was to look for Scripting alternative but the format was so different that it would require a very complex script to achieve that and eventually it will lead to hard coding of tag names which was not at all desirable.

So, I started looking towards EAI data Maps to see if they could help me, and boy did they help me. Using data maps helped me to remove major coding that was to be done and in the end instead of writing 3000 lines of complex code I was able to achieve the desired format with just 10 lines of code.

EAI data maps are available in Administration Integration –> Data Map Editor

Data Map basically are a declarative way to describe a transformation.

In an integration we have an usually have

  • Internal IO based on Siebel business object which represents the Siebel Data in XML format
  • External IO based on XML which represents XML format for external application.

We can use DTE Scripts or EAI Data Maps to achieve the transformation required, if any.

Screenshot for EAI Data Maps is shown below

As you can see from the screenshot you map

  • Integration Object (IO) – Integration Object (IO)
  • Integration Component (IC) – Integration Component (IC)
  • Fields – Fields

Source is Internal IO (Base Type as Siebel Base Object) and Destination is External IO (Base Type as XML)

The advantage of data map is that you can map one IC with multiple IC’s. This is what helped me to achieve a requirement and also the level doesn’t matter.

In my next post I will be discussing about a real case study involving data maps and will share the objects like IO, Datamaps and workflows that I created for that purpose.

34 Responses to EAI Data Maps – making Siebel Integration simple

  1. When you have mapped the same IC to multiple IC of External IO.Does that mean we are fetching the whole content via a single IC & that is segregated ito two sections of Nodes in the XML of External IO.

    Really quite intresting…

    from the scenario that you have explained..just thought of a case…where in we are only passing an Oppor Id from External IO to Internal IO. & When it fetch the data it should hold all the data with regards to that Oppor…is it possible to achieve via datamaps.??..& in that case would the structure of XML can be changed when it is processed between Internal & external IO’s…i mean input was two tagged XML & output was 5 tagged XML?? can this be achieved via datamap.

    Regards
    Soj

  2. When you have mapped the same IC to multiple IC of External IO.Does that mean we are fetching the whole content via a single IC & that is segregated ito two sections of Nodes in the XML of External IO.

    Really quite intresting…

    from the scenario that you have explained..just thought of a case…where in we are only passing an Oppor Id from External IO to Internal IO. & When it fetch the data it should hold all the data with regards to that Oppor…is it possible to achieve via datamaps.??..& in that case would the structure of XML can be changed when it is processed between Internal & external IO’s…i mean input was two tagged XML & output was 5 tagged XML?? can this be achieved via datamap.

    Regards
    Soj

  3. Hi Soj,

    yes, this functionality can be achieved using datamaps.

    In Datamppers structure of XML depends upon the External and Internal IOs

    e.g. My External IO is have 2 level hierarchy of XML but I want to ahve a 3 level hierarchy of XML in my Internal IO in case of getting data from external system. In this case datamppepr is best used.

    let’s say External Io is like
    ABC

  4. Hi Soj,

    yes, this functionality can be achieved using datamaps.

    In Datamppers structure of XML depends upon the External and Internal IOs

    e.g. My External IO is have 2 level hierarchy of XML but I want to ahve a 3 level hierarchy of XML in my Internal IO in case of getting data from external system. In this case datamppepr is best used.

    let’s say External Io is like
    ABC

  5. Piyush…need your help..

    I’ve built a IO for loading Attribute definition onto Siebel.It can be used to do fetch.However on doing an Insert it keeps on failing.I’ve validated the Datamap implemented,for which I got a succeded response.However I’m unable to do an insertion..Can u help me with that pl.

  6. Piyush…need your help..

    I’ve built a IO for loading Attribute definition onto Siebel.It can be used to do fetch.However on doing an Insert it keeps on failing.I’ve validated the Datamap implemented,for which I got a succeded response.However I’m unable to do an insertion..Can u help me with that pl.

  7. i am trying to call a web service in asp.net from a siebel application by passing an XML between siebel and .net webservice. i have even identified the mapping between the fields in the respective BC and fields in HTML but the web service is not getting invoked!!!

  8. i am trying to call a web service in asp.net from a siebel application by passing an XML between siebel and .net webservice. i have even identified the mapping between the fields in the respective BC and fields in HTML but the web service is not getting invoked!!!

  9. Could you please test the web service using some XML Editors like XML Spy or Oxygen and try to hit the URL and see if you are getting any response form .net application or not.

  10. Could you please test the web service using some XML Editors like XML Spy or Oxygen and try to hit the URL and see if you are getting any response form .net application or not.

  11. Hi
    Here I have a small doubt, in the above you explained we can map one IC to multiple IC’s from different IOs. How does it refers to the diffferent ICs of another IO, which we are not mentined at the IO Map.

  12. Hi
    Here I have a small doubt, in the above you explained we can map one IC to multiple IC’s from different IOs. How does it refers to the diffferent ICs of another IO, which we are not mentined at the IO Map.

  13. Hi Neel,

    Some one in the past has mentioned that you could use data maps and integration components to perform some complex funtionality within siebel which does not involve EAI. Both the ICs are based out of internal BCs. This is especially usful in inserting multiple records at the same time from 1 bc to another.

    Did you ever try this? If so can you give me more details on this?

    Thanks
    Sirisha

  14. Hi Neel,

    Some one in the past has mentioned that you could use data maps and integration components to perform some complex funtionality within siebel which does not involve EAI. Both the ICs are based out of internal BCs. This is especially usful in inserting multiple records at the same time from 1 bc to another.

    Did you ever try this? If so can you give me more details on this?

    Thanks
    Sirisha

  15. Hi all,

    Could you please explain about

    differnce between the internal Integration Object and External Integration Object. Please give some relevant points.

    Regards,
    Lakshmi

  16. Hi all,

    Could you please explain about

    differnce between the internal Integration Object and External Integration Object. Please give some relevant points.

    Regards,
    Lakshmi

  17. internal Integration Object are called as siebel objects and are nothing but Integration objects which are based on BO’s and external objects are XML’s which we receive from external system.External integration objects are created based on XML structure.

  18. internal Integration Object are called as siebel objects and are nothing but Integration objects which are based on BO’s and external objects are XML’s which we receive from external system.External integration objects are created based on XML structure.

  19. G’day EAI gurus –
    Fresher in the Web Service space – have a naive question to ask:
    1 – When creating / deploying inbound web services, is it essential to create EAI Data Maps? (assuming, we are using a middleware, such as TIBCO) . When MUST they be used? and if we are using them, do we need to use EAI Data trnasformation BS to have Data maps come into play?

    • It is not essentials to create data maps but desirable.

      They can be used if the structure is not greatly different from what you get in Siebel.
      Rule of the thumb is to use data maps if you have one-2-one mappings between source and target structure

      I don’t remember the exact name of the BS used for data maps but I think it is EAI Data transformation BS.
      You give siebel message and the map name as input and you get transformed structure as output.

  20. Hi Piyush,

    I have come across a scenario, where i am using Datamap for mapping external IO to Internal IO. My query is , Is it possible to map multiple ICs (from external IO) to same IC(Internal IO)?

    Thanks,
    Vineesh

  21. Hi all, I want some information regarding Twitter Integration in Siebel “LOY Member List Applet” for getting Loyalty Member’s tweets from their Twitter account, can anyone please ellaborate if have done this integration.

  22. Hi Everyone

    EM using data maps for a certain Workflow where em querying and then Updating the records but now I wanna concatenate that specific record and insert into a new field , Is it necessary to include this into DATA MAPPING ?

Leave a Reply

Contribute