Posts

Showing posts from July, 2011

The Future of Middleware and the BizTalk Roadmap

If you interested in future of BizTalk watch the latest talk of Tony Meleg during WPC 2011 Los Angeles: AP03 - The Future of Middleware and the BizTalk Roadmap .

Calling Stored Procedure Oracle 11g Using WCF-Custom OracleDbBinding

Image
In this post I like to show how to call a stored procedure in Oracle 11g XE performing an insert and an update. To create a stored procedure in Oracle 11g I look for guidance and found at Oracle® Database PL/SQL Packages and Types Reference , and PSOUG Insert and Update . I created the following two procedures: create or replace procedure "INSERT_CUSTOMER" (customer_name IN VARCHAR2, customer_street IN VARCHAR2, customer_city IN VARCHAR2, customer_state IN VARCHAR2, customer_photo IN BLOB) is begin INSERT into customer (name, street, city, state, photo) values (customer_name, customer_street, customer_city, customer_state, customer_photo); end; create or replace procedure "UPDATE_CUSTOMER_ADDRESS" (customer_name IN VARCHAR2, customer_street IN VARCHAR2, customer_city IN VARCHAR2, customer_state IN VARCHAR2, customer_photo IN BLOB) is begin UPDATE customer SET street=customer_street, city=customer_city, state=customer_state WHERE name=customer_name; end; Both are

Using BTSHTTPReceive in x64 Environment

Image
I have a VM with BTS 2010 installed on a Windows Server 2008 R2 x64. In this environment I wanted to find out how to work with HTTP Adapter. Fortunately there two samples found in <install folder>:\Program Files(x86)\BizTalk Server 2010\SDK\Samples\AdapterUsage\HTTPRequestResponse or HTTPSolicitResponse (you will find them if you have selected the SDK feature during BizTalk Installation). Before running the example you will need to follow these steps if working in x64 environment (i.e. my VM): Open IIS and click Machine Name on left panel, then click "ISAPI and CGI restrictions" on the right panel, then Add the ISAPI or CGI path: On a 64 bit machine add: C:\Program Files (x86)\Microsoft BizTalk Server 2010\HttpReceive64\BTSHTTPReceive.dll 2. Check allowed extension path or execute. For sample for instance RequestResponse, you will need to click setup in HTTPRequestResponse folder. After refreshing IIS you will see HTTPRequestResponseSample. Now you will have

SQLExecute Oracle 11g XE using WCF OracleDbBinding

Image
In previous post I detailed polling an Oracle 11g XE (Express) database using OracleDbBinding in WCF-Custom Adapter. Now I like to share how I can perform SQL statements through SQLExecute operation. You can run parameterized SQL statement on an Oracle database through WCF-Custom with OracleDbBinding. This binding supports the SQLExecute operation, which acts on an input parameter block comprised of parameter sets that enable execution of the same SQL statement once for each set. The operation will in the end return the results of the SQL statement in a generic record set. The SQLEXECUTE operation is surfaced under the root node (/) in the Select a category pane in the Consume Adapter Service BizTalk Project Add-in. To be able to use this operation through orchestration or messaging in BizTalk you need to create a schema. The following steps will lead to creation of this specific schema: Right click project, and then Add –> Add Generated Item –> Consume Adapter Service –>

Polling Oracle 11g XE with OracleDbBinding

Image
In previous post I detailed how to perform some table operations in Oracle 11g using OracleDbBinding (WCF). I now like to show how to do polling in Oracel 11g XE. You can download a number of BizTalk Server 2010 Adapter Pack samples and I will use the Polling an Oracle Database sample. What sample will do is configuring a polling transaction (query) that targets the <schema name>. ACCOUNT_PKG.ACCOUNTACTIVITY table. For each polling transaction, the following actions are performed: Executes a polling statement specified for the PollingStatement binding property. The specified polling statement is a query that selects all records from the <schema name>. .ACCOUNTACTIVITY table. The response for the select query is copied to a FILE location. Executes a post poll statement specified for the PostPollStatement binding property. The post poll PL/SQL code block moves the records in the query result set to the <schema name>. .ACTIVITYHISTORY table. Execute the polling sta

Passed BizTalk 2010 exam (70-595)

Image
Today I passed the BizTalk 2010 exam and I am certified technology specialist again. In the past I passed the BizTalk 2006 (70-235) and BizTalk 2006 R2 (70-241) , but both of them where retired just recently (30th of June 2011). I prepared my self using resources you will find in one of my previous posts. Having a virtual machine with BizTalk 2010 with a lot samples is a great help in preparing. It was a challenging exam with some though questions I had to think about, but also a lot I could answer easily through experience. Any one that will take the exam in near future I would like to wish them good luck and success. It is definitely worth the effort! Technorati: biztalk server 2010

BizTalk Server MVP 2011

Image
Just now I have received an e-mail from Microsoft with exciting news that I’ve been re-awarded the MVP title. For me this is the second time to receive this award. The first year has been an tremendous experience, which gave me the opportunity to do great things and meet inspiring and very skilled people. I would like to thank: - my MVP leads William Jansen  - Ed Hickey and all other Microsoft employees involved - people at Ordina Netherlands and Bert van de Belt in particular for all his support - fellow MVP's Randal, Saravana, Richard, Kent, Stephen, Alan, Mikael, Johan, Oliver, Thiago, Ben, Jon, Jeffrey and Sandro, who I got learn better and supported and helped me out in this program - and finally my wife and children Stan, Ellis and Cato for their support I’m looking forward to another year in the program.