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.

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

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).

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.

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

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