Harvard Medical School is building a data warehouse, containing data to be
extracted and uploaded from several administrative systems. The platform for
the data warehouse will be a Sybase (SQL Server) data base running on an HP9000
(HP-UX) server. Primary access will be via a client-server front end built
with Uniface, running on Windows machines (486s) and Macs. Network transport
will be TCP/IP running over Ethernet. Files will be transferred to the server
using FTP. There will be ad hoc access to the data base via a query tool or
report writer, to be selected.
We are required to implement encryption on all packets travelling over the
network, including the 3 primary areas:
€ FTP transfer
€ Query tool access
€ Uniface front end access
Kerberos or other authentication services are not required, although we are
willing to implement them in order to get encryption.
We are willing to run Sybase Open Client either on the client machines or on
the server (I believe it has to run somewhere).
Does anybody have some ideas on how to do some or all of this?