SQL server 2005 to oracle + connect over HTTPs

Question

SQL server 2005 to oracle + connect over HTTPs

da-221236

SSC-Addicted

Points: 422
More actions
November 5, 2008 at 6:34 am

#200935

hi,
It is possible to connect a SQL server 2005 db to an oracle db over the internet and specifically over HTTPS? i.e. is it possible to set up a linked server (or equivalent) between the 2 dbs (not on the same network) to communicate securely over the internet?
The remote oracle db would only be pulling data from the sql server database and not vice versa.
We have a public facing machine which has an SSL cert, so HTTPs would be the desired option if possible.
thanks
da

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

jgrubb SSCrazy Points: 2542 More actions · Answer 1

da (11/5/2008)
hi,
It is possible to connect a SQL server 2005 db to an oracle db over the internet and specifically over HTTPS? i.e. is it possible to set up a linked server (or equivalent) between the 2 dbs (not on the same network) to communicate securely over the internet?
The remote oracle db would only be pulling data from the sql server database and not vice versa.
We have a public facing machine which has an SSL cert, so HTTPs would be the desired option if possible.
thanks
da

Define "connect". If you mean can I treat it exactly like say, an ODBC connection, no. You could use a web services call, a VPN tunnel, or something else.

You'll need some extra configuration. HTTPS is a specific protocol. Something needs to listen and then pack/unpack the communication.

My recommendation for simplicity would be to look into a VPN. It could be (and if done right, should be) transparent to your application.

aleksandar.kostovski SSC-Addicted Points: 421 More actions · Answer 2

From Oracle side there are few possibilities.

First you could use direct call to Oracle Listener, which I think knows how to handle SSL connections. This would be ODBC connection of course.

Second you could use standard HTTP, but you have to build stored procedures on Oracle side to handle data access/manipulation. Oracle comes with Apache web server which has module for connection to Oracle and SSL included.

Third and the easiest solution are using the VPN connection which will be handled by OS. ODBC again.

Maybe some third-part solutions that I have not heard about ?!?

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 3

use OpenDataSource in you Select Statement to get the Oracle Data.

For more information see SQL BOL.

da-221236 SSC-Addicted Points: 422 More actions · Answer 4

thanks aleksandar.kostovski & jgrubb.

Creating and usign a secure connection i.e. Using a TCP port tunnel/VPN ssh port tunnel to secure a connection is now not an option (although probably the best).

aleksandar.kostovski - please expand on you first 2 suggestions if you could:

First you could use direct call to Oracle Listener, which I think knows how to handle SSL connections. This would be ODBC connection of course.

Second you could use standard HTTP, but you have to build stored procedures on Oracle side to handle data access/manipulation. Oracle comes with Apache web server which has module for connection to Oracle and SSL included.

..these are of great interest to me.