Re: Question to oracle products newest version?

Eder Fred wrote:

> Hi Daniel!
>
> you wrote:
>
> > The only things ODBC will get you are bad performance, lousy stability,
> and
> > a security hole big enough for a hacker to waltz through.
>
> my problem is that I get the tables of my production database only with
> odbc. That is a Navision Attain database. This is a Navision proprietary
> database format.
> Is that automatic import with odbc also with oracle possible.
>
> Thanks!
>
> "DA Morgan" <damorgan_at_exesolutions.com> schrieb im Newsbeitrag
> news:3E1DAA96.4C42C84A_at_exesolutions.com...
> > Eder Fred wrote:
> >
> > > Hi!
> > >
> > > which products from oracle need I for the following wishes:
> > >
> > > I want daily make an import from my production database tables with odbc
> > > into oracle. On the following days should that import run automatically.
> > > Table rows should be deleted and filled automatically.
> > >
> > > which oracle product (tool) need I for that?
> > >
> > > I want then make a relational database with oracle - having the same
> > > relational structure as my production database.
> > >
> > > which oracle product (tool) need I for that?
> > >
> > > Then I want to build on this oracle database a datawarehouse. With
> cubes,
> > > dimensions.
> > >
> > > which oracle product (tool) need I for that?
> > >
> > > The client users should get a tool to browse my cubes
> > >
> > > which oracle product (tool) need I for my users ?
> > >
> > > Thanks!
> > >
> > > Danke
> >
> > Oracle 9.2 standard edition will do everything you wish. But I would drop
> > the ODBC thing and look at using SQL*Loader.
> >
> > The only things ODBC will get you are bad performance, lousy stability,
> and
> > a security hole big enough for a hacker to waltz through.
> >
> > Daniel Morgan
> >

Can't speak to that product. But any database should allow you to dump as a delimited or fixed-length ASCII file.

If it doesn't I'd chuck it into the dustbin.

Daniel Morgan Received on Fri Jan 10 2003 - 10:43:55 CST