Zoho Analytics

Zoho Analytics is a business intelligence platform that enables you to analyze your Frappe Cloud data by creating interactive reports, dashboards, and visualizations.

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 obtain the connection details.

Keep the following information available for the setup:

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

Step 2: Add a MariaDB Data Source

Open your Zoho Analytics dashboard and begin importing data.

1. Navigate to the Import Data page.
2. Search for and select MariaDB as the data source.

Step 3: Configure the Connection

Configure the database connection using the credentials from Step 1.

1. Set Cloud Service Provider to Other Cloud Services.
2. Enter the database connection details.
3. Enable the SSL option.

Step 4: Import Database Tables

After the connection is established:

1. Select the database tables you want to import.
2. Configure the synchronization schedule based on your reporting requirements.
3. Start the import process.

Once the import is complete, the selected tables will be available within your Zoho Analytics workspace.

Next Steps

With your data successfully imported, you can use Zoho Analytics to:

• Create reports.
• Build interactive dashboards.
• Analyze ERP and business data.
• Schedule automatic data refreshes.