I need to create a view in Oracle that displays data from a SQL Server table. I'm not sure if there is a database link in SQL Server, and if so how to create one.
has anyone done this before?
Asked
Active
Viewed 109 times
1 Answers
2
You need to create and configure Oracle Database Gateway for SQL Server.
see here. This link will help you in creating and configuring the same.
Rahul
- 76,197
- 13
- 71
- 125