asked on June 14, 2023
Dear Flexmonster-Team,
I am a student in Germany and I am working on a project where i need to integrate flexmonster into an already running application. In this application the user should be able to generate reports of a lot of oracle data. Flexmonster is already integrated in the application but right now i need to connect the Oracle data with Flexmonster. So my question is how do I connect Flexmonster with Oracle data? Can you give a step by step guidance? I would really appreciate your effort.
Best regards
Hakan
⋅ June 15, 2023
Hello, Hakan!
Thank you for reaching out to us.
It is possible to connect to an Oracle database using Flexmonster Data Server — a special server-side tool developed by Flexmonster. It is responsible for fetching data from a data source, processing and aggregating it. Then the data is passed to Flexmonster Pivot in a ready-to-show format.
You can find the detailed instruction on how to connect Flexmonster to an Oracle database in our guide: https://www.flexmonster.com/doc/connect-to-oracle-database/
Feel free to contact us if further assistance is needed.
Best Regards,
Maksym
⋅ June 15, 2023
Hello Maksym!
Thanks for your help, when I execute "flexmonster add fds -r" to install the data server then the following error message appear:
~ Flexmonster Data Server service is already installed
Preparing to update Flexmonster Data Server
--- UPDATE ---
√ Download Flexmonster Data Server — 100%
√ Unpack files to this folder
√ Uninstall previous Flexmonster Data Server service version
√ Update Flexmonster Data Server service
× Update Flexmonster Admin Panel (the service GUI tool)
→ Flexmonster Admin Panel failed with code 1
Flexmonster Admin Panel failed with code 1
what am i supposed to do right now? The admin panel cannot be opened. Thanks for your help.
Best Regards
Hakan
⋅ June 16, 2023
Hello, Hakan!
Thank you for reporting this issue.
Our team could not reproduce this behavior with the latest version of Flexmonster CLI. Based on provided logs, the command performs an update, meaning that the FDS had already been installed. In such a case, we recommend manually uninstalling the FDS and running the command.
Also, we would like to know which OS you are using, as it may help us to provide more accurate advice.
Looking forward to hearing your reply.
Best Regards,
Maksym
⋅ June 19, 2023
Hello Maksym,
I am using Windows 10 Pro as OS (64 bit). When I am trying to open the Admin Panel then following error message appears: This App cannont run on your computer. Contact the software publisher to find a suitable version for your computer.
Best regards
⋅ June 19, 2023
Hello, Hakan!
Thank you for sharing this information with us.
We suppose that the problem can be related to Flexmonster CLI. We recommend downloading the Flexmonster Data Server as a ZIP archive and installing it manually.
Please let us know if installing FDS from ZIP works for you.
Best Regards,
Maksym
⋅ June 20, 2023
Hello Maksym!
Thank you for your help. Installing FDS from the ZIP you have sent works! I dont know why but it works. My next question is I have around 50 Oracle Tables and is there any way to create the indexes for all 50 Oracle tables at one in admin panel without creating it for each table? Thanks four help
Best Regards
Hakan
⋅ June 21, 2023
Hello, Hakan!
Thank you for your reply. We are glad that installing FDS from the ZIP worked for you.
Currently, Flexmonster Data Server supports creating a separate index per each SELECT request. In case you need to show 50 tables, creating 50 indexes for each of them is the only option. Such an approach provides better control over data loading, which introduces several benefits. For example, you can filter out certain columns on rows in a connection query. Also, the refresh time can be individually set for each index.
As an alternative to manually adding each index, you could implement the script that generates the JSON config file with indexes per each table. The file is saved in the following directory: C:/ProgramData/FlexmonsterDataServer/flexmonster-config.json. You can create one index manually and use it as a reference for the script, which would generate other indexes and save them in flexmonster-config.json.
Please let us know if more questions arise.
Best Regards,
Maksym
⋅ July 18, 2023
Hello, Hakan!
Hope you are doing well.
We would like to know if you had time to implement the suggested approach with a server-side script for creating indexes in the config file.
Please let us know if it worked for you.
Best Regards,
Maksym
⋅ July 18, 2023
Hello Maksym,
I successfully implemented Flexmonster into my application. Thanks for your help and for the fast replies.
Best regards
Hakan
