OraFAQ Forum: Networking and Gateways » Need help regarding oracle database gateway for ODBC

Home » RDBMS Server » Networking and Gateways » Need help regarding oracle database gateway for ODBC (Oracle 11gR2, MS SQl Server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need help regarding oracle database gateway for ODBC [message #653249]

Thu, 30 June 2016 03:33

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Hello Friends,

I am using oracle 11gR2 database. Now i need to get some data on regular basis from MS SQL Server 2008 database which is on different hardware. I have some questions regarding "Oracle Database Gateway for ODBC".

1. Should i need additional license of "Oracle Database Gateway for ODBC", even though i have a license of oracle database.
2. Where should i install "Oracle Database Gateway for ODBC"?
option 1 : On that hardware where oracle 11g database is running, where i need data of ms sql server 2008 or
option 2 : On that hardware where MS SQL Server 2008 is running?

Your reply would be appreciated.

Thanks,
Chintan

Report message to a moderator

Re: Need help regarding oracle database gateway for ODBC [message #653251 is a reply to message #653249]

Thu, 30 June 2016 05:08

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

1. No.

2. Option 1.

Report message to a moderator

Re: Need help regarding oracle database gateway for ODBC [message #653252 is a reply to message #653251]

Thu, 30 June 2016 05:24

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Thanks,

Anybody have any link or document regarding option 1. I have some confusion for environment variables like $ORACLE_HOME, because variable is same while both database and gateway have different homes.

Thanks,
Chintan

Report message to a moderator

Re: Need help regarding oracle database gateway for ODBC [message #653253 is a reply to message #653252]

Thu, 30 June 2016 05:28

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Installing Oracle Database Gateway for ODBC.

Report message to a moderator

Re: Need help regarding oracle database gateway for ODBC [message #653254 is a reply to message #653253]

Thu, 30 June 2016 05:56

chintan.patel
Messages: 162
Registered: July 2008
Location: Ahmedabad

Senior Member

Should i install oracle database in one user and gateway in another user, however both have same group.

Thanks,
Chintan

Report message to a moderator

Re: Need help regarding oracle database gateway for ODBC [message #653256 is a reply to message #653249]

Thu, 30 June 2016 06:12

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

No license needed.

You can install the gateway on any computer that is on the same network as both the Oracle and non-oracle servers. I have multiple oracle databases on multiple servers, each with db links to multiple MSSQL databases on multiple servers. I installed one gateway on one server, and that is my switchboard for all inter-database communications.

I wrote an article explaining the overall architecture that, given your questions, should really help you get your head around the basic framework. You can read it here

Report message to a moderator

Previous Topic:	Connect Oracle VDB to Active Directory (LDAP modify problems)
Next Topic:	TNSPING - Message 3509 not found; No message file for product=network, facility=

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 13 09:15:17 CDT 2025