SQL query to fetch EDI party info RRS feed

  • Question

  • Hi Experts,

    I want the below information for all the parties there in BizTalk:

    Agreement Name  SenderParty    SenderQualifier     Value   ReceiverParty    ReceiverQualifier     Value  

    I tried a lot to fetch through the SQL query , but not able to fetch it properly.

    Could anyone please help me out with SQL query which can be used to get the above info from BizTalk DB?

    Thanks for help in advance.

    Wednesday, January 24, 2018 6:54 AM

All replies

  • As far as I know, there is not one table in the BizTalkMgmtDb that gives you all that info at once for the EDI agreements, it is all in different tables that use one another as "translation source".

    You can find most of the info in the table tpm.Agreement, and combined with the info in tpm.Partner you will have it.

    Wednesday, January 24, 2018 12:49 PM