[Openroad-users] OpenROAD and Oracle

[Jean-Pierre Zuate]

Hello Stephen,

Perhap's it is time to migrate your Payroll application to Ingres, think to
shift2ingres if it's a Java application :-)

More seriously, I know many things are possible via the Gateway but not all
what you said (not sure you can have a rule fired from Oracle so it could
not be automatic ...)

2006/12/21, stephen.mcculloch at falkirk.gov.uk <
stephen.mcculloch at falkirk.gov.uk>:
>
> Hi Peter
>
> We have a Payroll Application(oracle) and a Pension
> Application(ingres/openroad)
>
> We hold fields, Employee number, Post id and Pensions number on
> both systems. These fields are predominantly administered from the
> Payroll application. When a change has been made to any of the
> fields by payroll staff an internal memo is sent to Pensions informing
> them of the change. I was looking to update the Pensions application
> automatically when a change has occurred.
>
>
>
>
> On 21 Dec 2006 at 7:04, Peter van Bennekom wrote:
>
> > Hi Stephen,
> >
> > As far as I know without writing your own API's to another DLL that
> > wraps Oracle database access to bypass the gateway, it is not
> > possible.
> >
> > What are you trying to accomplish?
> >
> > Peter
> >
> > Peter van Bennekom | Senior Technical Architect | Infor | office: +1
> > (610) 407-8113 | fax: +1 (610) 407-8027
> >
> > -----Original Message-----
> > From: openroad-users-bounces at peerlessit.com
> > [mailto:openroad-users-bounces at peerlessit.com] On Behalf Of
> > stephen.mcculloch at falkirk.gov.uk
> > Sent: Thursday, December 21, 2006 8:43 AM
> > To: OpenROAD Users
> > Subject: [Openroad-users] OpenROAD and Oracle
> >
> > Hi all
> >
> > Is it possible to query an Oracle table from within OpenROAD
> > without using Enterprise Access for Oracle?
> >
> > Thanks
> >
> > Stephen
> >
> > Stephen B McCulloch
> > Software Developer
> > ----------------------------
> > Corporate & Commercial Services
> > ICT Infrastructure (Software Development)
> > Falkirk Council,
> > Municipal Buildings,
> > West Bridge Street,
> > Falkirk, FK1 5RS
> > Scotland, UK
> > ------------------------------------------
> > Telephone : (01324) 501523
> > Fax          : (01324) 501516
> > E-mail      : stephen.mcculloch at falkirk.gov.uk
> >
> >
> > **********************************************************************
> > ** ** The information contained in this e-mail is confidential and is
> > intended only for the named recipient(s). If you are not the intended
> > recipient, you must not copy, distribute or take any action or
> > reliance on it. If you have received this e-mail in error, please
> > notify the sender. Any unauthorised disclosure of the information
> > contained in this e-mail is strictly prohibited.
> >
> > The views and opinions expressed in this e-mail are the senders own
> > and do not necessarily represent the views and opinions of Falkirk
> > Council.
> > **********************************************************************
> > ** **
> >
> > _______________________________________________
> > Openroad-users mailing list  Openroad-users at peerlessit.com
> >
> > To unsubscribe please click on this link
> > mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
> >
> > To subscribe please click on this link
> > mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
> >
> > _______________________________________________
> > Openroad-users mailing list  Openroad-users at peerlessit.com
> >
> > To unsubscribe please click on this link
> > mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
> >
> > To subscribe please click on this link
> > mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>
>
>
> **************************************************************************
> The information contained in this e-mail is confidential and is intended
> only for the named recipient(s). If you are not the intended recipient, you
> must not copy, distribute or take any action or reliance on it. If you have
> received this e-mail in error, please notify the sender. Any unauthorised
> disclosure of the information contained in this e-mail is strictly
> prohibited.
>
> The views and opinions expressed in this e-mail are the senders own and do
> not necessarily represent the views and opinions of Falkirk Council.
> **************************************************************************
>
> _______________________________________________
> Openroad-users mailing list  Openroad-users at peerlessit.com
>
> To unsubscribe please click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
> To subscribe please click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>



-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20061221/3213a729/attachment.html