0 Replies Latest reply: Jul 17, 2013 4:29 PM by cp29plus RSS

    Reading XML from Oracle directory to generate charts

    cp29plus

      Hi,

       

      I have a requirement create graphs, charts and maps based on data from a data warehouse (dw).  As I see things, there are two possibilities:

       

      • Graphs, charts and maps based on an XML file
      • Graphs, charts and maps based on Oracle tables

       

      Both would contain small data sets that will allow for quick response.  The intent of these graphs, charts and maps is to generate a dashboard that would allow the user to quickly drill down to the desired warehouse data.

       

      The proof of concept has already been validated using the Oracle table scenario.  My question is whether or not this could be accomplished reading xml files for generating the same set of dashboard items?

       

      My Oracle database and APEX environments configuration are as follows:

       

      NLSRTL                 11.2.0.1.0                                                           Production
      Oracle Database 11g Enterprise Edition 11.2.0.1.0                         64bit Production
      PL/SQL 11.2.0.1.0                                                                            Production
      TNS for Solaris: 11.2.0.1.0                                                               Production

      Application Express 4.2.2.00.11

      APEX Listener Release 2.0.2.  / Tomcat

       

      An Oracle database directory has been setup and is accessible to our APEX application.

       

      Any suggestions/help is appreciated.

       

      Thanks,

       

      Charles