Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question to oracle products newest version?
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
>
Received on Fri Jan 10 2003 - 03:33:33 CST