Looker Studio

Looker Studio (formerly Google Data Studio) is a free business intelligence and data visualization platform that allows you to create interactive dashboards and reports using data from 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 database connection details.

You will need the following information during the Looker Studio setup:

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

Step 2: Create a New Data Source

Open Looker Studio and create a new data source.

1. Click Create New Data Source.
2. Search for MySQL in the connector list.
3. Select the official Google MySQL Connector.

Step 3: Configure the Database Connection

Enter the database credentials generated in Step 1.

Before authenticating, make sure to:

• Enable SSL.
• Upload the server SSL certificate.

The SSL certificate can be downloaded from the database credentials page in Frappe Cloud.

Step 4: Authenticate and Connect

1. Click Authenticate.
2. Select the required database table.
3. Click Connect.

Once connected, Looker Studio will display the table schema and available fields.

Next Steps

After the connection has been established, you can:

• Create interactive dashboards.
• Build custom reports.
• Visualize ERP and business data.
• Share reports with your team.