I would like to have a more detailed answer to my previous question about the Oracle Transparent Gateways for Informix 7.3. If we don't have any systems in Oracle 8i but have only Informix 7.3. Do we need to create the parallel dummy schema in Oracle which will provide a skeleton to the existing system in Informix 7.3 to facilitate the benefits of accessing the Oracle environment features? I would be glad if you could suggest the actual solution to this, i.e., how exactly should we go about using the Gateways when we don't have any existing system in Oracle and have only Informix 7.3 which needs to be migrated to Oracle 8i. How do we go about using the Gateways in practice and whether it would yield the desired results even if the databases are local or remote and reside on different servers?
I think that the Oracle documentation can answer every one of your questions. And it will do a much better job than I can. There is just too much information to relay in this response to do an adequate job. Please read the Oracle docs. Specifically, you want to read the Oracle 8i Distributed Database Systems guide. You can obtain a copy on Oracle Technet. The section entitled Part III Heterogeneous Services Concepts and Administration covers this in explicit detail. It goes through the architecture, configuration, and management of Transparent Gateways.
With two Oracle database, one can define a "database link" between the two systems. You can query the remote database across the database link. This is accomplished quite easily since the two databases are Oracle systems, i.e., homogeneous systems. But you want to connect to a non-Oracle database. This means that you have two different vendor's systems, i.e., heterogeneous systems. In order to connect to a non-Oracle database, you need an ODBC driver for that database. You still create a database link, but it is a link to an ODBC defined database. Your queries and applications are coded just like any other distributed database system (Oracle or not).
I can't stress enough that reading the documentation would be of the biggest benefit here. If you have specific questions after reading that, then I will be more than happy to answer them.
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle gurus are waiting to answer your toughest questions.
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.