How can i configure Oracle db with FLEXMONSTER-PIVOT-21-TRIAL-PREMIUM-HTML5 tool ?


I have downloaded and extracted it. Can somebody help how can i create a simple report using oracle db?
If possible can you provide any document for the same.


3 answers

Ian Sadovy Staff November 19, 2015

Hello Vivek, 
Thank you for your request. Sure, please check these links to the documentation about connecting to different data bases and to Oracle in precise. 
1. General information about generating CSV output to enable real-time business analysis  
2. How to connect to a data base
3. How to define your data source 
Please let me know if it works for you. 

vmishra November 19, 2015

Hi Ian,
Actaully i am unable to create the report. Which file i have to open to create a new report and how can we connect with oracle db?
Please provide exact steps to create a new report and for connecting with oracle db.Your help will be greatly appreciated.

Ian Sadovy Staff November 19, 2015

Fisrt of all, Flexmonster Component doesn’t support DIRECT connection to Oracle db because of security (it requires storing all credentials, username and password on the client side). So, there is one additional step to do.   
Step 1. Create a proxy-script to get necessary data from Oracle DB in CSV format. 
In a result there should be some URL (i.e. that returns a CSV string.
Unfortunately, we do not have a sample exactly for Oracle, but it should be similar to the sample with MySQL.
Step 2. Create XML report.
Create empty XML file and name it “report.xml”. Minimal report looks like this:

  <dataSource type="csv">

More about configuring report is here:
Step 3. Initialize Flexmonster Component and load XML report.
Insert the following code on the HTML page:

<div id="pivotContainer">The component will appear within this DIV.</div> 
<script type="text/javascript" src="flexmonster/flexmonster.js"></script>
<script type="text/javascript">
    var params = {configUrl : "report.xml"};
    flexmonster.embedPivotComponent("flexmonster/", "pivotContainer","100%", "500", params, "html5", true);

That’s all. Put all the necessary files on the web server and navigate to the HTML page. Now you should see your data.
Please contact me if you have any other questions.

Please login or Register to Submit Answer