We use lookups in the integrations to create reusable tables that
map the different terms used to describe the same item across your
applications. Lookups are exact same as Data
Value Map(DVM) in SOA.
map the different terms used to describe the same item across your
applications. Lookups are exact same as Data
Value Map(DVM) in SOA.
Lets see how to define a Lookup in OIC with an example :
Use Case :-
Inside this blog, we see will define a lookup for Country Code & Country Name. For a specific Country Code we will assign one unique Country Name.
|
Country_Code
|
Country_Name
|
|
USA
|
United States of America
|
|
IS
|
Israel
|
development Steps in detail :
– Advertisement –
STEP 1 : Click at Lookups present inside Designer tab and then click CREATE
Enter the below details and click CREATE :
*Lookup Name : CountryLookup ( you can write any meaning full name)
Description : write small description
STEP 2 : Click on Domain_Name_1 and then click Edit Domain Name
and enter the below detail and click Ok
*Domain Name : Country_Code
– Advertisement –
STEP 3 : Similarly click Domain_Name_2 and then click Edit Domain Name
and enter the below detail and click Ok
*Domain Name : Country_Name
STEP 4 : Now add the values in lookup table. Click the “+” icon and add the
below values (as shown in below image)
In Country_Code column write IN & in Country_Name write INDIA
Similarly add two more values (as shown in below image )
Country_Code Column : add USA , IS
Country_Name Column : add UNITED STATES of AMERICA , ISRAEL
After adding above two values click Save and then click Close.
– Advertisement –
STEP 5 : Your Lookups is ready to use in Integration. Please access the Next
blog to know how to implement this Lookups in an Integration.
Thanks Amit 🙂
How can I use the lookup table so I could fetch a different adaptor based on a given input value?
Interested
I would glance at usage in addition to configuration of lookup
What is the function of "Replace with Adapter" option in the Domain_Name drop down selection?
Thanks Aarav 🙂
Already have mentioned the Link (in step-5) to check usages of lookups. Please cross read the blog properly ..
Thanks Kabir for this good article. It is helpful!
Thanks Sekhar!
What is the use of "Replace with Adapter" option in the Domain_Name drop down selection?
can't explain it here 🙂 please check oracle document