Re: Loading External ODBC Data Source to Oracle Table via PL/SQL

Sergey Adamenko wrote:

> You can use Heterogeneous Services to access an ODBC source directly from
> SQL or PL/SQL.
> With the service configured you can issue:
> CREATE TABLE DATA_FROM_ODBC
> SELECT * FROM CUSTOMER_at_non_oracle_system;

Oracle's Transparent Gateways are "nice" - an alternative when there are no other choices. But there are many problems and issues related to using OTG.

If the requirement is to load data (and not integrate different data sources), it is much easier (and very much less expensive) to use something like SQL*Loader, than to purchase, install and configure an OTG.

If you really want a "drop and drag" data load solution than you can put together in a few minutes, then Delphi can do it. There are batchload/batchmove Visual Component Classes and heterogenous SQL support embedded in BDE (Borland's Database Engine).

--
Billy