BizTalk and Windows Azure SQL Database

In past I written posts on interaction between BizTalk and Windows Azure SQL Database (former known under SQL Azure) using the WCF-SQL Adapter. I have revisited one of my posts that dealt with calling a stored procedure. To bring back old memories I tried to do same against using BizTalk Server 2013 (this time through using an orchestration and messaging)

The WCF-SQL Adapter (binding) from the BizTalk adapter pack has the following capabilities:
  • Execute create-read-update-delete statements on tables and views; 
  • execute stored procedures and generic T-SQL statements 
  • Database polling via FOR XML 
  • Database polling via traditional tabular results 
  • Proactive database push via SQL Query Notification 
  • Expansive adapter configuration which impacts connection management and transaction behavior 
  • Support for composite transactions which allow aggregation of operations across tables or procedures into a single atomic transaction 
  • Rich metadata browsing and retrieval for finding and selecting database operations 
  • Support for the latest data types (e.g. XML) and SQL Server 2008, 2008 R2, 2012 platform, Windows Azure SQL Database 
  • Reusable outside of BizTalk applications by WCF or basic HTTP clients 
  • Adapter extension and configuration through out of the box WCF components or custom WCF behaviors 
  • Dynamic WSDL generation which always reflects current state of the system instead of fixed contract which always requires explicit updates 
Depending on the version of BizTalk Server and its subsequent adapter pack the supported SQL Server versions range from 2005 to 2012. Beside the on premise SQL Server versions the adapter also supports connectivity with Windows Azure SQL Database. In the Wiki article the execution of a stored procedure in Windows Azure SQL Database will be discussed. . I have written my experience down in the TechNet Wiki article and posted the code in MSDN Gallery:
Cheers,

Steef-Jan

Comments

Anonymous said…
Ιt is appropгiate tіmе to maκe some plаnѕ for thе future and іt's time to be happy. I have read this post and if I could I desire to suggest you some interesting things or suggestions. Maybe you could write next articles referring to this article. I want to read even more things about it!

Feel free to visit my web-site - senuke services
9:39 AM
Post a Comment

Popular posts from this blog

DTAP Strategy: Pricing and Licensing

Image
To implement BizTalk solutions it is a good practice to have an DTAP environment in place. DTAP stands for Development, Test, Acceptance and Production. Development and test environments are equal (mirrored) and same account for acceptance and production. Deploying DTAP environments is easy, because there are many factors influencing outcome of DTAP. One factor is pricing and licensing costs. BizTalk is available in different editions and since BizTalk depends on operating system and database there are some configuration options to. Here is an overview of possible configurations for DTAP environments, hence there is a nice BizTalk Feature Dependency Matrix. Besides features, there are non-functional requirements to reckon with like fail-over, availability and scalability. On Microsoft Pricing and Licensing FAQ section of BizTalk I found this on non functional side. In a large BizTalk Server 2006 R2 deployment, two key considerations ensure redundancy in all areas of the architect...
Read more

BizTalk Server 2010 Exam : How to prepare?

Image
In previous post I yesterday I wrote that new BizTalk 2010 exam is out. And you may figure how to prepare as in preparation material nothing is mentioned.Let’s look at what skills are measured. In a nutshell these topics are: Configuring messaging architecture (setup, manage ports, configure adapters, implement messaging solutions); Developing BizTalk Artefacts (building orchestrations, create schema’s, maps and pipelines); Debugging and Exception Handling (debug orchestrations, validate and test artefacts like schema’s, maps, pipelines); Integrating Web Services and Windows Communication Foundation (WCF) Services (WCF Adapters); Implementing Extended Capabilities (this is the BAM, BRE, RFID and EDI part); Deploying, Tracking, and Supporting a BizTalk Solution (Installation in different kinds of scenario’s, deployment of applications, bindings). You can find a lot of resources that can help in preparation through BizTalk Development Center like the BizTalk tutorials for EA...
Read more

Table Operation on Oracle 11g XE with OracleDbBinding

Image
Last year I did a post on table operations on SQL Server Table with WCF-SQL Adapter from BizTalk on SQL. Now I like to do similar thing on table in Oracle 11g Express database using the Oracle Binding from BizTalk Adapter Pack 2010. Oracle 11g Express Edition is available through OTN. For downloading software you will need to have an account! It is important that when accessing Oracle you have appropriate client installed. This can sometimes be a hassle if you do not know, which client you need. When you trying to connect to Oracle you will get error messages like: Connecting to the LOB system has failed. Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.. This can be pretty annoying, but there is documentation that can help you going the right direction. In installation documentation I read that supported versions are: Oracle d...
Read more