Frequently Asked Questions #

Q. My site is hosted on Frappe Cloud. How do I connect to my database? #

If your site is hosted on Frappe Cloud and you have Dashboard access then follow these instructions to find your database credentials.

1. Go to Backup & Restore tab or go to

   https://frappecloud.com/dashboard/sites/<your-site.frappe.cloud>/database

2. Click on the Access Database button and then click on enable database access.

3. You will be prompted with a dialog box that will show you the database credentials.

   

4. Then follow this guide to connect to your database.

Q. How do I view charts/dashboard on my Frappe/ERPNext Site? #

You can export your charts/dashboards as an iframe and embed it in anywhere on your site.

1. Click on the Share button in the visualization tab.

   

2. Click on the Copy iframe button

   

Q. How do I join data from multiple data sources? #

It is possible to join data from multiple data source but it is quite cumbersome. We are working on improving this experience. For now, you can follow the steps below to join data from multiple data sources.

1. Create a query for each of the data sources that you want to join.
2. Make sure that the there is one common column in each of the queries that you want to join.
3. After creating, click on the Store Query under menu to store in into the Query Store data source.
4. Repeat the above steps for all the queries that you want to join.
5. Now, create a new query and use the Query Store data source and join each of the queries by selecting them as a table.