How to connect or integrate ERPNext(MariaDB) database in frappe Insight

[Arya1998Gupta]

In Attached Screenshot, In my local ERPNext project for creating a dashboard from Frappe Insight .I’m trying to connect new datasource from my erpnext (MariaDB) database. For which I entered the credentials of MariaDB database and tried to connect ERPNext database in Frappe Insight, but it is showing reloading till the enough time. so How I connect my erpnext database in frappe Insight.
Resolve it or suggest any solution.

[nextchamp-saqib]

Can you try using credentials from site_config.json from your site folder and let me know if it works.

[Arya1998Gupta]

Actually the problem is arrising from there . I entered the credentials of site_config.json then after it's taking time to connect.

…

On Wed, 27 Dec 2023 at 17:53, Saqib Ansari ***@***.***> wrote: Can you try using credentials from site_config.json from your site folder and let me know if it works. — Reply to this email directly, view it on GitHub <#192 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BDQUSWGOYZQMFLOETC4C6ULYLQHMPAVCNFSM6AAAAABBEIH4WGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNZQGI2TSMJXGI> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[nextchamp-saqib]

The database name, username and password don't look like it's from site_config.json
The database name & username are the same and the password is around 8-10 digits in site_config.json

[nextchamp-saqib]

Re-open if you find any issues connecting with site_config.json credentials