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

2007-07-05 Thread Patrick Carroll
I would use Java and possibly OLEDB/ADO/ADO.Net form the public side as the consumers of this info will want it nice and easy and I dont want to spend hours developing a bespoke interface but put the onus on the consumers of the service to get what they need. Thanks for your comments, much apprec

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

2007-07-05 Thread Richard Huxton
Patrick Carroll wrote: 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 wo

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

2007-07-05 Thread Patrick Carroll
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 prod

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

2007-07-05 Thread Richard Huxton
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