Sample
Document to Use OIC Lookup to pass the username and password from Lookup
Usecase
:
It is not advisable to pass the hardcoding , username and password in OIC integration.
Solution :
We need to pass these values need to pass these values
From lookups.
Benefit of passing the Values from lookup is that ,
if some value changes we
need not make changes to OIC code , we can just update
the lookup values.
And also of the OIC integration is migrated some other
instance or if the password we have to change ,
We only need to update the lookup.
Sample Lookup design in OIC >
Now to use this in OIC mapping , goto mapper
Ø Components
> Functions > Integratoin Cloud > Lookup Value > Drag and drop to
the Mapper
Now it will open a setup page
Select the Lookup Name
Select source and Target Columns.
Click Next ,and then next Done Close.
dvm:lookupValue('FUSION_DATA_SYNC', 'NAME',
srcValuePlaceHolder, 'VALUE', '')
Update srcvaluePlaceholder
with the username > “BI_USERNAME”
It should look as below
dvm:lookupValue ("FUSION_DATA_SYNC",
"NAME", "BI_USERNAME", "VALUE", "" )
Similar to pull password repeat the same step as
above.
dvm:lookupValue('FUSION_DATA_SYNC', 'NAME',
srcValuePlaceHolder, 'VALUE', '')
Update srcvaluePlaceholder
with the username > “BI_PASSWORD”
dvm:lookupValue ("FUSION_DATA_SYNC",
"NAME", "BI_PASSWORD", "VALUE", "" )
Now validate and Close the Mapper .
And Save the Integration.
Now when the Integration runs the username and
password will be pulled from lookups.
