Analytics data using SQL query

ineumann · April 19, 2021, 10:45am

Hello all,

We want to get data from SQL queries from a external database to display in our Analytics.
We manage to do it in Wordpress using wpdatatables but cant find a way to make it in Nextcloud?

Best Regards,
Igor

Spartachetto · April 19, 2021, 9:58pm

@Rello should be the one that knows the answer…!

Rello · April 20, 2021, 6:09am

Hello
@Spartachetto thanks for the hint

@ineumann
external SQL connector is not available (yet?) because it would be pretty challenging for different DB types. Also DBs are not accessible from extern.
It would be possible to develop an own datasource as an add-on to Analytics

Or put it as a feature request with a little background in github.

thank you for your feedback,
Rello

ineumann · April 23, 2021, 6:57am

Awesome… Ill take a look into it.

Many thanks!

Rello · May 18, 2021, 8:44pm

Hi
i put it on the roadmap. lets see if it will make it in the next 3.6 release

ineumann · May 19, 2021, 6:39am

Awesome, looking forward to it, many thanks!

mcoulter · September 16, 2022, 5:13pm

Is this relevant to wanting to run SQL queries against the Nextcloud database itself? I’m using the Forms app for data collection and building some stored procedures and views on the Nextcloud database. Would it be accessible through the Analytics app?