Discussion Locked

Oracle Database

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to find software that will allow multiple users to easily pull data from an Oracle database into a report. Does anyone have any suggestions?

7 replies

by darren.marynchak

Assuming the platform/version of your Oracle Database is multi-user (Personal Oracle / PO lite are not multi-user to the best of my knowledge), this is pretty easy to do. So, now assuming that we have a platform that allows multiple concurrent sessions, the next question is where do you want to write this report? Oracle native connectivity software is SQL*Net (Net80) and the 'native' report writer would probably be SQL*Plus. So, your users could all hit the database (assuming they have network connectivity to that database) using SQL*Plus via Net80.

Another alternative is to use ODBC for connectivity and some OBDC compliant app (MS Access) as the report writer.

Hope that helps...

by rob wolfe

The question is a tiny bit vague but just about any decent reporting tool: crystal reports, access, any of the Cognos Products, even Excel if that is what suits your requirements can do the job. Al you need is to make sure that you have the Oracle ODBC driver installed and the NET80 bit so that Oracle can talk to ODBC.

Another option, if you are using Oracle 8i you can "publish" your data directly to the web and folks can look at it directly off their web browsers. Requires someone with a clue to set up but once set up is relatively stressfree. (Personally I recommend this one)

happy Oracling

by tech

You could try looking at Advanced Query Tool at www.cardett.co.nz. This is easy to use and works well with Oracle.
Like many Windows-based products you must first install the ODBC driver and configure a connection to your database.

This discussion is closed to new replies.