We have On Premise BizTalk 2013 and SharePoint 2013 Enterprise. I have a SQL 2012 table which gets an update from SharePoint 2013 external list using Business Connectivity Services (BCS). TransactionStatus is the column in SQL table which stores the Order Status values such as “Processing”, “On Hold”, “Initiated”, “Cancelled” and so on.
I have an XSD created within BizTalk Orchestration from this Stored Procedure. This stored procedure returns the value of Transaction status depending upon TranscationId. I would like to add a Decision Shape and a loop shape in BizTalk Orchestration which will loop till TransactionStatus has “Processing” as the value. Below is the logic I am trying to implement:
If TransactionStatus = Processing
{Continue Orchestration – Add sales information to Oracle table}
Else TransactionStatus Not Equal Processing
{Loop till Transaction Status = “Processing”}
Question is whether loop shape consumes lots of memory or slow things down or will that have minimal impact on entire BizTalk Orchestration