Home » RDBMS Server » Networking and Gateways » Need help regarding oracle database gateway for ODBC (Oracle 11gR2, MS SQl Server 2008)
Need help regarding oracle database gateway for ODBC [message #653249] Thu, 30 June 2016 03:33 Go to next message
chintan.patel
Messages: 147
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
Re: Need help regarding oracle database gateway for ODBC [message #653251 is a reply to message #653249] Thu, 30 June 2016 05:08 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
1. No.

2. Option 1.
Re: Need help regarding oracle database gateway for ODBC [message #653252 is a reply to message #653251] Thu, 30 June 2016 05:24 Go to previous messageGo to next message
chintan.patel
Messages: 147
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
Re: Need help regarding oracle database gateway for ODBC [message #653253 is a reply to message #653252] Thu, 30 June 2016 05:28 Go to previous messageGo to next message
gazzag
Messages: 905
Registered: November 2010
Location: Bristol, UK
Senior Member
Installing Oracle Database Gateway for ODBC.
Re: Need help regarding oracle database gateway for ODBC [message #653254 is a reply to message #653253] Thu, 30 June 2016 05:56 Go to previous messageGo to next message
chintan.patel
Messages: 147
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

Re: Need help regarding oracle database gateway for ODBC [message #653256 is a reply to message #653249] Thu, 30 June 2016 06:12 Go to previous message
EdStevens
Messages: 848
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
Previous Topic: SSIS package creation
Next Topic: TNS-12541 TNS no listener issue
Goto Forum:
  


Current Time: Tue Nov 21 02:15:49 CST 2017

Total time taken to generate the page: 0.02230 seconds