Can I use a Stored Procedure with MySQL?
Use this workaround at your own risk. If there are any problems, it is not officially supported by iDashboards and we cannot assist if there are any issues.
As this feature is not requested often it does not come prepackaged inside of the iDashboards Enterprise Suite. To enable this feature it will require server access, with the necessary privileges to adjust the ivizgroup.properties file.
Note: Be sure you choose the correct version for your version of iDashboards.
Steps to enable this ability are:
1) Stop the Tomcat/iDashboards Service.
2) To enable this feature you will first need to add the following to the ivizgroup.properties file.
#MySQL Stored Proc
3) Then you will need to take the .jar file from the attached zip directory and add it to the drivers folder inside of the IVIZGROUP.HOME path.
4) Start the Tomcat/iDashboards Service.
- X Platform
- Enterprise Suite