No Code GUI Tools?

Question

Is there a flexible, on prem, platform that would allow one to create simple guis to query a series of internal REST APIs and databases?The idea would be to give non-technical people the power to get at data that is available without having to program custom GUIs.

msantos · Accepted Answer

If the resulting data doesn't need formatting, try https://www.postman.com/ It's easy enough to write a few collections and train non-techies to use it.If you are after richly formatted data then try Metabase https://www.metabase.com/

gerardnico · Answer

What you are searching is called a business intelligence application such as tableau, qlikview, Business object, Oracle bi and more.

d--b · Answer

YES!!!!This is what I am building: https://www.jigdev.comIt&rsquo;s based on ObservableHQ, and is meant to give you ui components that you&rsquo;d generally use in small tools: buttons, selectboxes, inputs, tables and charts&hellip;The code part is javascript, so you can just connect to rest apis no problem, and do some data wrangling using javascript.The doc is non-existant, and the product is in early beta (in use at exactly 1 company).It&rsquo;s an electron app people can run on their computers. The apps generated are text files containing mostly javascript code that you can diff/audit.Shoot me an email if you want a demo / more info.Edit: the current version can query mysql databases as well. I could write other modules as well. Also planning to add pivot table soon.

mritchie712 · Answer

If your target user does a lot of work in Google Sheets, https://www.wax.run/ might work well for you. It lets you set up templatized SQL or Python snippets that the end user can control from Sheets by clicking a button (e.g. they could control the WHERE statement in SQL using the value from a cell). The landing page has some examples.

AnotherDS · Answer

KNIME is another option: https://www.youtube.com/watch?v=Snj3_XPcJrU

napier · Answer

Retool has a self-hosted beta https://retool.com/self-hosted/

Reebz · Answer

I&rsquo;m not entirely sure, but could you do something with node red?https://nodered.org/

No Code GUI Tools?

Is there a flexible, on prem, platform that would allow one to create simple guis to query a series of internal REST APIs and databases?
The idea would be to give non-technical people the power to get at data that is available without having to program custom GUIs.

If the resulting data doesn't need formatting, try https://www.postman.com/ It's easy enough to write a few collections and train non-techies to use it.
If you are after richly formatted data then try Metabase https://www.metabase.com/

What you are searching is called a business intelligence application such as tableau, qlikview, Business object, Oracle bi and more.

KNIME is another option: https://www.youtube.com/watch?v=Snj3_XPcJrU

Retool has a self-hosted beta https://retool.com/self-hosted/

I’m not entirely sure, but could you do something with node red?
https://nodered.org/