Heterogeneous services

Topics about Databases, Backups, Tuning, Architecture, Systems Management, etc etc.

Post Reply
bgrenn
Posts: 91
Joined: Mon Mar 16, 2009 11:47 am
Location: Rochester, NY
Contact:

Heterogeneous services

Post by bgrenn »

First, many of you are probably asking "what is heterogenous services" ?  Well, simply put, it is  way of connecting your Oracle database to another non-oracle datbase through a database link.. An example of this is to create a database link to SQL Server to pull data, or push data.  This piece of Oracle is free with you Enterprise license, but requires an ODBC driver compatable with the Database OS..  If you are running on Linux, you need a Linux ODBC driver for SQL-Server.

That said...

This has always the "black magic" piece of Oracle and it remains so.. It's always exciting when you first connect to a non-oracle database (like sqlserver) through a database link, but wow what a pain getting there !!  The lesson I learned for today on this is... HSODBC is still 32 bit.  You need a 32 bit driver, and you need to have the 32 libraries in your LD_LIBRARY_PATH to get the silly thing working.. the documentation "skips" this part.
Post Reply