BizTalk Server 2009 R2

BizTalk Server 2009 R2 is planned for 2010 and will include:

Support for new Platform releases:
Visual Studio 2010
SQL Server 2008 R2
Windows Server 2008 R2

Improved Business to Business(B2B) scenarios:
Mapper Enhancements: Mapper Enhancement includes enhanced visualization, scrolling and search capabilities.
FPTS adapter: a secure and standards-based adapter allows exchanging documents between trading partners using the FTP protocol.
Updated B2B Accelerators

Productivity Enhancements:
Performance tuning dashboard
Improved support for event processing and filtering for RFID Events
Support PowerShell for Management tasks.
New SCOM object model to better reflect BizTalk artifacts.

Comments

Post a Comment

Popular posts from this blog

How to poll database using WCF-SQL adapter

Image
1. Create database and tables2. Create stored procedure 3. Create BizTalk project 4. Create orchestration 5. Consume WCF-SQL 6. Write received data to file share


First create TESTWCFSQL database from you SQL Management studio Run the script to create table:
USE TESTWCFSQL GO
IF OBJECT_ID('dbo.MainData', 'U') IS NOT NULL DROP TABLE dbo.MainData GO
CREATE TABLE dbo.MainData ( MainDataID int primary key identity(1,1), FirstName nvarchar(30), LastName nvarchar(30), Amount int ) GO

Run script in SQL management studio to create procedure
IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE SPECIFIC_SCHEMA = N'dbo' AND SPECIFIC_NAME = N'PollData' ) DROP PROCEDURE dbo.PollData GO
CREATE PROCEDURE dbo.PollData AS select MainDataID, FirstName, LastName, Amount from dbo.MainData delete from dbo.MainData GO
insert some sample lines executing
use TESTWCFSQL
insert into MainData (FirstName, LastName, Amount) values (N'Patrick', N'Cash', 1000), (N&#…
Read more

XML debatch in pipeline

Image
Last month I had a post were described how to debatch XML message in orchestration using XPath. http://biztalk.kirakosyan.com/2010/02/debatching-records-from-wcf-sql-using.html How I wrote it is not the best solution , in case if you will have hundreds of records the debatching using XPath will consume too much memory and processor.
In this post I am going to show how to debatch using pipeline. The sample will fetch multiple records from MS SQL database and after debatching put them to folder.
How to create simple WCF-SQL ports and SQL polling you can read in my old post http://biztalk.kirakosyan.com/2010/02/how-to-pull-database-using-wcf-sql.html I will use the same procedure and table to generate Schemas and PortTypes
In generated schema change envelop type to yes


Next click on TypePolling which is the root for schema
In properties find Body XPath
and edit it as in picture is
Then change the last node to have Max Occurs = 1
Now we should remove hidden stones :-)
When you added adapter metadata f…
Read more