With this extra info it's easier to answer the first question.
No, you can't use SAS/CONNECT unless you have a SAS session at there server end. Bit for accessing an Oracle DB on the remote host, SAS/ACCESS to Oracle will be sufficient, at least to access that data in particular.
To be able to assist with the design of your whole environment, I think you need direct assistance from a senior person, i.e. from SAS or an independent consultancy.