November 13, 2009 at 8:47 am
We have a handful of SQL stored procedures w/ parameters that non-technical end users (analysts) need to execute from time to time. We'd like to avoid coding something custom in Access or VB - how do other organizations handle this? I thought for sure I could Google up some free Access tools someone had already written that let us run arbitrary stored procedures with parameters but can't find anything. How do other organizations handle this? Are there other tools out there that lets users execute procedures? Giving SQL Management Studio to these users is a non-starter.
Thanks,
Mark
November 13, 2009 at 9:10 am
Do the "non-technical" users also supply the parameters to the stored procs?
One way is to set an Excel workbook which can fire a stored procedure. You can also sanitise the parameter values with a macro. Its an easy interface for non-techies to use
November 13, 2009 at 10:59 am
I'd say - invest in something like Business Objects, etc.... You can control WHAT they ask (while givng them a lot of freedom), while maintaining some control over HOW it queries the DB as well.
By building out that universe layer, you can also do a lot of the heavy lifting.
If you want to try out a smaller version, SRS has a report "model" which you can use to build out similar objects (abstracting away from the physical data layout). You can then publish this for your power users to use for their purposes.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
November 13, 2009 at 11:43 am
Are you returning results to users or are they doing some processing?
If not results, why not a batch file? Or very simple VB Script that gets parameters?
If they need results, can they get a CSV back? Batch/VBScript works there as well. Use SQLCMD to pull back things. If that's hard, Excel might be the easiest way to do this.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply