I am looking for software that allows non-sql users to access an SQL-database, and set up data exports fast and easy.
My company has a lot of data in our SQL-database. We do not have any good tools to get the data out to the rest of the company, without spending a lot of time setting up SQL-calls in excel, R or similiar.
The SQL-calls are the same, but dynamic in terms of time.
- The users would want the same specific data, that would always contain the newest data, or a fixed period of data, given a choice of data.
- The data should be exported in a easy-to-use format such as .csv.
- The export needs to be run automatically, so the same data is exported at a specific time each day, without active user interaction.
We've tried Microsoft Report manager, didn't find it satisfying.