Skip to content
Arcade Analytics is the first Open Source Graph Analytics platform. Connect your Graph Database (Neo4j, OrientDB, Amazon Neptune, Microsoft CosmosDB, etc) and RDBMS (Oracle, MySQL, Postgres, Microsoft SQLServer, MariaDB) to create powerful dashboards.
Branch: master
Clone or download
Type Name Latest commit message Commit time
Failed to load latest commit information.
.github/ISSUE_TEMPLATE Update issue templates Feb 18, 2019
.mvn/wrapper #35 Mar 1, 2019
.travis #35 Mar 1, 2019
src arcadeanalytics integration with arcade-orientdb3-connector performed. Apr 23, 2019
webpack #35 Mar 1, 2019
.gitignore adds maven wrapper to ignore Mar 4, 2019
.travis.yml adds changelog generation Mar 14, 2019
LICENSE Initial commit Feb 12, 2019
angular.json go to opensource Feb 14, 2019
changelog.json adds changelog generation Mar 14, 2019
changelog.mustache adds changelog generation Mar 14, 2019
mvnw #35 Mar 1, 2019
mvnw.cmd #35 Mar 1, 2019
package-lock.json go to opensource Feb 14, 2019
pom.xml pom updated: added orientdb 3 connector dependency. Apr 24, 2019
postcss.config.js go to opensource Feb 14, 2019
settings.gradle go to opensource Feb 14, 2019
tsconfig.json go to opensource Feb 14, 2019
tslint.json go to opensource Feb 14, 2019
yarn.lock tslint updated Mar 6, 2019

License Build Status

Arcade Analytics - Play With Data

Docker images of Arcade and demo databases are available on Docker hub

Quick start

To launch ArcadeAnalytics just run (needs docker installed)

docker-compose -f src/main/docker/app.yml up

and then go to


login as user with password user

To be able to create new users, fill the properties inside the compose:


Then restart the container and login with admin/admin credentials.

The Docker compose starts ArcadeAnalytics, a PostgreSQL database, an Elastic instance and an OrientDB with its demodb preloaded.

For detailed instructions on how to use Arcade read the manual

Start with "single" (embedded) image

Arcade is provided as a all-embedded image, where hsql and embedded Elasicsearch are used instead of Postgresql and ES on separate containers.

docker-compose -f src/main/docker/app-single.yml up

This compose does not start containers with test databases

Run support containers with test databases

Compose configurations with preconfigured databases are provided in the src/main/docker directory:

  • OrientDB with preconfigured demodb
  • Postgres with dvd rental demo database
  • Mysql with sakila (dvd rental) demo database

To run a db container use the provided compose:

docker-compose -f src/main/docker/postgresql-dvd-rental.yml up

docker-compose -f src/main/docker/orientdb2.yml up

Configure SSH

AracadeAnalytics can connect to databases using an SSH tunnel. To do that, it needs the private and public keys to be used by the application. In the app.yml or app-single.yml :

          - JAVA_OPTS=-DSSH_PRIV_KEY=/arcade/.ssh/id_rsa -DSSH_PUB_KEY=/arcade/.ssh/

The directory /arcade inside the container is mounted as volume:

          - ~/.arcade/:/arcade/

Create a directory in ~/.arcade/ named .ssh and put the private and public keys inside. The public key should be copied on the server used as ssh gateway too.

Connect to Amazon AWS

Read the dedicated post. Use your own SSH keys, as explained in the previous paragraph.


NOTE: Arcade was built using JHipster

Before you can build this project, you must install and configure the following dependencies on your machine:

  1. Node.js: We use Node to run a development web server and build the project. Depending on your system, you can install Node either from source or as a pre-packaged bundle.
  2. Yarn: We use Yarn to manage Node dependencies. Depending on your system, you can install Yarn either from source or as a pre-packaged bundle.

After installing Node, you should be able to run the following command to install development tools. You will only need to run this command when dependencies change in package.json.

yarn install

We use yarn scripts and Webpack as our build system.

Run the following commands in two separate terminals to create a blissful development experience where your browser auto-refreshes when files change on your hard drive.

yarn start

Yarn is also used to manage CSS and JavaScript dependencies used in this application. You can upgrade dependencies by specifying a newer version in package.json. You can also run yarn update and yarn install to manage dependencies. Add the help flag on any command to see how you can use it. For example, yarn help update.

The yarn run command will list all of the scripts available to run for this project.

Service workers

Service workers are commented by default, to enable them please uncomment the following code.

  • The service worker registering script in index.html
    if ('serviceWorker' in navigator) {
        .then(function() { console.log('Service Worker Registered'); });
  • The copy-file option in webpack-common.js
{ from: './src/main/webapp/sw.js', to: 'sw.js' },

Note: Add the respective scripts/assets in sw.js that is needed to be cached.

Managing dependencies

For example, to add Leaflet library as a runtime dependency of your application, you would run following command:

yarn add --exact leaflet

To benefit from TypeScript type definitions from DefinitelyTyped repository in development, you would run following command:

yarn add --dev --exact @types/leaflet

Then you would import the JS and CSS files specified in library's installation instructions so that Webpack knows about them: Edit src/main/webapp/app/vendor.ts file:

import 'leaflet/dist/leaflet.js';

Edit src/main/webapp/content/css/vendor.css file:

@import '~leaflet/dist/leaflet.css';

Note: there are still few other things remaining to do for Leaflet that we won't detail here.

For further instructions on how to develop with JHipster, have a look at Using JHipster in development.

Using angular-cli

You can also use Angular CLI to generate some custom client code.

For example, the following command:

ng generate component my-component

will generate few files:

create src/main/webapp/app/my-component/my-component.component.html
create src/main/webapp/app/my-component/my-component.component.ts
update src/main/webapp/app/app.module.ts

Doing API-First development using swagger-codegen

Swagger-Codegen is configured for this application. You can generate API code from the src/main/resources/swagger/api.yml definition file by running: Then implements the generated interfaces with @RestController classes.

To edit the api.yml definition file, you can use a tool such as Swagger-Editor. Start a local instance of the swagger-editor using docker by running: docker-compose -f src/main/docker/swagger-editor.yml up -d. The editor will then be reachable at http://localhost:7742.

Refer to Doing API-First development for more details.

Building for production

To optimize the arcadeanalytics application for production, run:

./mvnw -Pprod clean package

This will concatenate and minify the client CSS and JavaScript files. It will also modify index.html so it references these new files. To ensure everything worked, run:

java -jar build/libs/*.war

Then navigate to http://localhost:8080 in your browser.

Refer to Using JHipster in production for more details.


To launch your application's tests, run:


Client tests

Unit tests are run by Karma and written with Jasmine. They're located in src/test/javascript/ and can be run with:

yarn test

UI end-to-end tests are powered by Protractor, which is built on top of WebDriverJS. They're located in src/test/javascript/e2e and can be run by starting Spring Boot in one terminal (./gradlew bootRun) and running the tests (yarn run e2e) in a second one.

Other tests

Performance tests are run by Gatling and written in Scala. They're located in src/test/gatling and can be run with:

./mvnw gatling:test

For more information, refer to the Running tests page.

Using Docker to simplify development (optional)

You can use Docker to improve your JHipster development experience. A number of docker-compose configuration are available in the src/main/docker folder to launch required third party services. For example, to start a postgresql database in a docker container, run:

docker-compose -f src/main/docker/postgresql.yml up -d

To stop it and remove the container, run:

docker-compose -f src/main/docker/postgresql.yml down

You can also fully dockerize your application and all the services that it depends on. To achieve this, first build a docker image of your app by running:

./mvnw clean package -Pprod 

Then run:

docker-compose -f src/main/docker/app.yml up -d

For more information refer to Using Docker and Docker-Compose, this page also contains information on the docker-compose sub-generator (jhipster docker-compose), which is able to generate docker configurations for one or several JHipster applications.

Continuous Integration (optional)

To configure CI for your project, run the ci-cd sub-generator (jhipster ci-cd), this will let you generate configuration files for a number of Continuous Integration systems. Consult the Setting up Continuous Integration page for more information.

You can’t perform that action at this time.