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
