BizTalk 2009 - The Community ODBC Adapter: Receive Location

June 9, 2010 · 1 min read

BizTalk 2009 - The Community ODBC Adapter: Receive Location

I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas.  But what about creating a receive location?

An ODBC receive location will periodically poll the configured database using the stored procedure or SQL string defined in your request schema.

If you need to, begin by adding a new receive port to your BizTalk configuration.

BizTalk 2009 ODBC Adapter Receive Location - Port

Create a new receive location and select to use the ODBC adapter and click Address.

BizTalk 2009 ODBC Adapter Receive Location - Location Properties

You will now be shown the ODBC Community Adapter Transport properties window.  Select connection string and you will be shown the Choose data Source window.  If you have already created the Test Database source when generating a schema from ODBC this will be shown (if not go and take a look in my previous post to see how this is done).

BizTalk 2009 ODBC Adapter Receive Location - Transport properties
 

BizTalk 2009 ODBC Adapter Receive Location - Data Source

You will then need to choose the SQL command that will be run by the recieve port.  In this case I have deployed the Test Mapping schemas that I created previously and selected the Request schema.

BizTalk 2009 ODBC Adapter Receive Location - Request Schema

You should now have populated the appropriate properties for the ODBC Com Adapter.

BizTalk 2009 ODBC Adapter Receive Location - Updated Transport Properties

Finally set the standard receive location properties and your ODBC receive location is now ready.

Next: Creating a Send Port

This article is part of the GWB Archives. Original Author: Stuart Brierley

New on Geeks with Blogs

  • We Won The One Award I Actually Care About

    Full Scale made the Inc. 5000 for the fifth year straight, the 12th listing across my three companies. Here is why the one award you cannot buy is worth stopping for.

  • Your Customers Build the Features Now

    I let a tool I liked sit dead for a year rather than build the features I wanted. An MCP server meant I never had to, and your customers can do the same to your product.

  • Get the Size of a Directory in Linux the Easy Way

    du -sh for the quick answer, ncdu for the cleanup, df for the disk itself: every command for checking directory size in Linux, plus why du and df never agree.

  • Vim Search and Replace: The Ultimate Guide

    One :%s command replaces every match in a file before a find dialog would even open. The Vim substitute patterns worth the muscle memory: flags, ranges, capture groups, and multi-file edits.