-
Oracle to Sqlserver
I need to poll a sqlserver database using a select statement from an Oracle Unix instance to gather informtion from the Sqlserver table and to pull information of a certain type.
I am aware of Oracle Heterogeneous services but since this is a Unix box it seems like I need to buy an expensive ODBC driver from an outside vendor to get this done.
The other opinion are some Java ODBC drivers but it sounds like I then have to construct Java Sql instead of native Sql.
Does anyone know a better way? There are other architectural opinions but am I missing information on the ODBC front?
-
Try reading on 'Oracle's Transparent Gateway', see if it meets your requirement.
Goodluck
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|