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.
⋅ 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
⋅ 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.
⋅ 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
⋅ 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
