Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to exchange data with Oracle?

Re: How to exchange data with Oracle?

From: Terry Dykstra <dontreply_tdykstra_at_cfol.ab.ca>
Date: Mon, 10 Sep 2001 14:35:57 GMT
Message-ID: <hd4n7.18990$C57.2715229@news1.telusplanet.net>


Another easy way to move data between 2 databases is Sybase Infomaker. It's a reporting tool, but comes with a data pipeline utility. It has native drivers for Oracle and supports ODBC & OLEDB as well.

--
Terry Dykstra
Canadian Forest Oil Ltd.
"Pete Finnigan" <pete_at_peterfinnigan.demon.co.uk> wrote in message
news:7YU7+VAZ$Hn7Ew6U_at_peterfinnigan.demon.co.uk...

> 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
Received on Mon Sep 10 2001 - 09:35:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US