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.
(4 votes, average: 3.25 out of 5)
Loading ...
12 Comments at "EAI Data Maps - making Siebel Integration simple"
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
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
This 2 level IO structure you can transfer into
Three level IO structure.
IOs must have ICs in this hierarchy to achieve this
Thanks Piyush
Would try this out [:)]!!
@Soj
If its possible for you to give me the IO hierarhcy I might be able to tell u the Datamapping if you wanna.
Thank u so much…but would like to try it out first…& if would face an issue..know you would be there to help me out..:)
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.
[...] Guys I am back with what I promised a while ago. If you have read my earlier post about EAI Data Maps you must remember that I promised to share objects like Data Map XML, BC sif and test [...]
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!!!
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.
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.
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
Comment Now!