I am looking for software that allows non-sql users to access an SQL-database, a

Question

I am looking for software that allows non-sql users to access an SQL-database, and set up data exports fast and easy.

Background:

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.

Explanation / Answer

I would recommend you to use an ETL (wikipedia), it will help you extracting data, optionnally transform then load it to any other database, report, or even flat files (CSV, Excel, or whatever).

There are many tools you can check, have a look at Talend Open Studio, it supposed to provide you easy and elegant way build ETL jobs without writing a single code line

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.