Displaying Oracle data on a web-page (internal dashboard type thing) Displaying Oracle data on a web-page (internal dashboard type thing)
Page 1 of 2 12 LastLast
Posts 1 to 10 of 12
  1. #1

    My post count is Majestic

    d000hg's Avatar
    Join Date
    Dec 2007
    Location
    My house
    Posts
    33,053

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

    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?
    Quote Originally Posted by MaryPoppins View Post
    I'd still not breastfeed a nazi
    Quote Originally Posted by vetran View Post
    Urine is quite nourishing

  2. #2

    bored now

    eek's Avatar
    Join Date
    Jun 2010
    Location
    😂
    Posts
    25,719

    Default

    Quote Originally Posted by d000hg View Post
    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...
    merely at clientco for the entertainment

  3. #3

    My post count is Majestic

    d000hg's Avatar
    Join Date
    Dec 2007
    Location
    My house
    Posts
    33,053

    Default

    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.
    Quote Originally Posted by MaryPoppins View Post
    I'd still not breastfeed a nazi
    Quote Originally Posted by vetran View Post
    Urine is quite nourishing

  4. #4

    bored now

    eek's Avatar
    Join Date
    Jun 2010
    Location
    😂
    Posts
    25,719

    Default

    Quote Originally Posted by d000hg View Post
    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..
    merely at clientco for the entertainment

  5. #5

    TPAFKAk2p2

    mudskipper's Avatar
    Join Date
    Sep 2009
    Location
    Null island
    Posts
    26,210

    Default

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

  6. #6

    TykeLike

    SimonMac's Avatar
    Join Date
    Aug 2010
    Location
    God's Own Republic Of Yorkshire
    Posts
    24,146

    Default

    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.
    “Live a good life. If there are gods and they are just, then they will not care how devout you have been, but will welcome you based on the virtues you have lived by. If there are gods, but unjust, then you should not want to worship them. If there are no gods, then you will be gone, but will have lived a noble life that will live on in the memories of your loved ones.”

    ― Marcus Aurelius

  7. #7

    More time posting than coding

    darrylmg's Avatar
    Join Date
    Sep 2012
    Location
    UK - South West
    Posts
    283

    Default

    Quote Originally Posted by d000hg View Post
    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.
    Don't believe it, until you see it!

  8. #8

    Should post faster


    Join Date
    Aug 2016
    Posts
    139

    Default

    Quote Originally Posted by mudskipper View Post
    Pretty sure Power BI works with Oracle - should give you all the pretty pictures you need.
    At a cost though

  9. #9

    More time posting than coding


    Join Date
    Feb 2020
    Posts
    448

    Default

    Quote Originally Posted by madame SasGuru View Post
    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.

  10. #10

    bored now

    eek's Avatar
    Join Date
    Jun 2010
    Location
    😂
    Posts
    25,719

    Default

    Quote Originally Posted by jayn200 View Post
    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....
    merely at clientco for the entertainment

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •