Re: reduce your I.T. backlog by granting SQL UPDATE/DELETE/ capability to user community!

[Lukas Beeler <lukas.beeler@xxxxxxxxxxxxxxxx>]

On Wed, May 26, 2010 at 20:47, Buck <kc2hiz@xxxxxxxxx> wrote:
> You make a humourous introduction to a very real problem. ÂThe user
> community _are_ doing that very thing today, with the Excel spreadsheets
> that they built when we in IT fell so far behind that they gave up on us.

With the correct tools, Excel spreadsheets can contain Live data.

> I think all here agree that giving the end user community free
> command-line SQL access to the raw database is not the answer either,
> but what is?

How about a modern reporting solution, that's easy to work with?

I've heard about SEQUEL alot on this list, tried the product, but it
was unsuitable for our needs.

We're using WebFocus from Information Builders. If you have a beefy i,
you can run it on that directly. If not, you can run it on Windows or
Linux, still accessing your IBM i. It's completely web based, an all
the reports and data are stored on the server.