Re: Non-Oracle host data into Oracle

I've done this in the past with Pro*C programs and ftp (to get the data file). The nice thing about the Pro*C approach is that you can connect to the db once and stay connected. This saves a lot of cpu wastage of constantly spawning processes on your UNIX server every 60 seconds - just let the process loop with a 'sleep' call to do the waiting between file arrivals. You can use the 'array insert' features to further improve performance.

If you feel a little more adventurous, try writing it as a real-time link (no files) using sockets. I've only ever done this Micro$oft to UNIX, so you'll have to look at what AS400 provides in terms of TCP/IP socket functionality.

Short of that, look at another gateway product rather than the Oracle stuff, or maybe try something over ODBC.

Steve Phelan.

Don wrote:

> If we elect not to use one of the Oracle SQL*NET based host
> connectivity options, is there any other way to get data into Oracle
> other than via SQL*LOADER?
>
> The requirement is for a real time interface to an AS/400 application,
> but Mr. Moneybags does not want top spend the $18,000 for the
> Transparent Gateway. Oracle is running on a SUN box.
>
> It looks like I'm going to be stuck with a flat file transfer from the
> AS/400 and then a cron job that will fire off the SQL*LOADER every 60
> seconds.
>
> Other ideas are certainly welcome!
>
> Don
Received on Sun Jul 12 1998 - 06:45:06 CDT