Re: Large Project, Integration with existing Oracle and MS SQL

There has got to be some persistence, there will be a lot of tables and
metadata and it may have to handle validation requirements for other apps
doing secure file transfer and a bespoke secure http proxy and it's going to
be a speculative buffer against protocol based worms crossing into the
production environment.

On 7/5/07, Richard Huxton <dev(at)archonet(dot)com> wrote:
>
> Patrick Carroll wrote:
> > I am architecting a solution for an interface between a highly secure
> > production environment and a corporate network which involves transfer
> of
> > records from Oracle and SQL Server through an intermediary "firewall
> DB", a
> > Postgres Instance, to SQL Server/ Oracle. I anticipate that there will
> > either be direct database links or jdbc connections and stored
> > procedures to
> > pass data.
> >
> > Does anybody have a view on likely issues I may have in practice, should
> I
> > really be looking at existing commercial technologies or is PostgreSQL
> the
> > right technology?
>
> I'm not sure what PostgreSQL is doing for you here, unless you need some
> sort of "buffer" to cope with network bandwidth problems.
>
> Why not just have a secured application sitting in the dmz/on firewall
> and connect to both sides transferring for you?
>
> --
> Richard Huxton
> Archonet Ltd
>