You can have a link between Oracle and virtually any other database. To do this, you will need to implement Oracle's Heterogenous Services (HS). This is sometimes called Transparent Gateways as well. Once implemented, you can create a database link to a non-Oracle database. There are specific HS implementations for some of the top RDMBS platforms, i.e. SQL Server and DB2. But there is also a generic implementation for ODBC which just requires you to have an ODBC driver to connect to that database. Once set up, the non-Oracle database appears on the database link just as if it were an Oracle database. Please read the Oracle documenation on setting up and configuring HS. You can find a copy here:
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.