The following steps are explained to install dashboard on server for MySQL database. The steps are the same for any other database like Oracle, SQL server, MS Access, DB2 etc with few noted exceptions.
- First download InfoCaptor Dashboard Designer on your PC or laptop
- Create your Dashboard and for example, let us name the dashboard file as “my_dashboard.icv” (all InfoCaptor dashboard files have .icv extension)
- Since we are going to place the dashboard files on the server, it is recommended that all the names are lowercase and there are no blanks in the name (replace blanks with underscore ‘_’)
- Let us assume the following
- Your domain is http://www.yourdomain.com
- You will place all the dashboard files in the directory “/dashboards”
- Your dashboard file is “my_dashboard.icv”
- Your database host is located at “mycompany.server.com” ( This maps to the yellow highlight in the connection window).If the database is on your own PC or machine then you may use “localhost” as shown below
- Your database port is “3306” (green highlight)
- Your database name is “test” (blue highlight)
- Your database user name is “some_user”
- Your database password is “some_password”
- All dashboards are accessed through a configuration file that will reside on the web-server. This file has a .PHP extension so your web-server should be able to launch PHP files.
- So your final launch URL will be
Here are the preparation steps to get the above URL working.
- Get the latest infocaptor_mysql_webstart.jar file (http://www.infocaptor.com/files/infocaptor_mysql_webstart.jar)
- This jar file is different for each database as this jar file is packaged with the appropriate database drivers. If you need to connect multiple databases using the same jar file then a common fat jar file can be created. Please contact us at (firstname.lastname@example.org or email@example.com) to get the appropriate jar files.
- copy the file to the http://www.yourdomain.com/dashboards directory
- copy your dashboard definition file “my_dashboard.icv” to the same /dashboards directory
- Now create a new PHP file in any text editor and call the file “mysql_dashboard.php” or anything that you want.
- Now save your “mysql_dashboard.php” and ftp it to your webserver in the /dashboards directory
- Verify that the following files are in the http://www.yourdomain.com/dashboards/ directory
Now you can launch your dashboard by typing the following in the browser URL http://www.yourdomain.com/dashboards/mysql_dashboard.php
Please email us if you need assistance in setting up for other databases like Oracle, DB2, SQL Server, MS Access, Sybase, PostgreSQL etc
About the Author
Nilesh Jethwa has been working in the ERP and Business Intelligence field for past 10 yrs. He has had the privilege of working with Fortune clients. He was working as an Application and Business Intelligence consultant for Oracle Corporation. Since quitting Oracle he has been focusing and working on his company and InfoCaptor. He can be tracked at his blog where he shares his experiences, news, tips and tricks.
No comments have been posted yet.