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?