Sample Document to Use OIC Lookup to pass the username and password from Lookup

 

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.