Caxpy

A Simple Data Visualization Software

Caxpy

Caxpy Features

D3 Based Charts

Area, Line, Column, Radar, Pie , Doughnut, Bubble Chart, Scatter plot and Chord Layout chart. More will be added in future so keep updating your software.

Supports all major SQL DBs

Since the report data is based on SQL queries, it supports all the major SQL databases like MySQL, PostgreSQl, Oracle, H2Db, HSQLDB etc

Dynamic Queries

Reports can be built using queries generated dynamically. For instance a user dashboard can have reports based on the login user and thus your query might need the sessions userid. Such reports can be easily created using caxpy.

Real time reports

Create real time reports for your dashboards. The data is updated at regular intervals automatically.

Very lightweight

Unlike other major business intelligence and data visualization applications which are heavy and needs a lot more memory as their basic specification, Caxpy on the other hand is extremely lightweight and does just what it is meant to do.

Easy to Integrate

All you have to do is copy the installation file which is a WAR file and paste it inside your java based application server. It has its own db and doesn't need any external database for storage.

Easy to Learn

If you know SQL, you can do anything with Caxpy. Just add your database and start creating amazing charts. No need to create complex cubes or learn any charting library. Watch this video to see how simple it is.

Beautiful Dashboards

Create beautiful dashboards with just a few lines of code. Embed reports created by you wherever you like with just 2 lines of code.

Pricing

Its free to use for all your personal and non commercial projects.

Try out Caxpy!

Prerequisites

All you need in order to start using Caxpy is Java 7 (or higher) and a server that can run Capy, preferably Tomcat 7+. Only a JRE (Java Runtime Environment) is required and not the full-blown JDK (Java Development Kit).
There is a good chance that Java is already installed on your system and you can verify whether it is ready to run Caxpy by opening a command prompt and typing the following command:

java -version

If the system responds with a java version that is 1.7 or greater, you are ready to download and run Caxpy.
You can download Java from here: http://www.java.com/download.

To install Tomcat you can follow the steps mentioned here

https://tomcat.apache.org/tomcat-7.0-doc/setup.html

 

Quick Installation

Once you have Java and Tomcat installed, you can copy the Caxpy.war file and put that inside webapps folder of tomcat. Caxpy embeds HSQLDB and doesn’t need any external database system.

  • First, download the latest release from the Caxpy downloads area
  • Copy the downloaded war file into Tomcat’s webapp directory
  • Restart tomcat if required, you should be able to see caxpy folder created inside “webapps” on successful deployment.
  • Point your web-browser to http://localhost:8080/caxpy (Your tomcat may be running in different port, use the one your tomcat is configured )
  • Login into the application using username : max and password : password
  • Start using Caxpy

Remote users should be able to access Caxpy over the network by using the machine name instead of “localhost” in the URL shown above. If there is a problem, it could be due to a firewall running on the machine where Caxpy is installed – and you may have to reconfigure things so that for example “java.exe” is not blocked.

Notes for Linux / Unix users

Everything will work unchanged as long as Java has been installed correctly i.e. java is in the PATH and it is the expected 1.7 or greater version. You may need to do things like apply executable permissions to the webapps folder on Linux, e.g. “chmod +x *.sh”. And also – unless you have “root” permissions, you may face problems starting services on port 8080 etc.

Learn more about Caxpy.