Transparent Gateway or Gerneric Conectivity

[CHUMPY]

Hi,

I need to be able to import data through an automated process from a non-oracle system.

I have found two possible ways of doing this using either of the following Oracle technologies Transparent Gateway or Gerneric Conectivity.

Does anybody have any experience of using either of these and any recommendations?

I don't have that many details of the non-oracle system apart from it will be ODBC compatable and possibly an Access database.

Any information would be much appreciated.

Thanks Gareth

 

[markrem]

Oracle Transparent Gateways are special / proprietary drivers for non-Oracle data sources, like DB2. It makes the non-Oracle system appear as another Oracle system. ODBC can't do that; ODBC provides generic features.

Generic Connectivity is the ODBC driver you get free with Oracle. If your non-Oracle database supports ODBC, then you can use it. However, just because it's supported does not mean it's the best choice. If there is both an ODBC and Oracle Transparent Gateway driver for the same non-Oracle system, then the Transparent Gateway will provide additional support not found in the ODBC drivers.

-Mark

9i OCP

 

[CHUMPY]

Thanks for the info. I will probably plump for the ODBC as all I require are reasonable straight forward selects and the performance seems to be acceptable in the tests I have run.

Though did have a little trouble getting it working over a WAN until I discovered you need to set up user accountants so Oracle can log onto the machine containing the target dataabase.

Thanks

Gareth