Home » Developer & Programmer » Reports & Discoverer » Which Oracle software should I buy?
Which Oracle software should I buy? [message #89001] Thu, 24 July 2003 10:10 Go to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
Hello,
I will be starting a new job, and the company that I
will be working for needs to know which software to
purchase now. I will be writing very complex reports
for an insurance company on an Oracle 9i database.
That is all I know right now. Which software do I need
to buy? All my company has is the Oracle DB itself and
nothing else as far as I know. I will end up being the
DBA as well, so I will need everything.

I am guessing that I would need:
- SQL
- SQL Plus
- Oracle Reports
- Oracle Discoverer (would this be better than Oracle
Reports?)
- TOAD or SQL Navigator (I used these before and really liked TOAD)
- Oracle Designer (at my last job, the DBA there used
Oracle Designer and using this he could print out the
whole database layout graphically showing the tables
and fields and relationships between tables)
- DBA Studio (not sure about this - someone mentioned
it me)

Anything else and which versions? I haven't worked in
Oracle in a long time so I don't know the latest
versions or software.

Thank you in advance,
Susan
Re: Which Oracle software should I buy? [message #89004 is a reply to message #89001] Thu, 24 July 2003 14:04 Go to previous messageGo to next message
r_steve
Messages: 1
Registered: July 2003
Junior Member
Hi Susan,
Would suggest you to go for an Oracle iDS and an Oracle 9iAS....

Some of the install option available with Oracle9i Developer Suite Release 2 install options:

Business Intelligence
·Oracle9i Discoverer Administrator
·Oracle9i Discoverer Desktop
·Oracle9i Reports Developer
·Oracle9i Warehouse Builder
·Oracle9iAS Containers for J2EE (OC4J)
Rapid Application Development
·Oracle9i Designer
·Oracle9i Forms Developer
·Oracle9i JDeveloper
·Oracle9i Reports Developer

The 9iAS ENTERPRISE EDITION contains
· Oracle HTTP Server
· Oracle9iAS Containers for J2EE
· Oralce9i JDeveloper
· Oracle9iAS TopLink
· Oracle PL/SQL Server Pages
· Oracle9iAS Portal
· Oracle9iAS Single Sign-On
· Oracle9iAS Web Cache
· Oracle9iAS Forms Services
· Oracle9iAS Reports Services
· Oracle9iAS Discoverer

We have recently got them intalled in our company.
They are working wonderfully well...
Mail me in case you need any more information about any particular component or need some installation support....
Re: Which Oracle software should I buy? [message #89006 is a reply to message #89004] Thu, 24 July 2003 14:16 Go to previous messageGo to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
Why would I need 91AS?
Thank you.
Whoops, I meant 9iAS [message #89007 is a reply to message #89006] Thu, 24 July 2003 14:18 Go to previous messageGo to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
.
Re: Which Oracle software should I buy? [message #89012 is a reply to message #89001] Tue, 29 July 2003 09:36 Go to previous messageGo to next message
dyc
Messages: 1
Registered: July 2003
Junior Member
Susan,

Do you want to build web based reports or just internal reports. For web-based reports, I suggest you go for reports builder 9i and to host these reports you would need 9iAS.

But if you are just looking at building reports internally as in an client/server architecture, I suggest you go for reports builder 6i. You can even build internal reports with 9i.

For both you would need to buy the Internet developer Suite.
You can go for the latest version ensuring it will be supported for longer.

I can send you some documentation for iDS , 9iAS. Just let me know what you want.

Cheers!
Re: Which Oracle software should I buy? [message #89037 is a reply to message #89012] Wed, 06 August 2003 13:39 Go to previous message
Jadie
Messages: 64
Registered: January 2002
Member
I started a DBA job recently too. I need to produce some regular (not complicated) reports for the users. We run Oracle 9i databases. The users have some requirement about the reports:

1. Automatically produces the weekly/monthly reports at off-peak time.
2. Users can customize some specific reports by themselves, for example, about the monthly reports, users want to produce the report about transactions processed in June but not August.

What tool should I choose? Thanks..

Jadie
Previous Topic: convert rep back to rdf
Next Topic: rep-1247
Goto Forum:
  


Current Time: Tue Dec 17 21:29:30 CST 2024