Forum Replies Created
-
AuthorPosts
-
Hi rocky,
Please consult the following MSDN articles and link to see what would work best for your environment and infrastructure:
http://msdn.microsoft.com/en-us/library/aa475435.aspx
http://msdn.microsoft.com/en-us/library/aa558765%28BTS.20%29.aspx
http://stackoverflow.com/questions/1951469/network-load-balancing-biztalk-instances
Hope these resources help,
Daniel.
Hi,
See if the following blog can help you resolve your issue:
http://stackoverflow.com/questions/1724095/how-to-programmatically-turn-off-security-in-wcf
Daniel.
Hi,
Have you considered using Table Looping/Table Extractor functoids to achieve your scenario? Check this following blog for an example, which I believe is close to your requirements:
http://geekswithblogs.net/evankoch/archive/2007/08/07/114470.aspx
Hope this helps,
Daniel.
Hi mster,
Have you considered exposing your BizTalk orchestration as a web service or WCF service in order to consume it from SQL Server?
Daniel.
You can use BizTalk SQL Adapter for this purpose. If you are using BizTalk 2009 then you can use the WCF-SQL Adapter.
Regards,
Abhijit
Ok, thanks for the answer – I’ll try that.
I’ve got one more idea but I don’t know if it’s possible to do. I’ve got one source XML (with schema) and two output xml schemas (generated automaticly by Consume Adapter).
– I recieve source xml and map some header values to the first output schema – I’ve inserted header row,
– next I map the same source xml to another output schema to insert some positions. Here I can insert only first position.
I can construct loop in orchestration, count quantity of positions in source XML but how can I construct new output message and change some values in that ? This message should be the same as the second output schema. When in message Construct shape I use Transform and next I get error : “Inner exception: Illegal attempt to update the value of part ‘part’ in XLANG/s message ‘OraPosMessage’ after the message construction was complete.”
Is there any way to solve thie problem ?
regards,
Hi,
Thanks on your update.
Will try to explain on better way.
Namely this is input file (XML)
</Pages>
<Page>
<Item Value=”ORDER DATE” CtrlID=”4″ SectionID=”1″ />
<Item Value=”ORDER NUMBER” CtrlID=”18″ SectionID=”15″ />
<Item Value=”CUSTOMER NAME” CtrlID=”66″ SectionID=”15″ />
<Item Value=”CUSTOMER ADRESS” CtrlID=”57″ SectionID=”15″ />
<Item Value=”COUNTRY” CtrlID=”59″ SectionID=”15″ />
<Item Value=”SHIPMENT DATE” CtrlID=”33″ SectionID=”15″/>
<Item Value=”AMOUNT” CtrlID=”7″ SectionID=”3″ />
<Item Value=”LOCATION” CtrlID=”38″ SectionID=”3″ />
<Item Value=”ITEM CODE” CtrlID=”5″ SectionID=”3″ />
<Item Value=”LINE NUMBER” CtrlID=”211″ SectionID=”3″ />
<Item Value=”ITEM DESCRIPTION” CtrlID=”223″ SectionID=”3″/>
<Item Value=”AMOUNT” CtrlID=”7″ SectionID=”3″ />
<Item Value=”LOCATION” CtrlID=”38″ SectionID=”3″ />
<Item Value=”ITEM CODE” CtrlID=”5″ SectionID=”3″ />
<Item Value=”LINE NUMBER” CtrlID=”211″ SectionID=”3″ />
<Item Value=”ITEM DESCRIPTION” CtrlID=”223″ SectionID=”3″ />
<Item Value=”AMOUNT” CtrlID=”7″ SectionID=”3″ />
<Item Value=”LOCATION” CtrlID=”38″ SectionID=”3″ />
<Item Value=”ITEM CODE” CtrlID=”5″ SectionID=”3″ />
<Item Value=”LINE NUMBER” CtrlID=”211″ SectionID=”3″ />
<Item Value=”ITEM DESCRIPTION” CtrlID=”223″ SectionID=”3″/>
</Page>
</Pages>As you saw here are 3 attributes, Value (this should be mapped in source schema) , CtrlID and SectionID (these two attributes determinate where Value must be mapped , for example if SectionID is 3 and CtrlID is 5 that means that this should go to Line amount in destination schema).
Output (in CSV) should be something like this:
oRDERDATE|ORDERNUMBER|CUSTOMERNUMBER|CUSTOMERADRESS|SHIPMENTDATE|COUNTRY|ORDERTYPE(STATIC VALUE)|OWNER(STATIC VALUE) this is OrderHeader
LINENUMBER|ORDERNUMBER|ITEMCODE|ITEMDESCRIPTION|COUNTRY|SHIPMENTDATE|OWNER (STATIC VALUE) this is OrderLine
LINENUMBER|ORDERNUMBER|ITEMCODE|ITEMDESCRIPTION|COUNTRY|SHIPMENTDATE|OWNER (STATIC VALUE) this is OrderLine
LINENUMBER|ORDERNUMBER|ITEMCODE|ITEMDESCRIPTION|COUNTRY|SHIPMENTDATE|OWNER (STATIC VALUE) this is OrderLineHope that now is more clear.
Hi Patrick,
Is this already resolved? Did you already add the dll to BizTalk application?
– JC
Hello,
Have you tried conditional looping? For the given input, can you post the output desired in XML? That might help further understand the issue.
Today I appeared for 70-241’s first attempt. Unfortunately I have not cleared it. Still I can give second free attempt. Can anyone share latest study material or practice questions (dumps) for the same? My email id is [email protected].
Thanks in advance.
May 11, 2010 at 5:24 AM in reply to: Failed to connect to the SQL database SSODB on SQL Server #24668One of the very commone things, but hard to solve because most people don’t know the answer. I have searched days for an answer and hopefully this answer is the one for you too.
The best solution I found was to re-register the ssosql.dll on the following manner:
1. start the visual studio command prompt
2. go to the ssosql.dll C:\Program Files\Common Files\Enterprise Single Sign-On
3. regasm ssosql.dll
and probably you are finished.
Hi,
you’re true, if you have got the BizTalk Adapter Pack 2.0, you could use composite operation for Oracle Database
http://msdn.microsoft.com/en-US/library/dd788415(v=BTS.10).aspx
The aim is to generate the schema of the SP(s), then you create a new schema Composite with a Root (called CompositeOperationRequest for exemple) and in this root you create Record element as many SP you want (in order you want they execute), finally you create a reference in this schema to include definition of the SP Schema and you type the record(s) with the type of the generated schema root.
In your case where you want to call the same stored procedure, the steps are :
Generate the schema of the stored procedure
Create a new schema with a root, Import the generated schema
Add a record in the root element, and type this record with the reference of the generated schema
Change the property of max occurs to unbounded(*)
Create a map to transform your XML to the XML that will call the SP with the Header and the insert positions
Create a Send Port WCF with OracleDbBindings and specify the action to http://Microsoft.LobServices.OracleDB/2007/03/CompositeOperation
(All these steps are described in the first link)
A good thing to know is in composite operations, all the call of the procedure(s) are do in the same transactions (so rollback to)
Have a good Sample 😉
Regards
Hi,
Check the following blog to see how an orchestration is exposed as a WCF service and how such a service is consumed in a Windows console application:
Daniel.
Thanks for the reply Ben
I’ve been forced to same conclusion
myself 🙁– good tip about the separate folder for the generated
artifacts !Is it any better in BTS 2009 or 2010 ?
Can you share with us the solution.
-
AuthorPosts