Re: Connecting to Oracle Forms Server 9i

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks Bryan,

Just if any body interested, I found the following useful link on MSDN
that describes the process step by step.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts06coredocs/html/248156e1-e120-41fc-8fc6-1daf8618d045.asp

Also you can find this in the documentation accompanying the Enterprise
Adapters setup that comes with Biztalk 2006.

Thanks again..
Rami




Bryan Corazza wrote:
The adapter has a built in interval that will run the query that was selected
when it was first setup. Then the results become the message that is sent to
the message box.



--
Bryan Corazza
http://geekswithblogs.net/bcorazza/


"ramialhasan" wrote:

Thanks Brian,

Ok, could you please just give me an idea about how to do this in
Biztalk? The normal flow is that a message is received on a port then
it is handled by the orchestration, so where should I put this logic
that queries the Oracle Adapter periodically ?

Thanks
Rami


Bryan Corazza wrote:
The oralce adapter can be used to run a stored procedure or query on an
interval and grab the messages that were last inserted into a table. Make
sure once you do this that you flag those messages via the SP that they were
grabbed by BizTalk as to not produce duplicates.

The adapter is not event driven and must be setup to look at a SP or a
table, the SP option is recommended of course.


--
Bryan Corazza
http://geekswithblogs.net/bcorazza/


"ramialhasan" wrote:

I am a newbi in Biztalk, and I want to use Biztalk to connect different
heterogenous systems to a Windows box. One of the systems I want to
connect to is Oracle Forms Server 9i. I want to send and receive
messages with this server. My question is what is the best way to
communicate with this server that is compatible with Oracle.

I am thinking of using Oracle Adapter.
To get data from Oracle Forms, OF should write to some table in its
Oracle database,
To send data to OF, I will write to a table in Oracle database.

Sending seems trivial, but for receiving how could I know that Oracle
Forms has inserted certain record in its Oracle database. Does Oracle
Adapter support some kind of events or triggers to update my Biztalk,
or should I keep pulling data to check if new messages have been
inserted? If I should keep pulling, is there a way like a timer or a
thread to do this in Biztalk?

Thanks a lot for yout help.
Rami





.

Relevant Pages

  • Re: BizTalk adapter for Oracle E-Business Suite 11i 5.10.2
    ... in that the Oracle e-Business Suite adapter that shipped with BizTalk ... I have another similar question related to Oracle e-Business Suite connected ... database adapter - - it uses the same base code as the Oracle Database ... Microsoft Online Community Support ...
    (microsoft.public.biztalk.general)
  • Re: SSA vs SCSI - general IO troubleshooting
    ... Which SSA adapter? ... We run AIX 5.2 with Oracle 9I. ... The disk is a mix of some RAID5, ... This disk is just JBOD using a single 6203 SCSI adapter. ...
    (AIX-L)
  • Re: Connecting to Oracle Forms Server 9i
    ... The adapter has a built in interval that will run the query that was selected ... when it was first setup. ... that queries the Oracle Adapter periodically? ... grabbed by BizTalk as to not produce duplicates. ...
    (microsoft.public.biztalk.general)
  • RE: calling oracle stored proc from Biztalk 2006
    ... The "Running Stored Procedures" article in the "Oracle Database ODBC ... Adapter" documentation may help. ... calling oracle stored proc from Biztalk 2006 ... like in SQL adapter you have to change the sql statement with FOR XML ...
    (microsoft.public.biztalk.general)
  • RE: Error message in custom send adapter
    ... stored procedure. ... I have made a custom oracle adapter, ... string filePath = OracleTransmitProperties.CreateFileName(message, ...
    (microsoft.public.biztalk.general)