Apache Superset

Apache Superset is an open-source business intelligence platform that enables you to explore data, build interactive dashboards, and create powerful visualizations using your Frappe Cloud database.

Step 1: Create a Database User

Generate a read-only database user for your Frappe Cloud site using the Database Users and Permission Manager.

1. Create a read-only database user.
2. Wait a few seconds for the configuration to complete.
3. Click View Credential to view the connection details.

Keep the following information ready for the database connection:

• Server Name
• Port
• Database Name
• Username
• Password

Step 2: Add a New Database in Superset

Open your Apache Superset dashboard and begin creating a new database connection.

1. Navigate to the database connection page.
2. Select MySQL as the database type.

Step 3: Configure the Database Connection

Enter the database credentials generated in the previous step.

Make sure to enable the SSL option before continuing with the connection.

Step 4: Verify the Connection

After entering all the required information:

1. Complete the connection setup.
2. If the configuration is correct, Superset will display a confirmation indicating that the database has been connected successfully.

Next Steps

Once the connection has been established, you can begin using Apache Superset to:

• Create interactive dashboards.
• Build charts and visualizations.
• Analyze ERP and business data.
• Explore your database using SQL and visual query builders.