Forum Replies Created
-
Posts
-
Yes this solved the problem.
But now i should be able to access the values inside the ContractProduct Message if I the fields are distinguished or do I miss something? Because I try to access them and send them to a .Net helper but all values are set to "Nothing". Now I thought the message assignment might not work but the output message which I store on disk contains all the values…
Any Ideas?
What is realy the purpose of using Biztalk here? Is it only to keep the sequence of calling the stored procedures? The problem you are trying to solve could possibly be best solved with the SQL Server's Integration services instead of Biztak.
Cheers,
Joshua
e-mail: [email protected]
Interesting Anonymous,
I tried replicating it.
Use XmlDocument xdoc = new XmlDocument();
You wont see tht error again.
For all of you that are as blind as I am, here is a link which deals with this problem…
http://www.biztalkgurus.com/Samples/Append-SourceFileName-Orchestration.html
If you are looking for installation and support.
Refer this link below.
http://www.microsoft.com/technet/prodtechnol/biztalk/biztalk2004/deploy/install_guide.mspx
Firstly thanks a lot for your reply.
We are integrating a
number of Legacy Applications using the BizTalk Server 2006, as the
part of this Integration, an application (ASP.NET with Oracle Database
) is Integrating with another Application (an Oracle Database). The
first application needs to fetch data from the second application for
its data requirements. Currently there is an Oracle job which runs on
the second application (Oracle database) which inserts records in the
Oracle database of the first application using an Oracle Stored
Procedure described earlier. Obviously, currently this is a Point to
Point Integration.Now we want to remove this Point to Point
Integration using a seemless Middleware (SOA) architecture and want
this Intergation to be done using the BizTalk Server. It means BizTalk
would now do this data fetching and insertion rather than the current
Oracle job.I hope this description would have clarified the requirement.
If this is a flat file, change the flat file schema optimization to complexity.
Enrique
http://www.BizTalkAnd.Net/blog
Try restarting the host instance, probably it is cached, by the way you DON'T need to "gac" your pipeline component just copy it into the pipelines components.
Enrique.
By your description it seems to me like a misuse of Biztalk.
Couldn't this work be done all in Oracle?
I would first justify why you need to leave the Oracle environment.
-wa
Biztalk can't do this easily, because it can only transform one file at a time. With Mercator, you can add multiple file "cards" into your transaction and play them against each other, but BizTalk can only perform a 1 to 1 transform.
One approach you can try is to transform with pure XSLT and you can maybe add the second file as an external entity it is unclear if this is well supported; my hunch is that you won't be able to see the external file at runtime because of permission issues.
Or you can load one of the file into a database and lookup against that.
[b]Or you can use an orchestration to envelop both files into one XML file and thereby turn the data into one XML input. This is the best sounding solution to me so far.[/b]
Can any orchestration experts describe how this may be done using orchestration to pull from the two data sources and create an XML output? This would be the concept of using orchestration as mapping. I think if there are too many fields involved this may be a tedious solution.
-wa
Hi All,
Is it possible to receive multiple flat files conforming different schema using a single receive pipeline in BTS 2006? In other words can a FlatFileDisassembler can be used for multiple document schema? Suppose I have Schema1, Schema2, Schema3 and the Flat file disassembler will disasseble flat files conforming any one of them – Is it possible using single receive pipeline?
If multiple flat files are comming from the source system with different formats(predifined but not possible to sniff by filename which flat file adhere to which schema) then how it is possible within orchestration to validate the files against schemas?
This is possible with some adjustments to your orchestration. At first you'll need 3 types of messages: one for the old system (say msgOldSystem), one for the new system (say msgNewSystem) and one you will use to map to from both other message types (say msgCommon).
Your orchestration must start with a Listen-shape with 2 branches. This is necessary because you'll have to receive different kinds of messages. The first branch will receive messages from the old system, the second one from the new system.
Now add activatable Receive-shapes on both branches and set the message types to msgOldSystem and msgNewSystem. Next, each branch will contain a map from the given message type to msgCommon, which you will use later in the orchestration.
After performing the transformations you can exit the Listen-shape and continue processing with the msgCommon message type.Hope this helps!
