InterSystems IRIS support for Apache Superset

Apache Superset is a modern data exploration and data visualization platform. Superset can replace or augment proprietary business intelligence tools for many teams. Superset integrates well with a variety of data sources.

How to test with IRIS

• Clone this repository

git clone https://github.com/caretdev/superset-iris.git superset-iris
cd superset-iris

• Start Superset with Docker-Compose

docker-compose pull
docker-compose up -d

• During the start it imports example data to IRIS Database, it will take a while, to wait until it’s done, run this command

docker-compose logs -f superset-init

In addition there is docker-compose-simple.yml file, which contains only superset and IRIS, it loads examples too, but with no way to see the progress, but through Superset UI

docker-compose -f docker-compose-simple.yml up -d --build 

When the command above will finish work, go to http://localhost:8088/dashboard/list/. Dashboards available without authorization. To access SQL Lab use admin/admin as login and password.

With SQL Lab access to powerful SQL editor

It is possible to upload CSV files to IRIS. Go to Settings, Database Connections. Edit action on database.

In the modal dialog, go to Advanced, Security and check Allow file uploads to database and Finish

And now import CSV is available