Re: Large Project, Integration with existing Oracle and MS SQL
| От | Patrick Carroll |
|---|---|
| Тема | Re: Large Project, Integration with existing Oracle and MS SQL |
| Дата | |
| Msg-id | d2f7eefc0707050133m37644669g4d986a4ffd1dc6d9@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Large Project, Integration with existing Oracle and MS SQL (Richard Huxton <dev@archonet.com>) |
| Ответы |
Re: Large Project, Integration with existing Oracle and
MS SQL
|
| Список | pgsql-general |
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@archonet.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
В списке pgsql-general по дате отправления: