Forum Replies Created
-
AuthorPosts
-
Hi,
The TNS alias is the same as the ODBC data source name set up on that server. Check the following blog on more information on how to troubleshoot LOB Oracle adapters (look for the entry titled “Using LOB Oracle adapters with BizTalk Server 2006 R2” and dated September 11):
http://bibhakar.spaces.live.com/blog/
Daniel.
I’ have configured the conecction binding with servicename and servername. Have I to configure the connection bing with the TNS alias? How can I know the TNS alias in that case?
Hi Daniel.
Thanks a lot! Yes, you’re right – it is very nice to have/keep all this thnig together in one place.
best regards
Wolfgang
Hi Wolfgang,
Yes, you could use a job in the windows scheduler to place the file in the folder at given times, but you would have to keep track of that separately, and personally, I prefer to keep things running in BizTalk within the boundaries of BizTalk platform as opposed to under the control of the OS.
Daniel.
Hi,
Did you check the receive location (where you are using the Oracle Adapter) for its connection binding? That’s where you would find the TNS alias…
Daniel.
July 20, 2010 at 7:13 AM in reply to: Code promotion from dev to test. I am facing this problem, please help #25289Did you checked in BTS Administrator the Apllication and that all Objects (Schemas, Orchetsrations, Pipelines, Maps etc.) are there?
Did you configured the Application with the orhestration?
That worked for me too!
Thanx man!
July 19, 2010 at 11:50 AM in reply to: Code promotion from dev to test. I am facing this problem, please help #25285I promoted code using Export MSI and then imported. moved the dll to gac.
I think problem is with the default batching orchestrations??
Hello Daniel.
Looks pretty nice so far – thanks for the link, i will check this out.
Another way could be to use the windows scheduler to put a file into an folder where the receive pipeline is watching for it, is this right?
Thanks again
Wolfgang
Hi Wolfgang,
Have you taken a look at the Scheduled Task Adapter on Codeplex? Here’s a link to that:
http://biztalkscheduledtask.codeplex.com/
I believe it also works on BizTalk 2009 platform.
Daniel.
Hello Greg.
Thanks for your reply.
Yes, you’re right. Both Party elements are the same and I want the element as often as I like.
I have an element called “Party”. This “Party” element has two Attributes, one is called “ID” and one is called “Role”. Now I want to fill these attributes from different source fields in the same map.
Source field ————————–> Destination field
<ID> ————————————> <Party Role=’MR’ ID=’912345′>
<Number> —————————-> <Party Role=’UD’ ID=’9′>
At the end I have in the Output-XML several Elements called “Party” with different attribute values.
The destination schema looks like:
<xs:element minOccurs=0 maxOccurs=unbounded Name=”Party”>
<xs:attribute name=”ID” type=”xs:string” use=”required”>
<xs:attribute name=”Role” type=”xs:string” use=”required”>
And the Output as an XML File should looks like this:
…
<Party Role=’MR’ ID=’912345′>
<Party Role=’UD’ ID=’9′>
<Party Role=’…’ ID=’…’>
<Party Role=’…’ ID=’…’>
…
My question is, how can I handle it in the map? Should I just “draw a line” from the source element to the destination element and everything will be handled by the schema? Or do I have to use special functoids? I don’t no at the moment.
Thank you very much in advance.
Wolfgang
//Edit: I forgot to say the source file has only single records!
A BizTalk map only operates on the message data, not the message context.
However, if you perform the map in the receive port then the only the message data is modified, while the message context remains intact. ( with the exception that properties are promoted from the output message based on it schema and these properties may overwrite existing properties)
If you perform the map in an orchestration you create a new message, with a blank context, so you must copy these properties yourself e.g.
In an message assignment shape in the construct message shape after the transform:
OutputMessage(Mynamespace.MyProperty) = InputMessage(Mynamespace.MyProperty);or to copy all properties:
OutputMessage(*) = InputMessage(*);Depends on what you mean by “can BizTalk process PDF files”
BizTalk is capable of moving any file from one location to another. You can use pass-thru pipelines and generic message types in orchestrations to move any binary data.
However, if you wish to use data inside a file then you need to be able to parse that file into Xml.Can you explain a bit more about your process?
With a record containing fixed length fields it is impossible to determine the length of the next field without explicity declaring the new field in a schema.
The only way to dynamically parse an indeterminant number of fixed length fields based purely on the data is to include the field length in the message. Unfortunately the FF disassembler does not handle this scenario, but you could write a pre-parser that converts these fixed length fields into a delimited record.
Alternatively if you use a delimited structure, you can create a record with an unbounded number of fields. The FF disassembler will continue parsing fields until the end of the record.You can use the value mapping functoid, which takes a boolean and a data input. If the boolean is true then the data input is output, otherwise nothing is output.
Are both Party element above the same, or do you have two different Party elementsIt would be useful if you could explain the source message and how you determine which role to use.
-
AuthorPosts