Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.

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

Answered
Vivekanand asked on November 19, 2015

I have downloaded FLEXMONSTER-PIVOT-21-TRIAL-PREMIUM-HTML5.zip 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.

Thanks.

4 answers

Public
Ian Sadovy Ian Sadovy Flexmonster November 19, 2015

Hello Vivek, 
 
Thank you for your request. Sure, please check this link to the documentation about connecting to different data bases and to Oracle in precise: https://www.flexmonster.com/doc/connect-to-relational-database/.
Please let me know if it works for you. 
 
Regards,
Ian

Public
Vivekanand 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.

Public
Ian Sadovy Ian Sadovy Flexmonster November 19, 2015

Vivek,
 
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. http://mysite.com/api/getData) 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:

<config>
  <dataSource type="csv">
    <filename>http://mysite.com/api/getData</filename>
  </dataSource>
</config>

More about configuring report is here: https://www.flexmonster.com/doc/available-tutorials-report/
 
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);
</script>

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.
 
Regards,
Ian

Public
Tanya Gryshko Tanya Gryshko Flexmonster December 12, 2016

Hello Vivek and all Flexmonster users,
We would like to provide you with detailed tutorials for connecting to Oracle DB and other relational databases: http://www.flexmonster.com/doc/connecting-to-relational-database/.
Regards,
Tanya

Please login or Register to Submit Answer