Breadcrumbs

Reports Configuration (Superset 2.0)


This document covers the setup for importing the reports in Apache Superset 2.0 Instance.

   1. Download for MSSQL → dashboard_export_apache_superset_2.0_mssql.zip/  for MySQL → dashboard_export_apache_superset_2.0_mysql.zip  file and place it in any directory of your choice.

Don't import both MsSQL & MySQL reports on the same apache superset server.

   2. Unzip this file and go to the directory databases. image2022-9-28_10-23-45.png

   3. Now open file "cim_reporting_database.yaml".

Screenshot 2022-09-28 at 10.25.51 AM.png

   4. The field sqlalchemy_uri is the connection string in the below format. Please update this as per your configuration. (Don't update any other field.)

        MySQL Format : mysql+mysqldb://Username:Password@ServerAddress:PortNumber/DatabaseName
        MsSQL Format : mssql+pymssql://Username:Password@ServerAddress:PortNumber/DatabaseName


   5. Now delete the previous zip file & zip the parent folder again.

Screenshot 2022-09-28 at 11.08.00 AM.png

   6. Log in to the Superset Administration console by browsing https://server-ip:port/ URL. Screenshot 2022-09-13 at 11.12.32 AM.png


   7.  Goto the "Import dashboards".

Screenshot 2022-09-28 at 7.18.29 PM.png


   8. Select the zip file and press "IMPORT".

image2022-9-28_19-22-51.png



   9. Everything is up now.  

image2022-9-28_19-24-38.png


10. Now set the UTC offset for reports by following document UTC Offset - Reports.