BizTalk Server Reporting

ITS Consulting proposes a new feature for BizTalk Server called BizTalk Server Reporting already used by many of its clients. The BSR can be completely adapted to suite the Reporting needs of BizTalk Server users.

Indeed, Once the message enters BizTalk Server, the difficulty is to know for non technical users (sometimes even for technical once) is to know what is the technical and functional status of my Process? did the partner take my message, was there any technical or functional error message? how many messages were integrated during the day or the week?

ITS Consulting’s solution propose a non intrusive code, it doesn’t modify any of your existing codes, and allows to have a technical and functionnal feedback of your prcesses status

Find out more, and contact us on our WebSite

Oracle Advanced Queuing and BizTalk Server

To connect Oracle Advanced Queuing to BizTalk it’s quite simple :

You have to install the ODP.NET (Oracle Data Provider.NET)

Few tricks: BizTalk Server connects only to oracle and could execute only native functions (function, stored procedures, or staight select, insert, delete, update in  tables) then to dequeue or enqueue messages I used functions.

How to configure the function?

In Queues of the OAQ, you have options (Wait for ever, no wait, or a number corresponding to how many seconds the connection must wait)

Two options:

1. Either do polling, poll while data found and a select count on your table queue, and the option no wait in your dequeue function
2. Or do polling with select 1 from dual, and the option wait forever in your dequeue function

For further details please visit my blog

Consultant BizTalk Server en France

ITS Consulting est spécialisé dans les technologies Microsoft et spécialement Microsoft BizTalk Server, alors n’hésitez pas à venir visiter notre site.

Mais nous avons aussi des compétences dans SQL Server, Sharepoint, .NET et toute la suite Microsoft.