• Votes for this article 6 people voted for this
  • Dashboard Insight Newsletter Sign Up

How to Deploy Dashboards on the Web – Server or Intranet
A Step-by-Step Guide

by Nilesh Jethwa, Founder, InfoCaptorMonday, December 17, 2007

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
  • http://www.yourdomain.com/dashboards/mysql_dashboard.php

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 (contact@infocaptor.com or infocaptor@gmail.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
  • mysql_dashboard.php
  • my_dashboard.icv
  • infocaptor_mysql_webstart.jar

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.


Tweet article    Stumble article    Digg article    Buzz article    Delicious bookmark      Dashboard Insight RSS Feed
 
Other articles by this author

Discussion:

No comments have been posted yet.

Site Map | Contribute | Privacy Policy | Contact Us | Dashboard Insight © 2017