- This topic has 5 replies, 1 voice, and was last updated 8 years, 4 months ago by
.
-
Posts
-
-
Client wants to expose over 100 DB2 Stored Procedures as WCF WebServices. We’ve got our DB2 connections and Host Integration Server (HIS) working so we can call a single stored proc.
Does anybody have any suggestions of how to scale to this level and manage it?
For example, I could have one orchestration per DB2 stored proc and publish as WCF service. But then , there would be the tedium of doing it 100+ times, or I would need to create a orchestration “generator” to do it.
Or are the any alternatives that DB2 itself has that will do the same? I’ll be googling – found and reading this now: http://www.databasejournal.com/features/db2/article.php/3784896/Transforming-Business-Logic-into-Web-Services-Using-DB2-95-and-IBM-Data-Studio.htm
Thanks,
Neal Walters -
Hi Neal,
Take a look at this article that I came across, discussing WCF LOB Adapter SDK and WCF Channel Model:
http://blogdoc.biztalk247.com/article.aspx?page=ceb0a313-2588-41e0-a731-a5809b257609
Daniel.
-
We can get to DB2 now using the HIS adapter. I know there is now a WCF adapter for MS-SQL. Not sure if LOB adapters work with DB2, but even if they did, how does that address my question. How do I do it in a massive way for over 100 stored procs?
Thanks,
Neal
-
Neal,
Did you ever find a managable solution for wrapping a large number of DB2 stored procedures? I’m very interested since I have a similar challenge.
-
Hi all,
I came across this article about IBM Data Web Services, and wasn’t sure if it would be relevant for your scenario, but I thought I would throw that out here just in case…
http://www.databasejournal.com/features/db2/article.php/3784896
Daniel.
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.