Creating BizTalk map with multiple input schema
Is there anyway to create a BizTalk map with multiple input schema "from scratch" ? i.e. not creating an orchestration and a transform shape and selecting multiple messages in the Source ...
biztalk
Cumulative Maximum, calculate for every parent record
Have anyone used the Cumulative Maximum functoid and noticed performance problems? Abstract If one wants to map the maximum value of a field you can use the functoid Cumulative Maximum. Problem After we had used it for a while we noticed degraded performance on larger files. Examining the xslt one notices that the max calculation is m...
BizTalk scope "Catch Exception" General Exception message
I have a BizTalk (2006 R2) scope with a "Catch Exception" part in which I have put a simple Expression shape to store the exception message in an orchestration variable. The problem is that if I choose the exception type to be "General Exception" the I do not get to supply an exception object name. Where do I retrieve exception info in ...
Excluding the first instance of an unbounded element in a BizTak map
I have a schema that is the souce with an element that is unbounded. I have a similar element on the destination schema that is also unbounded. I'm trying to figure out how in the map I can ignore the first instance in the source map? ...
Biztalk Database Lookup functoid and Value Extractor no match
I have an element in the source schema of a map that contains a code. I am using this as an input to a database lookup functoid. The output of the database lookup functoid is being passed as an input parameter to a value extractor functoid, which is outputting a column value. So far so good all as expected. My question is how do I handl...
Consuming web service from BizTalk with authentication credentials
I am trying to consume a web service from BizTalk by supplying credentials in the SOAP adapter port. I type in the Web Service URL and then I have the choice of Anonymous, Basic, Digest and NTLM authentication types. How do I supply my username, password and domain?.. when testing with soapUI it works perfectly. The only way I get to ...
BizTalk Database Lookup functoid fixed condition
Is there a way to further restrict the lookup performed by a database lookup functoid to include another column? I have a table containing four columns. Id (identity not important for this) MapId int Ident1 varchar Ident2 varchar I'm trying to get Ident2 for a match on Ident1 but wish it to only lookup where MapId = 1. The functoid o...
BizTalk Generate Metadata Fails with Stored Procedure
I am trying to set up the SQL Adapter in BizTalk 2009 to use a Stored Procedure in our SQL 2008 DB. For some reason, when I click "generate" in the wizard, and then click "next," I receive the following message: Failed to execute SQL Statement. Please ensure that the supplied syntax is correct. New Transaction cannot enlist in the...
"What makes a good BizTalk project"
"What makes a good BizTalk project" is a question I was asked recently by a client's head of IT. It's rather open ended, so rephrasing it slightly to : "what are you top ten best practices for a BizTalk 2006 and onwards projects - not limited to just technical practices, eg organisational" ...
BRE Long Term Fact Retriever cache is being updated multiple times in BIzTalk Server 2006 R2
I am facing a problem with Business Rules Engine in Biztalk Server 2006 R2. I have 1 policy in BRE. A class library is used to invoke the policy. I have a LongTermFactRetriever implemented. Everything works fine with the BRE cache getting refreshed if 1 message at a time is sent through the orchestration. But if we send bulk message...
What is the SQL query for Orchestration debugger information (tracking data) in BizTalk?
By using the Orchestration debugger one can get useful time information on the left, regarding entering and leaving shapes. Unfortunately one cannot copy the information from that window. I would like to do some benchmarks and save statistics in Excel. Does anyone know the sql query to get the same data from the DB? I have tried to fin...
what is future for Biztalk Server in the Market?
I am undergoing Biztalk server training in my company. I have almost 6 years of experience in both Microsoft and Open Source like PHP mostly in web applications. Does it make sense to learn Biztalk server for my future career? In short Will it help me to improve my profile? Please advise/suggest. Thanks, ...
BizTalk web-service call: unable to connect to remote server
I am trying to call a web service from a BizTalk (2006) orchestration. Having got the hang of the basics, I have been following this tutorial (page 74 onwards) in which i have a web reference to an external web service (I am using this web service instead of the one in the tutorial), I have my web message in a Send component, and have ...
Removing header from a flat file in BizTalk
What is the simplest way to remove the header row from a flat file in BizTalk? I have implemented this by creating a separate schema for the header row (and one for the body) and then set the HeaderSpecName property in the 'Configure Pipeline' dialog to the header schema I've just created and then the PreserveHeader property to false. My...
Biztalk 2006r2 Commerce Server Adapter
I am trying to query Commerce Server 2007 using the Biztalk Adapter. I am using the OrdersAdapter and trying to query for all orders with a specific line item on them. The message xml is <CommerceServerOrdersQuery> <CLAUSE OPER="equal" xmlns="http://schemas.microsoft.com/CommerceServer/2004/02/Expressions"> <PROPERTY ID="LineIte...
Resources on Biztalk
Can anyone recommend any websites/books for getting up to speed on biztalk quickly? ...
how to migrate from biztalk 2002 to biztalk 2006 R2
i would like to have step by step instructions on how to migrate from biztalk 2002 to biztalk 2006 R2. ...
Visual Studio 2008 SP1 and upgrading a BizTalk 2006 R2 project to BizTalk 2009 Project - Failing
Greetings all, I have posted this on the MSDN managed news groups as well as a BizTalk site, but I am not sure they get enough traffic that as I don't seem to be getting a response. Help me StackOverflow, your my only hope. I am in the process of upgrading our Visual Studio BizTalk projects from BizTalk 2006 R2 to BizTalk 2009. I s...
BizTalk Server physical deployment question
Hi I am deploying a BizTalk solution at a client shortly; Their infrastructure architects want SQL Server in a seperate security zone on their network isolated from the other servers. My question, knowing that BizTalk is very chatty with SQL and relies heavily on it; what would the performance impact be in having the SQL Server(s) in a...
Consuming .NET web service in Oracle Forms
I have a web service that i need to consume in Oracle Forms. The web service is SOAP based service and was generated using Microsoft Biztalk Server. The service accepts a complex xml message as its request and returns a similar xml message as response. I want to consume this service from within my Oracle Forms Application (Forms version ...