It’s easy to deploy solutions on OCI (Oracle Cloud Infrastructure) using Terraform and
Resource Manager’s Stack. I’ve published several resources available on this page.
Today we will see how easy it is to deploy Apache Superset on OCI using MySQL Data Service.
Apache Superset is an open source BI, Reporting, Charting tool that competes with Tableau,
Looker, etc. For a list of companies that have deployed Superset, see this
Superset is loaded with options that make it easy for users of all skill sets to explore and
visualize their data, from simple line charts to highly detailed geospatial charts.
MySQL can be used as a backend to store the needed information related to the platform
(users, settings, dashboards, …) , this represents 55 tables. MySQL can also be used
as source for the data visualization.
The easiest way to install Apache Superset on OCI is to click this button:
If you use the Red Pill (by clicking on the image above), you will redirected to
OCI’s Dashboard Resource
Check that you are in the desired compartment and then click Next:
You will be redirected to the second screen, for variables configuration. Some variables
are mandatory and self
You also have the possibility to choose HA for MySQL DB instance, to load superset sample
data (the deployment is
then longer) and the Shape Selection. If you plan to use HeatWave on that instance, I
recommend you to directly
choose a HeatWave compatible Shape (default):
If you already have a VNC and/or a MDS instance you want to use, you can also use the
existing OCI infrastructure
you have previously deployed:
You need the OCIDs of all the existing resources.
When you have performed all the selection you need, you can continue the process…
Usually default should
be good, you only require to add the MDS admin’s password and if this is the first
deployment, I also recommend to load the sample data.
The deployment will start, with the sample data load, and this takes approximately 30
When ready, the status will change:
At the end of the logs section we already have the output variables we need to use to
join our deployment:
And we can retrieve that info in the Outputs section too:
To reach the Apache Superset we just deployed, we paste the superset_public_ip‘s
value on a browser and we
use the superset_admin_username and superset_admin_password to connect:
Congratulations! Apache Superset is available and working on OCI with MySQL Database
If you want to connect to another MDS instance that you would use as a data source for
some visualization graphs,
you will need to be able to reach it (usually on the same VCN’s subnet or having
routing between different
VCN’s) and you must use the following syntax, as the MySQL Connector installed is