• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Query Builder end user tool for SQL Server

Hi Experts,

We are looking for a query builder tool for end users which can dynamically create parameters, export to excel, adhoc report capability. Please suggest if there are any. Has  any one used IZenda? can it do?

Appreciate quick response
1 Solution
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
The article Microsoft Excel & SQL Server:  Self service BI to give users the data they want can be used to allow experts to create known reports by selecting pre-selected parameter values and executing a known Stored Procedure.

As far as Ad-Hoc abilities, follow the article to see how users can select their own SQL Object, and then you can always Filter By Form to handle 'parameters'.

All of this ass-u-me's that the DBA's in your company are okay with all users having all permissions on your SQL database, which I've rarely ever seen.

Aside from the above, Microsoft Power Query for Excel is worth looking into.

Good luck.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now