Re: How to exchange data with Oracle?

Hi

I once used MS Access as a middle layer for a data migration from IBM AIX Oracle 8.0.5 - MS Access then to a database ( sorry cannot remember the name) on an AS400. I created views in Oracle giving the same shape of tables as in the AS400. Then created two ODBC connections from MS Access. Then created select into's in MS Access and read straight from the views in Oracle to the AS400. Access ran on a 500Mhz Dell, and the preformance of the whole thing suprised me so we went with it for the full data migration.

This was a simple solution for a data migration, it may help you do do similar.

I have also looked at very expensive tools such as Prism and something junction a few years ago for a different company. They were good but took very expensive amounts of consultancy to set up.

hope this helps

cheers

Pete Finnigan
www.pentest-limited.com

In article <3b9a2689.8208894_at_news>, Nuno Souto <nsouto_at_optushome.com.au. nospam> writes
>On Sat, 08 Sep 2001 22:08:29 +0800, Dino Hsu
><dino1.nospam_at_ms1.hinet.net> wrote:
>
>>middle. Tools such as Microsoft Access/Excel or Cognos Impromptu can
>>be easiy exchanged with many different data formats. Anyone shares
>>one's experience about exchanging data with Oracle? Thanks in advance.
>>
>
>Use ODBC or the other one, can't remember the name, Objects for OLE?
>They let you pump data in/out of ORACLE into any compatible product.
>I've even had Lotus Notes reading/writing off the DB directly.
>
>Cheers
>Nuno Souto
>nsouto_at_optushome.com.au.nospam

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com