Re: Creating Graphs from Oracle Database.

Aside from all of the other fine answers given, I thought that I would add the following, FREE solution! That's right it's free! Just step right up and take it!!!!

I just implemented this very solution using Perl, CGI, DBI, and Perl's Chart module. You can then run this on any web server which will handle CGI. They all do, but you might need to make some configuration changes. If you want a great free web server, get Apache!

In a nutshell, Perl is the scripting language that performs all of the logic. After you've installed Perl, install the CGI module. This module lets you write programs that displays web pages. Then install the DBI module. This is the database interface module which lets your Perl program talk to a database. Before the DBI module can connect, you will need to load your vendor specific database driver (DBD) module as well. Then load the Chart module. This lets you take data points and produce some pretty good charts. You can have your Perl program automatically render the chart to the browser.

While this method may not have all the bells and whistles of expensive products like Oracle Developer, it is a tried and true method that works great!!!!!

HTH,
Brian

> Anurag Minocha wrote:
>
> Hi,
>
> Right now we use Excel to connect to Oracle and then create the graphs
> which we store as Images and then finally saved to be displayed on our
> web site.
>
> This whole process is manual and consumes a lot of time and has to be
> done daily.
> Is there any tool which automates this and the graph automatically
> gets updated on the web site.
>
> Our database is Oracle 8.0.5 and we are using OAS 4.0.8.
>
> Please suggest.
>
> Thanks
> Anurag
>
> -- Posted from jshemail.herold.com [63.105.8.12] via Mailgate.ORG
> Server - http://www.Mailgate.ORG
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================