how to integrate Microsoft SQL Server database with Oracle

shahbazali_001 · #1 (**permalink**) 12-19-11, 07:17

Any body please tell me how to create a link database on Oracle to access Microsoft Sql server's database on Oracle?
And please tell me how i can access all objects of other already existing link databases.

Any suggestion will be appreciate.
I will be thankful.

n_i · #2 (**permalink**) 12-19-11, 10:03

Google for "Oracle Transparent Gateway"

shahbazali_001 · #3 (**permalink**) 12-20-11, 03:04

brother,

Please tell me what is the purpose of "Oracle transparent gateway" in Hetrogeneous services.

regards,

beilstwh · #4 (**permalink**) 12-20-11, 08:56

it is a piece of software that makes a sql server database look like another oracle database to oracle so that you can make a database link to it and use it as you would any other database.

Internet Services

Web Development

Digital Marketing

Consumer Tech