# InterSystems IRIS support for Apache Superset
<img
src="https://github.com/apache/superset/raw/master/superset-frontend/src/assets/branding/superset-logo-horiz-apache.png"
alt="Superset"
width="500"
/>
[Apache Superset](https://superset.apache.org/) 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
```shell
git clone https://github.com/caretdev/superset-iris.git superset-iris
cd superset-iris
```
* Start Superset with Docker-Compose
```shell
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
```shell
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](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/superset.png)
With SQL Lab access to powerful SQL editor
![Apache Superset](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/sqllab.png)
It is possible to upload CSV files to IRIS. Go to Settings, [Database Connections](http://localhost:8088/databaseview/list/). Edit action on database.
![Databases list](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/databases.png)
In the modal dialog, go to Advanced, Security and check `Allow file uploads to database` and Finish
![Edit database](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/edit-database.png)
And now [import CSV](http://localhost:8088/csvtodatabaseview/form) is available
![Import CSV](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/import-csv.png)
Raw data
{
"_id": null,
"home_page": "https://github.com/caretdev/superset-iris",
"name": "superset-iris",
"maintainer": "CaretDev",
"docs_url": null,
"requires_python": null,
"maintainer_email": "dmitry@caretdev.com",
"keywords": "\"Superset InterSystems IRIS\"",
"author": null,
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/15/52/70c5e6bc917a36f07a91ae93bd31254bb491a9b91c61ce6bde2986c81362/superset_iris-0.4.0.tar.gz",
"platform": null,
"description": "# InterSystems IRIS support for Apache Superset\n\n<img\n src=\"https://github.com/apache/superset/raw/master/superset-frontend/src/assets/branding/superset-logo-horiz-apache.png\"\n alt=\"Superset\"\n width=\"500\"\n/>\n\n[Apache Superset](https://superset.apache.org/) 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.\n\n## How to test with IRIS\n\n* Clone this repository\n\n```shell\ngit clone https://github.com/caretdev/superset-iris.git superset-iris\ncd superset-iris\n```\n\n* Start Superset with Docker-Compose\n```shell\ndocker-compose pull\ndocker-compose up -d\n```\n\n* During the start it imports example data to IRIS Database, it will take a while, to wait until it's done, run this command\n```shell\ndocker-compose logs -f superset-init\n```\n\n> 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\n> ```\n> docker-compose -f docker-compose-simple.yml up -d --build \n> ```\n\nWhen 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.\n\n![Apache Superset](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/superset.png)\n\nWith SQL Lab access to powerful SQL editor\n\n![Apache Superset](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/sqllab.png)\n\nIt is possible to upload CSV files to IRIS. Go to Settings, [Database Connections](http://localhost:8088/databaseview/list/). Edit action on database.\n\n![Databases list](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/databases.png)\n\nIn the modal dialog, go to Advanced, Security and check `Allow file uploads to database` and Finish\n\n![Edit database](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/edit-database.png)\n\nAnd now [import CSV](http://localhost:8088/csvtodatabaseview/form) is available\n\n![Import CSV](https://raw.githubusercontent.com/caretdev/superset-iris/main/imgs/import-csv.png)\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "InterSystems IRIS Engine for Apache Superset",
"version": "0.4.0",
"project_urls": {
"Homepage": "https://github.com/caretdev/superset-iris",
"Source": "https://github.com/caretdev/superset-iris",
"Tracker": "https://github.com/caretdev/superset-iris/issues"
},
"split_keywords": [
"\"superset",
"intersystems",
"iris\""
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "2442a8f925529d2740e0cb4c7b43bb848d495fa5df1af0d4cf7fd570db960c65",
"md5": "5754cc6aea81b4322d294283aa49fbc5",
"sha256": "c31605af329070aecc7ca65bd1c7f302a07f5cc9624bdb51f52a9605db730538"
},
"downloads": -1,
"filename": "superset_iris-0.4.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "5754cc6aea81b4322d294283aa49fbc5",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 5745,
"upload_time": "2024-06-22T00:55:20",
"upload_time_iso_8601": "2024-06-22T00:55:20.462801Z",
"url": "https://files.pythonhosted.org/packages/24/42/a8f925529d2740e0cb4c7b43bb848d495fa5df1af0d4cf7fd570db960c65/superset_iris-0.4.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "155270c5e6bc917a36f07a91ae93bd31254bb491a9b91c61ce6bde2986c81362",
"md5": "87e4ef620f263f578ccf48b8544b7469",
"sha256": "59c8b08dbae356a90577bd2c63802ba9a68805fff22936f767b904b72b281349"
},
"downloads": -1,
"filename": "superset_iris-0.4.0.tar.gz",
"has_sig": false,
"md5_digest": "87e4ef620f263f578ccf48b8544b7469",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 5205,
"upload_time": "2024-06-22T00:55:22",
"upload_time_iso_8601": "2024-06-22T00:55:22.109780Z",
"url": "https://files.pythonhosted.org/packages/15/52/70c5e6bc917a36f07a91ae93bd31254bb491a9b91c61ce6bde2986c81362/superset_iris-0.4.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-06-22 00:55:22",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "caretdev",
"github_project": "superset-iris",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "superset-iris"
}