Clever Geek Handbook

Connecting to Oracle from Sybase

For complex reasons (not always) I need to query an Oracle table from a Sybase view. Any thoughts on how I can accomplish this?

Sample oracle con data: database: dta@mydomain.com schema: dta pwd: 123

0


source to share


1 answer


If you need to get real-time data, you need a gateway. Oracle Database Gateways



If there might be a delay, you might be better off doing periodic data export and then using an external table. Oracle external tables

+1


source






More articles:


All Articles