|
Home > Archive > BizTalk Server Orchestration > March 2006 > Database lookup functoid and Oracle database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database lookup functoid and Oracle database
|
|
| Piotr Skorupski 2006-03-01, 7:55 am |
| Hi,
im trying to use database lookup with Oracle database whith one of my maps.
I have created ODBC data source to my Oracle database. I've configured
properly database lookup functoid. When Im running process, everything seems
to work fine. There's no errors in event log, it seems that functoid
connection to DB was succeful, but functid is not returning any values.
Anyone know any issues or tips related with database lookup functoid and
Oracle database?
Thanks for further information
Kind regards
Piotr Skorupski
| |
| Kevin Farley 2006-03-03, 6:17 pm |
| Piotr -
Try not to get mad at me here. ;) but I would recommend you do not use a DB
Functoid. That is not the best way to do things in BizTalk typically.
Maps are best with XSLT, XSLT is best when it doesn't have to connect to a DB.
I have found that I either use the Rules System or a DB Adapter to get data
I want and then update a message accordingly in a Map if it is static data
(combining multiple messages if I need to) or here is a really nice way to go
but a bit advanced as a developer technique:
I use XSDObjectGen tool from MSDN to generate a C# (or VB) version of my
message types. Then I can use Managed Code to pass data into Methods to
update the Object and then I can serialize the transformed object back to the
Message I need to send.
I believe it is fair to say that DB Functoids are often not the best way to
do things and in my experience might be left for HIPAA or EDI if the vendors
require it because of all the crazy codes they have.
I think you'll find performance will be much better an you will have more
control if you get all of your data into Message structures and then use
either a Map or a Custom Utility from a Serialization approach to transform
your outbound message.
How does this sound?
--
Kevin Farley, Principal Solutions Architect
EMC - Microsoft Practice
"Piotr Skorupski" wrote:
> Hi,
>
> im trying to use database lookup with Oracle database whith one of my maps.
> I have created ODBC data source to my Oracle database. I've configured
> properly database lookup functoid. When Im running process, everything seems
> to work fine. There's no errors in event log, it seems that functoid
> connection to DB was succeful, but functid is not returning any values.
>
> Anyone know any issues or tips related with database lookup functoid and
> Oracle database?
>
> Thanks for further information
>
> Kind regards
> Piotr Skorupski
|
|
|
|
|