Hi all,

I have to write a translation rule in map where requirement is as : If the source element exists and contains a value then assign value as  "100" Else map "0".

Also have stored few constant values in SSO how to read a value from SSO DB in funtoid in map ?

http://www.codeproject.com/Tips/559597/How-to-store-BizTalk-configuration-in-the-SSO-data will help you create the .Net library that can access SSO key/values. You can then call the .Net library from your map for the purpose.

Regards.

Hi Nitin,

You can use  SSO Configuration Application MMC Snap-In from below location to store your Key ,value pair configuration details .

https://www.microsoft.com/en-us/download/details.aspx?id=14524

This tool is an MMC based utility that allows you to store name/value pairs in the the SSO configuration database.

The MMC Snap-In provides an easy to use interface that allows you to add and manage applications, add and manage key value pairs as well as importing and exporting (in an encrypted format) configuration applications so that they can be deployed to different environments.

You can use it for getting values inside your map through calling .net class .

Thanks

Abhishek

Hi Shankycheil....Thanks for 

Could you please tell me how to do following ?

if (If the source element exists and contains a value)
StatusCode = 100
StatusMessage = "FAILED"
else 
StatusCode = 0
StatusMessage = "SUCCESS"

Thanks,

Hi Shankycheil....Thanks for help...

Could you please tell me how to do following ?

if (If the source element exists and contains a value)
StatusCode = 100
StatusMessage = "FAILED"
else 
StatusCode = 0
StatusMessage = "SUCCESS"

Thanks,

Hi Nitin,

This a rule based decision which you need to make . I would suggest to create a policy for this and the you can create a .Net helper class to execute Business Rules and then use it's methods from your map via scripting functoid (external .Net assembly).

Thanks

Abhishek

to check for the existence of the element within a MAP you can use the "Logical Existence" functoid - https://msdn.microsoft.com/en-us/library/aa559386.aspx and then execute custom scripts where you can call the .Net methods to retrieve appropriate values from SSO.

Regards.

to check for the existence of the element within a MAP you can use the "Logical Existence" functoid - https://msdn.microsoft.com/en-us/library/aa559386.aspx and then execute custom scripts where you can call the .Net methods to retrieve appropriate values from SSO.

Regards.

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator 5 hours 23 minutes ago

to check for the existence of the element within a MAP you can use the "Logical Existence" functoid - https://msdn.microsoft.com/en-us/library/aa559386.aspx and then execute custom scripts where you can call the .Net methods to retrieve appropriate values from SSO.

Regards.

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Thursday, July 16, 2015 1:43 AM