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.

Apache Superset

With SQL Lab access to powerful SQL editor

Apache Superset

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

Databases list

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

Edit database

And now import CSV is available

Import CSV

superset-iris

InterSystems IRIS Cloud SQL and IntegratedML Contest

InterSystems IRIS Cloud SQL and IntegratedML Contest