Integrating to the max...BizTalk Style

After taking the BizTalk 2009 Deep Dive training the next step was to upgrade my certifications on BizTalk. Today was the day and i am very happy that i have passed the BizTalk 2006 R2 70-241 exam. I am now certified on both the BizTalk exams 70-235 and 70-241 :) I found the 70-235 exam to be focused on usage of tooling and terms, and a really nice exam that is based on experience. The 70-241 exam was focused on more 'advanced' knowledge on exception handling, orchestration design, pipeline processing etc, also a nice exam (except for the 20 questions i had to fill in before i could actually take it). Completing the exam i was nervous and reviewed all the questions that i had marked for review 3 times. When i decided that is was time for the verdict i clicked 'End exam'. Each time i do this on a exam my internal timer starts ticking; 1...did i pass?, 2....oh no i forgot that!....3....come on! 4..what's the verdict....it was a 972, that made my day! Happy studying fo...

Microsoft Dynamics AX 2009 is a new version of one of Microsoft ERP systems tailored for a specific market. The advantages of the new Dynamics AX 2009 version is that the technical integration of trading partner integration is much more robust and interfacing with other applications using BizTalk has now become even easier because the accompanied BizTalk AIF Adapter. Dynamics AX 2009 exposes documents using an application platform called AIF. AIF enables the integration of Microsoft Dynamics AX through Web services, Microsoft Message Queuing (MSMQ), the file system (using a directory), or BizTalk Server. The AIF framework uses documents wrapped in envelopes for processing. A downside to not using the BizTalk adapter is that the envelope processing has to be performed additionally while the BizTalk adapter will solve this for you. A colleague of mine has an article on how to do AIF processing without the AIF adapter (see: http://www.microtalk.net/2009/04/23/AssignAHeaderValueInAnAIFDyna...

When developing pipeline components it is higly recommended to do any processing in a streaming manner to ensure that the performance hit is minimal. The other day I had to build a pipeline component to strip Attachments from the messagestream. I decided to use an XPath mutator because of the streaming features, in this blog I try to describe what steps I followed to implement and test the pipeline. · Extracting the BizTalk message dll’s from the GAC · Creating the pipeline component Using the XPath mutator · Testing the pipeline component 1) Extracting the BizTalk message dll’s from the GAC Because some of the nicest BizTalk assemblies are only in the GAC it requires some effort to extract these. The assembies are: Microsoft.BizTalk.Streaming.dll and Microsoft.BizTalk.XPathReader.dll. See the following link for information on how to extract the dll's: http://bloggingabout.net/blogs/wellink/archive/2006/07/12/12947.aspx 2) Creating the pipeline component Using the XPath mutator The...

When you are a developer taking the first steps into the BizTalk realm, you might find these issues that i have encountered usefull to be aware of; [WS Adressing] Using WS Adressing can be realized by the leverage of the WCF (WS)Http adapter. An important thing to remember when using the WCF adapters is to set the SoapParameterStyle to ‘Bare’, this prevents the serialization process to wraps the Message, since this is not expected by the WCF adapter. [Bindings] Port configuration is lost during deploy When the binding configuration is not maintained during redeploy (eg. the ports are reset to a different pipeline) there is a chance that is caused by an old binding file. \Documents and Settings\\Application Data\Microsoft\BizTalk Server\Deployment Problem: Orchestration version is different so bindings are lost binding files contain all the bindings, back up these frequently [Comparision of Biztalk 2004 vs 2006 + (R2)] 2004 - Routing for failed messages not available 2006 - routing for ...

Tired of searching the meaning and specification of all the WCF bindings, hereby a summary of all bindings that are available in a single document... WCF Configuration

After the swift change of employer this year i've decided to revise my new year resolution: - i will blog again - the main language is english (archives remain in dutch) My linked profile is the first online activity that is up te date, after that i will start writing blogs about various subjects in the area of integration and mainly focused on BizTalk. Next month will be a perfect source of inspiration since i will attend the BizTalk 2009 Deep dive, can't wait.

Below is a collection of snippets i've used during a project implementation. If you're working with Oracle, you might be able to gain some quick insight how you can use it for the benefit of your project. Grant / permissions GRANT ALL ON TO ; PL/SQL Cursors CURSOR c_orderlines IS SELECT order_pk FROM orders; BEGIN -- !!turn off the notifications!! v_process := 1; v_id := 0; DBMS_OUTPUT.put_line('Started @' || sysdate); OPEN c_orderlines; FETCH c_orderlines INTO v_id; WHILE c_orderlines%found LOOP FETCH c_orderlines INTO v_id; END LOOP; CLOSE c_orderlines; END; System tables all_tab_columns This is like the syscolumns/systables in SQL Server all_source This allow searches in all entities that exist Inline SQL DECLARE ..... BEGIN END; Retrieve the name of the package $$PLSQL_UNIT Output DBMS_OUTPUT.put_line Queries Top selection: where rownum http://www.oracle.com/technology/oramag/oracle/06-sep/...