search

Rello / analytics_sourcepack

Additional data sources for the Nextcloud Analytics app
GNU Affero General Public License v3.0
0 stars 0 forks source link

SQL query #2

Open Rello opened 2 years ago

Rello commented 2 years ago

Hello all,

We are trying to integrate our current ERP with our Nextcloud Analytics plugin... we have access to a MSSQL database and can run queries, we are curently using wpdatatables in our webpage to run those but we want to move all the internal tools to NextCloud.

Apparently there isnt a plugin allowing for SQL queries, we will investigate a bit on how to make a extrenal SQL data connector but my coding knowledge is VERY VERY limited (script kiddie level).

So meanwhile I leave the suggestion here hoping more people can find it useful.

Best Regadrs, Igor

@igorneumann your request will be followed here https://github.com/Rello/analytics/issues/142

elhananjair commented 1 year ago

This feature is really handy if it's possible @Rello and I think I have good news I just found some open-source tool that generates REST API from different kinds of data sources including MSSQL/SQL Server. You can find it here https://github.com/dreamfactorysoftware/dreamfactory

This tool will generate a REST API endpoint so that the Analytics app can connect to it easily to extract some data. The user must install/setup this tool on the server though to generate the API, and then on the Analytics app, using the GET method and JSON as a data source, it will be possible to view extracted data live.

I haven't tested it yet but am positive that it would work perfectly. Thanks

Rello commented 1 year ago

Hi,

thats a very nice finding. With this anyone can use the existing setup already. I think I will also try it when I have some time.

thank you!