# 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": "",
"maintainer_email": "dmitry@caretdev.com",
"keywords": "\"Superset InterSystems IRIS\"",
"author": "",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/a0/96/a3e4647a671cf3e9c8356e801733a39b9617d0f9564db75da143a991d6a4/superset-iris-0.2.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.2.0",
"split_keywords": [
"\"superset",
"intersystems",
"iris\""
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "f7f7cb84a8dfbc9a401f9a44ea7e2fd5c87752b0b75c2ebd95765300d539b860",
"md5": "764812d14879c7b5df8cb198dd190a4e",
"sha256": "4a9b70e66865a85b107bebc2a59e1d9132a95c67f835eb545ea2d39d481c9edb"
},
"downloads": -1,
"filename": "superset_iris-0.2.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "764812d14879c7b5df8cb198dd190a4e",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 5066,
"upload_time": "2023-04-27T06:46:24",
"upload_time_iso_8601": "2023-04-27T06:46:24.981496Z",
"url": "https://files.pythonhosted.org/packages/f7/f7/cb84a8dfbc9a401f9a44ea7e2fd5c87752b0b75c2ebd95765300d539b860/superset_iris-0.2.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "a096a3e4647a671cf3e9c8356e801733a39b9617d0f9564db75da143a991d6a4",
"md5": "7c5b58a04e59261e5804a710c593043b",
"sha256": "f40dbc1daed4453464722ac0699ed6d7eb821492a56aaf53dd7eb134c340672d"
},
"downloads": -1,
"filename": "superset-iris-0.2.0.tar.gz",
"has_sig": false,
"md5_digest": "7c5b58a04e59261e5804a710c593043b",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 4624,
"upload_time": "2023-04-27T06:46:27",
"upload_time_iso_8601": "2023-04-27T06:46:27.402040Z",
"url": "https://files.pythonhosted.org/packages/a0/96/a3e4647a671cf3e9c8356e801733a39b9617d0f9564db75da143a991d6a4/superset-iris-0.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-04-27 06:46:27",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "caretdev",
"github_project": "superset-iris",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "superset-iris"
}