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

[ Post a follow-up to this message ]

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 D
B.

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 g
o
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 th
e
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 see
ms
> 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

[ Post a follow-up to this message ]