Which Oracle software should I buy? [message #89001] |
Thu, 24 July 2003 10:10 |
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 |
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 #89012 is a reply to message #89001] |
Tue, 29 July 2003 09:36 |
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 |
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
|
|
|