Geeks With Blogs
Stuart Brierley Integration Management - BizTalk and More June 2010 Entries
BizTalk 2009 Adapters - The Scheduled Task Adpater: Receive Location
The BizTalk Scheduled Task Adapter is an in process receive adapter that can be implemented on a receive location to execute a prescribed task on a daily, weekly or monthly schedule. I have previously talked about the installation of the Scheduled Task Adapter with BizTalk Server 2009, detailed below are details of how this adapter can be configured on a receive port. Within the BizTalk Administration console, right click and add a new one way receive location. Select the receive port that your receive ......

Posted On Wednesday, June 23, 2010 4:15 PM

BizTalk 2009 Adapters - The Scheduled Task Adpater: Installation
The BizTalk Scheduled Task Adapter is an in process receive adapter that can be configured to execute a prescribed task on a daily, weekly or monthly schedule. "The adapter is configured entirely within Biztalk, all config is stored within the SSODB and can be exported and imported via binding files. The schedule capabilities are similar to those available with the Windows Scheduled Task Service." Although defined on codeplex as an adapter for BizTalk Server 2004 or BizTalk Server 2006, the Scheduled ......

Posted On Wednesday, June 23, 2010 10:19 AM

BizTalk 2009 - The Community ODBC Adapter: Schema Generation with Input Parameters
As previsouly noted in my post on Schema Generation using the Community ODBC Adapter, I ran into a problem when trying to generate a schema to represent a MySQL stored procedure that had input parameters. After a bit of investigation and a few deadends I managed to figure out a way around this issue - detailed below are both the problem and solution in case you ever run into this yourself. The Problem Imagine a stored procedure that is coded as follows in MySQL: StuTest(in DStr varchar(80)) BEGIN ......

Posted On Wednesday, June 9, 2010 3:27 PM

BizTalk 2009 - The Community ODBC Adapter: Send Port
I have previously talked about the installation of the Community ODBC adapter and also using the ODBC adapter to generate schemas and laterly the creation of a receive port using the ODBC Adapter. But what about creating a send port? Select to add a new Send Port, select the ODBC Adapter and click configure. Clicking Connection string will open the DataSource window. Choose one of your system datasources and press OK. This will now update the Transport properties. Select okay. All that remains is ......

Posted On Wednesday, June 9, 2010 2:40 PM

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. Create a new receive location and select to use the ODBC adapter and click Address. You will now be ......

Posted On Wednesday, June 9, 2010 2:25 PM

BizTalk 2009 - The Community ODBC Adapter: Schema Generation
Having previously detailed the installation of the Community ODBC Adapter for BizTalk 2009, the next thing I will be looking at is the generation of schemas using this ODBC adapter. Within your BizTalk 2009 project, right click the project and select Add Generated Items. In the resultant window choose Add Adapter Metadata and click Add to open the Add Adapter Wizard. Check that the BizTalk Server and Database names are correct, select the ODBC adapter and click next. You must now set the connection ......

Posted On Wednesday, June 9, 2010 1:54 PM

BizTalk 2009 - The Community ODBC Adapter: Installation
I have previsouly detailed the installation of MySQL, the configuration of MySQL and the installation of the ODBC Data Connector for MySQL. The reason I needed to install and configure these servers was to provide a test environment for a BizTalk Server 2009 solution I am working on where BizTalk will be querying and populating a MySQL database. To do this I then needed to install and add the Community ODBC adapter from Two Connect: "The Community BizTalk Adapter for ODBC is based on the code that ......

Posted On Wednesday, June 9, 2010 1:24 PM

MySQL - ODBC Data Connector
Having previsouly installed and then configured MySQL, you may now need to install the ODBC Data Connector driver in order to connect to your MySQL database. Following the Splash screen the first thing to choose is the Setup Type for your installation. As usual I chose custom so that I could see the components that were actually being installed. In this case the custom set up screen allows you to choose to install the driver and the documentation. Finally you can complete the installation Assuming ......

Posted On Monday, June 7, 2010 4:14 PM

MySQL - Configuration
Having previously detailed how to install MySQL Server, the next step is configuring MySQL. The MySQL configuration wizard can either be run immediately following installation from the MySQL installation wizard or manually from the Start Menu. Following the splash screen you can then choose whether to run a detailed or standard configuration. The detailed configuration allows you to create the optimal configuration for your specific machine, whereas the standard configuration creates a general configuration ......

Posted On Monday, June 7, 2010 10:20 AM

MySQL - Installation
In order to create a development environment for a project I am working on, I recently needed to install MySQL Server. The first step was to download the msi. Running this presents you with the installer splash screen, detailing the version of MySQL that you are about to install - in this case MySQL Server 5.1. Next you can choose whether to install a Typical, Complete or Custom installation. Although this is the first time I have installed MySQL and the Custom option states "Recommended for advanced ......

Posted On Friday, June 4, 2010 3:17 PM

(Not) Making a Splash with Visual Studio
This post is just a quicky to remind me of a Visual Studio switch that I found interesting/useful. If you are interested in such things, there are a number of command line switches that can be used with Visual Studio. One that does not appear on the list linked to above is the "nosplash" switch. This switch disables the splash screen when starting Visual Studio, taking you directly into the IDE. Close Visual Studio and then add /nosplash after ...devenv.exe in the target of whichever shortcut you ......

Posted On Wednesday, June 2, 2010 9:00 AM

BizTalk 2009 - The Scope of the Table Looping Functoid
When mapping in BizTalk you will find there are times when you need to map from flat and dispersed elemements in your source schema to a repeated record with child elements in your destination schema. Below is an example of how you can make use of the Table Looping Functoid to bring together these flat elements and create your repeated group. Although this example is purposely simple, I have previsouly encounted this issue on a much more complex scale when mapping the response from a credit scoring ......

Posted On Tuesday, June 1, 2010 9:24 AM

Copyright © Stuart Brierley | Powered by: GeeksWithBlogs.net