Re: The right tool for the job
Date: Thu, 25 Jun 2009 15:44:47 -0600
Robert Klemme wrote:
> On 25.06.2009 18:34, Lee wrote:
>> But how do I get the graph? Export the data as csv and import into an >> Excel sheet? OK, that would work, but shouldnt there be a slicker way >> to fly?
> You can query the data directly from Excel via Oracle's ODBC driver. You
> can even make Excel update the data whenever the sheet is opened AFAIK.
D'oh! Of course I can. in the past, I had used OraExcel, but in those days it was a bit cheaper. Now they want about 160 euros for the latest version (I'd be paying in dollars, ouch!). OraExcel now called SQL*XL is very slick...it has a very nice user interface and is very easy to use, but I cant see plonking out all that change when all I need is one table's worth read into the Excel sheet so as to produce a standard graph.
On the other hand, that sort of expense hardly breaks the corporate bank. What would they (the corporate sponsors) budget for each day of developer time?
> Other than that there are also plotting packages around which can be
> used to generate graphs. For example, you can write a perl / ruby /
> phyton / your favorite scripting language with database support which
> extracts the data and prepares it for graphing.
> You can also write SVG easily as it's XML. Plenty of options...
That bears looking into as well. For a standard graph its probably going to be cheaper and easier to use Excel, but I suppose there's something to be said for delivery over the web. I suppose the client side browser needs some sort of special plug in to render the SVG?
Thanx. Received on Thu Jun 25 2009 - 16:44:47 CDT