locked
Translation Rule in Map RRS feed

  • Question


  • 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 ?

    Thanks,

    Thanks and Regards, Nitin.

    Thursday, July 9, 2015 3:28 AM

Answers

All replies

  • 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.

    Thursday, July 9, 2015 4:21 AM
  • 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

    Thursday, July 9, 2015 5:20 AM
  • 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,



    Thanks and Regards, Nitin.

    Thursday, July 9, 2015 5:33 AM

  • 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,


    Thanks and Regards, Nitin.

    Thursday, July 9, 2015 5:34 AM
  • 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

    Thursday, July 9, 2015 5:39 AM
  • 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 Xu Thursday, July 16, 2015 1:43 AM
    Thursday, July 9, 2015 6:37 AM