CODEWITHSUNDEEP
oracle-databasesybase

Reputation:

Connect to Oracle from Sybase

For complicated reasons (aren't they always) I need to query an Oracle table from a Sybase view. Any thoughts of how I can do this?

example oracle con details: database: [email protected] schema: dta pwd: 123

Upvotes: 0

Views: 1708

Answers (1)

anon
anon

Reputation:

If you need to get the data live you'll need a gateway.Oracle Database Gateways

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

Upvotes: 1

Related Questions