BizTalk Server Orchestration - BizTalk rule with fact based in Oracle db

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Orchestration > May 2005 > BizTalk rule with fact based in Oracle db





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 BizTalk rule with fact based in Oracle db
anonymous

2005-05-23, 7:50 am

Hi,
I want to create a rule to compare a value in the Oracle datacolumn with
some value.How do i create a rule with oracle db because when i go to the
Databases column i see only connecting to SQL is allowed.
Regds


JGaska [http://www.IoniaSolutions.com]

2005-05-24, 5:57 pm

Good Morning;

You have a few options there, you can call a C# assembly wrapper where you
access the values within your Oracle DB. You could also create a linked
server in SQL to your Oracle DB then access the values from your rule engine
via SQL brokering the communication to your Oracle DB. Let me know what you
are trying to compare and where, is it simply something in your rule
currently and you want to access values in Oracle? If that is so c# assembly
wrapping Oracle access classes, call that assembly within the rule. You
could also consider using the mapper as well.

-Joe


"anonymous" wrote:

> Hi,
> I want to create a rule to compare a value in the Oracle datacolumn with
> some value.How do i create a rule with oracle db because when i go to the
> Databases column i see only connecting to SQL is allowed.
> Regds
>
>
>

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com