- This topic has 5 replies, 1 voice, and was last updated 8 years, 3 months ago by
.
-
Posts
-
-
Hi,
Todd Van Nurden ([url=http://www.gotdotnet.com/workspaces/workspace.aspx?id=4669f9cf-1eb9-4891-ba35-76ea42e45de4]gotdotnet[/url]) wrote that the \”[i:b7f910ad6b]ODBC Adapter for BizTalk Server 2004[/i:b7f910ad6b]\” supports a variety of databases like Oracle, DB2, SQL, SQLLite or [u:b7f910ad6b][b:b7f910ad6b]MySQL[/b:b7f910ad6b][/u:b7f910ad6b].
Unfortunately, I’m using BTS2K6 and even if his new custom adapter, \”[i:b7f910ad6b]BTS2K6 Dynamic ODBC Adapter[/i:b7f910ad6b]\” ([url=http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=2F88D1C8-BD76-4A1D-B55B-C5FF80B7D3C4]gotdotnet[/url]) works properly for an Oracle DB, I can’t use it for connecting BizTalk to a [u:b7f910ad6b][b:b7f910ad6b]MySQL[/b:b7f910ad6b][/u:b7f910ad6b] database.
So firstly, do you think it is possible to use this custom adapter to [b:b7f910ad6b][u:b7f910ad6b][color=darkred:b7f910ad6b]connect BizTalk and MySQL[/color:b7f910ad6b][/u:b7f910ad6b][/b:b7f910ad6b] ?
If you think it doesn’t, what other (free) possibilities do you think I have ?
I would be grateful if someone know (a part) of the answer…
[size=9:b7f910ad6b](Obviously, I’ve already asked the question to Todd Van Nurden himself … but the answer isn’t yet here).[/size:b7f910ad6b]Thanks !
-
-
Yes ! Good Idea, I could easily do that with an external .NET class wich connect to MySQL DB.
But in an orchestration, I have to begin with a receive shape, (I guess you know that better than me…) ? Where do you think I can put the .NET class ? In a "Construct Message" shape or an "Expression" shape ? Before the "Receive" shape ?
Indeed, the first thing my scenario has to do is to retrieve data from MySQL DB.
Thank you a lot for your help.
-
Well, in the past I have use a “start message” that gets sent to BizTalk from a scheduled task or windows service. Then, I put my code after the receive shape inside an expression shape. The start message doesn’t do anything but start the Orchestration.
It might make sense to look at the community ODBC adapter on gotdotnet. Or even write your own customer adapter to read from the database (this will take some time though).
Hope this helps.
-
Hi Stephen,
First of all, thanks a lot for your help.
I finally have proceed like you told me first. It works fine, of course, but I (and especially my bosses) don't really like the use of windows schedule task.
So one of my new objective will be : succeed to use the community ODBC adapter by adding the proper code.To sum up, I'm a little bit disappointed that I don't have any feedback from the community adapter on GotDotNet and I promise that when my MySql or ODBC adapter will be ready to work, I will send the source and documentation to BizTalkGurus.com, if you are interested.
Kindest regards.
-
Rather than use the windows schedule task, you could try the Scheduled Task Adapter.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E473FC93-5081-44C7-A9C9-84BF4E783728You could use this to initiate an orchestration that will call a .NET class to access MySQL.
Or you could call your .NET class from this adapter. It requires two classes, one to define your config properties like connection string and query and the second implements the MySQL access and returns a stream.
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.