What is Superset
Apache Superset is a widely popular, opensource, web-based business intelligence application. It is known to be very fast, light weight and an easy to use application. It is very intuitive and loaded with configurable features that allow any user to explore and visualize the data.
Superset now integrates support for IBM Netezza Performance Server (aka Netezza). After installing Superset, a simple driver installation step sets up Superset to work with Netezza.
Detailed steps on installation of Superset can be found at https://superset.apache.org/docs/intro under section “Installation and Configuration”. Make sure you install latest version of Superset (version 1.2.0 or later). Older versions of Superset do not support Netezza.
Once the installation is complete, install nzalchemy (SQLAlchemy dialect for Netezza), in the Superset docker container. Command to install nzalchemy is:
pip install nzalchemy
nzalchemy automatically installs other dependencies such as nzpy (Netezza Python driver). You are all set to go ahead with the configuration.
Detailed configuration walkthrough is available at https://superset.apache.org/docs/installation/configuring-superset
Once Superset is running, you should be able to access it using http://<ipaddress>:8088/superset/welcome
Next step is to connect to Netezza database.
While adding new database to Superset, use SQLAlchemy URI as:
where, 5480 is default port for Netezza.
Check that the connection is successful.
Once the database is added successfully, you should be able to see it in the list of connected databases.
Select the dataset (table/view) you want to work on.
Now you can use the database table to create charts or run SQL using SQL Editor. There are multiple options for chart types, measures, filters and other configurations that you can use as per data visualization requirement.
You can create intuitive dashboard from your charts.
There is lot more functionality to the Superset than demonstrated here. Some important features are:
- Wide array of visualizations to showcase your data
- Interactive dashboards
- Code-free visualization builder
- SQL IDE with metadata browser
You can explore all Superset features with Netezza database. Explore and let us know!
Superset documentation: https://superset.apache.org/docs/intro
Netezza driver installation: https://superset.apache.org/docs/databases/netezza
Raise Netezza specific issues on: https://github.com/IBM/nzalchemy/issues