How to connect remotely to server using sql studio

Question

I am new to SQL but this is what i would like to do. I have these information hostname: hostname.com port: 1523 SID: oracledb Username: username Password: password

I would like to connect remotely to this server to retrieve data using MSSQL studio. Can you please explain to me how to do it. thank you

Answer 1

You cannot directly connect to and query an Oracle database using SQL Server Management Studio. You can, however, create a SQL Server linked server to your Oracle instance and query remotely through that. You would connect to your SQL Server using SSMS like normal, but query your linked server using the linked server name in 4-part naming fashion, e.g: select * from [MyOracleServer]..MyDatabase.MyTable.

Here is a SQLMag tutorial on doing this: Connecting SQL Server and Oracle Using Linked Servers.