Displaying Oracle data on a web-page (internal dashboard type thing)

[d000hg]

Our project has no real web presence currently but a dash-board has been requested and browser seems the way to go. Pretty simple, displaying some metrics about system performance.

I am guessing it would effectively be running some saved queries against our Oracle 19 DB. I've never worked on this sort of DB reporting thing on Oracle but it seems like the sort of thing I shouldn't be having to write bare code. If I can avoid writing HTML in 2020 I will be very pleased

Any recommendations on search terms or whatever?

[eek]

Our project has no real web presence currently but a dash-board has been requested and browser seems the way to go. Pretty simple, displaying some metrics about system performance.

I am guessing it would effectively be running some saved queries against our Oracle 19 DB. I've never worked on this sort of DB reporting thing on Oracle but it seems like the sort of thing I shouldn't be having to write bare code. If I can avoid writing HTML in 2020 I will be very pleased

Any recommendations on search terms or whatever?

You would have thought so but oracle is still rubbish at this sort of thing - time to start crafting some hand written code...

[d000hg]

Does Oracle even have saved queries and reports, or is it a case of just writing stored procedures - I can bung that into an ASP.net page I suppose. Yuck.

[eek]

Does Oracle even have saved queries and reports, or is it a case of just writing stored procedures - I can bung that into an ASP.net page I suppose. Yuck.

Stored procedures would be my approach - you don't really want extra ports on an oracle software product - there will be security holes glory..

[mudskipper]

Pretty sure Power BI works with Oracle - should give you all the pretty pictures you need.

[SimonMac]

If you want to do this on the cheap, you can do it with the free version of SPLUNK, you will need to set up the ODBC when you are trialing the paid version but once it's configured up and set to import there will be no need to change it.

[darrylmg]

Our project has no real web presence currently but a dash-board has been requested and browser seems the way to go. Pretty simple, displaying some metrics about system performance.

I am guessing it would effectively be running some saved queries against our Oracle 19 DB. I've never worked on this sort of DB reporting thing on Oracle but it seems like the sort of thing I shouldn't be having to write bare code. If I can avoid writing HTML in 2020 I will be very pleased

Any recommendations on search terms or whatever?

System performance of the Oracle DB ?
Oracle Grid Control was a thing. Not sure if it still exists.

If just Web reporting of queries from an Oracle DB then Oracle Apex could help. Pretty friendly to use. Again quite old tech.

Maybe Quest have a Toad plug in that can generate HTML easily.

[madame SasGuru]

Pretty sure Power BI works with Oracle - should give you all the pretty pictures you need.

At a cost though

[jayn200]

At a cost though

There is a free version and it does support publishing to the web but I have not used that functionality on free version so not sure what limitations there are if any.

Might be worth playing around with it a little bit.

I would really avoid writing something yourself as there are plenty of good dashboard tools out there.

You can always build something relatively simple with limited function in free power bi that some key users can get benefit out of. Once this has been done, then it's a much easier sell to move them onto the paid version and get full functionality down the road.

[eek]

There is a free version and it does support publishing to the web but I have not used that functionality on free version so not sure what limitations there are if any.

Might be worth playing around with it a little bit.

I would really avoid writing something yourself as there are plenty of good dashboard tools out there.

You can always build something relatively simple with limited function in free power bi that some key users can get benefit out of. Once this has been done, then it's a much easier sell to move them onto the paid version and get full functionality down the road.

The first cost I was thinking of is giving external internet access to an oracle database as I suspect the database isn't in Azure cloud....