The following may be a starting point Oracle(r) Database Heterogeneous Connectivity Administrator's Guide 10g Release 2 (10.2) B14232-01 http://docs.oracle.com/cd/B19306_01/server.102/b14232/intro.htm#sthref17 Oracle(r) Database Heterogeneous Connectivity User's Guide 11g Release 2 (11.2) E11050-01 http://docs.oracle.com/cd/E11882_01/server.112/e11050/tgvsgc.htm#g1007512 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark Sent: Wednesday, August 21, 2013 1:32 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: view of a link I believe the feature is now DG4ODBC. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Christopher.Taylor2@xxxxxxxxxxxx Sent: Wednesday, August 21, 2013 1:23 PM To: Brian.Zelli@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: view of a link Depends on version of the database but you can use hsodbc to create a database link to the SQL Server Database. I did that in the 9.2 and 10.2 days years ago. I have no idea if that is still a viable option or not. HSODBC is heterogeneous services. Try a google search for hsodbc oracle sqlserver... HTH Chris -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian Sent: Wednesday, August 21, 2013 12:17 PM To: oracle-l (oracle-l@xxxxxxxxxxxxx) Subject: view of a link If I have a sql server table, can I create an oracle view of that table? ciao, Brian This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you. -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l