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.
- Enter the following information in the â€œmysql_dashboard.phpâ€? as shown in this PDF
- 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