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?
