JHB, South Africa: BizTalk Server 2006 Deep Dive Invitation

JHB, South Africa: BizTalk Server 2006 Deep Dive Invitation

BIZTALK SERVER  2006 DEEP DIVE

For a limited time only, Microsoft South Africa is offering this BizTalk Server 2006 Deep Dive training course at a reduced price exclusively for Microsoft partners and BizTalk Server customers.


This 5-day instructor-led course teaches you how to build advanced messaging and business process integration solutions. Individuals who attend this course are expected to have some familiarity and existing hands-on experience with creating schemas and schema maps, creating orchestrations, and deploying and managing BizTalk applications.

 

This course is intended for BizTalk Server 2006 R2 developers who are responsible for building advanced messaging and business process integration scenarios. Individuals who attend this course are expected to have some familiarity and hands-on experience.

Normally this course costs $3395 (USD), but if you act quickly you can attend for only $500.

 To register please click here.

 

Use registration code MSBPG1 to register for $500 (USD) (normal price is $3395). Class size is limited. Registrations are accepted on a first-come first-served basis and subject to eligibility verification

 

Date: May 12 – 16, 2008
Days: 5
Hours: 8:30 – 18:30

IT Intellect
Choice House
22 Sloane Street
Corner William Nicol Drive and Sloane Street, Bryanston
Johannesburg
South Africa

 

Register now

http://www.microsoft.com/southafrica/images/invitations/2007/october/biztalkusergroup/biztalk_logo.gif

http://www.microsoft.com/southafrica/images/invitations/2007/october/biztalkusergroup/reserveplacebtn.gifhttp://www.microsoft.com/southafrica/invitations/2008/april/biztalkdeepdive/images/eventdetails.jpg

 

Prodigal BizTalk Scheduled Task Adapter returns

After a lengthy absence from the BizTalk Community, the BizTalk Scheduled Task Adapter is once again available.  Greg Forsythe has kindly made it available at http://www.codeplex.com/BizTalkScheduledTask, together with the source code for this adapter.

For those who are not aware of this adapter: through the use of this adapter on a receive location you are able to schedule the creation of a message into the BizTalk message box, which can then be used to start a BizTalk process.  The scheduling options are flexible, allowing for a daily, weekly or monthly schedule to be created.  Configuration of the adapter provides for a selection of three standard tasks to take place once the scheduled time is reached:

  • XmlString – generates a Biztalk message from a configured Xml string
  • FileReader – generates a Biztalk message from the contents of a file
  • HttpDownload – generates a Biztalk message from data downloaded from a web site

In addition to the standard tasks, custom tasks can also be created by creating any .NET class that implements the appropriate interface.

Have you met Greg?


This is a question I find myself asking my colleagues often. And they typically reply with something like, “Who’s Greg?” or “Greg in accounting??”. Not quite what I was getting at


 


Greg Leake is a guy who works for me in the Connected Systems Division. He spends most of his time in a self-created, self-run .Net Framework testing lab; and by most of this time, I literally mean most of the hours that he is not sleeping, and some of those too.  During the hours of 9am to 2 am, you can typically find him working away in his lab.  Greg’s very passionate about helping developers, and he’s had significant successes with his projects–Interesting enough that I recently looked into his bloodshot, over caffeinated eyes and told him to pack up his servers and hit the road to tell more people.


 


This week and next, Greg will be presenting the .NET StockTrader 2.0, including a new Configuration Service, to .NET community user groups in San Francisco, Boston and NYC-check here for more info. We’re also posting the updates online for everyone to play with and give feedback on-we hope that you’ll write to Greg on his blog or in the forum about what’s working and what isn’t.


 


So check out Greg’s blog for good stories from the tour, updates to the code and more. Oh, and if you’re interested in how many cups of coffee Greg drinks in a daythe Twitter section is especially interesting.

SQL Adapter – New Features (2nd list)

As you might have read earlier (this post), a new SQL Adapter is on its way. The features we plan to support are described there.


Further to that, some time back I had mentioned a few limitations (here), which we wouldn’t be addressing.


I am happy to say that due to the TAP customer feedback received on this feature, we WILL be allowing multiple operations (i.e., INSERT, UPDATE, DELETE on the same or different Tables/Views) as well as Stored Procedure/Function invocations within the same XML message (and therefore, within the same Transaction). One thing to keep in mind though:



  • The adapter will only generate the metadata for individual operations (i.e., there will be one schema for INSERT, one for UPDATE, etc, one for a Stored Procedure, etc). The user will manually have to create a schema combining all the operations which need to be a part of the same XML message/Transaction. This shouldn’t be too difficult – once the individual schemas have been generated, coming up with a combined schema should take no more than a couple of minutes. This entire process will be documented.

Our current plan is to release a CTP around the end of May / beginning of June. If you plan on using the adapter, you should join the TAP program. TAP customers have a direct communication channel with the developers on the team, and can play an important role in pushing for important features (important for them) to be included in the final product. If you are interested in joining the TAP program, please leave your email address here (in a comment to this post – don’t worry about spam, I promise to remove your address the moment I make a note of it).

SQL Adapter – New Features (2nd list)

As you might have read earlier (this post), a new SQL Adapter is on its way. The features we plan to support are described there.


Further to that, some time back I had mentioned a few limitations (here), which we wouldn’t be addressing.


I am happy to say that due to the TAP customer feedback received on this feature, we WILL be allowing multiple operations (i.e., INSERT, UPDATE, DELETE on the same or different Tables/Views) as well as Stored Procedure/Function invocations within the same XML message (and therefore, within the same Transaction). One thing to keep in mind though:



  • The adapter will only generate the metadata for individual operations (i.e., there will be one schema for INSERT, one for UPDATE, etc, one for a Stored Procedure, etc). The user will manually have to create a schema combining all the operations which need to be a part of the same XML message/Transaction. This shouldn’t be too difficult – once the individual schemas have been generated, coming up with a combined schema should take no more than a couple of minutes. This entire process will be documented.

Our current plan is to release a CTP around the end of May / beginning of June. If you plan on using the adapter, you should join the TAP program. TAP customers have a direct communication channel with the developers on the team, and can play an important role in pushing for important features (important for them) to be included in the final product. If you are interested in joining the TAP program, please leave your email address here (in a comment to this post – don’t worry about spam, I promise to remove your address the moment I make a note of it).

Extract the iteration from a repeating loop designated by a certain qualifier

A while back I posted a solution that helped me extract the value from a repeating loop designated by a qualifier. I’ve seen this come up many times with EDI, either you’re extracting a ST or ship-to information or a REF reference information. Although my previous solution worked it involved adding 4 functiods and changing data within the scripting functiod depending on the Qualifier. I’ve simplified it to only require 3 functoids and no need for adjusting the script inside of the functoid.

Here’s an example of what your 3 functoid would look like.

1. Add a “^” before and after the Qualifier

2. The scope of the Cumulative Concatenate Functoid should be 1.

3. The Scripting Functoid Input will be the Qualifier you’re wanting to find and the output from the Cumulative Concatenate functoid.

4. Finally Insert the following code into the Scripting Functoid (Inline Visual Basic .NET)

Public Function RepeatingLoopWithQualifier_1(ByVal Qualifier As String, ByVal All_Qualifiers_and_Values_Concatonated As String) As String
‘All_Qualifiers_and_Values_Concatonated Expects a Commulative Concatonated String of all
‘Qualifers preceded by a “^” and Values preceded by a “^” for example ^ST^912 Summer DR.^BT^4312 W. Powell

Dim QualifierLocation As Integer = All_Qualifiers_and_Values_Concatonated.IndexOf(“^” + Qualifier + “^”)

Dim QualifierandValueSplit As String()

‘If Qualifier is found, find the corresponding Value, else Return “”
If QualifierLocation >= 0 Then

QualifierandValueSplit = All_Qualifiers_and_Values_Concatonated.Substring(QualifierLocation + 1, All_Qualifiers_and_Values_Concatonated.Length – (QualifierLocation + 1)).Split(“^”)
Return QualifierandValueSplit(1)
Else
Return “”
End If
End Function