Re: i5 data mining tools for users

["Mike Eovino" <meovino@xxxxxxxxx>]

SEQUEL is excellent, but expensive.

Rob is absolutely right, however.  We made the huge mistake of rolling
SEQUEL out to users without having any sort of strategy.  We spend
several hours a week helping users write queries now (we are working
on building a data warehouse on a separtate system).

At the very least, create some views with meaningful names and field
descriptions and the necessary joins.  And if you think you want them
querying your production data, you don't.  Segregate it into separate
tables at the very least.  Consider getting it off your production
system if that is possible.

Mike E.



On 3/30/07, Luis Rodriguez <luis.rodriguez2@xxxxxxxxx> wrote:
>  Rob,
>  Although I agree that Query/400 is a nice tool, it can only use the old CQE 
> Query engine. In order to take advantage of the newer SQE you need to use an 
> SQL-based application, like Query Manager or SEQUEL (I'm sure there most be 
> more, but these two are the ones that come to mind right now).
>  As always, of course, it depends on your business needs and resources.
>  Regards,
>  Luis Rodriguez
>
> midrange-l-request@xxxxxxxxxxxx wrote:------------------------------
>
> message: 4
> date: Fri, 30 Mar 2007 09:02:12 -0400
> from: rob@xxxxxxxxx
> subject: Re: i5 data mining tools for users
>
> Query/400.
>
> The problem is not the tools.
> It is not the users.
>
> It is in the developers.
>
> Developers need to create powerful views.  What use is it to give the
> users some slick GUI tool and still expect them to know that you join ECL
> on ECH and IIM and, to calculate on hand you need to take
> IOPB+IADJ+IRCT-IISS?  When you can create a view that:
> - joins these files together
> - Calculates these simple fields like onhand
> - renames fields into something meaningful
> ...
>
> We still have users that upload data from their PC's to the i5 so that
> they can analyze it using Query/400.  Frankly, it's a great tool.  Now, a
> user like me prefers SQL so that I can use parenthesis, etc.  But for a
> quick and dirty I may fall into query/400 the way some of you may bypass
> WDSC into SEU for a quick and dirty.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
> Jerry Draper
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 03/30/2007 01:10 AM
> Please respond to
> Midrange Systems Technical Discussion
>
>
> To
> Midrange Systems Technical Discussion
> cc
>
> Fax to
>
> Subject
> i5 data mining tools for users
>
> Great.  The i5 is storing tons of info in a very coolly designed db but
> the data seems to be in the domain of IT.
>
> Users want access but can't fathom the relationships of the objects.
>
> What good tools are there for people (non-pgmrs) to get information from
> this db?
>
> Jerry
>
> --
> Jerome Draper, Trilobyte Software Systems, since 1976
> iSeries, Network, and Connectivity Specialists -- iSeries, LAN/WAN/VPN
> Representing WinTronix, Synapse, Netopia, HiT, and others .....
> (415) 457-3431; www.trilosoft.com
>
>
>
>
> Luis Rodriguez
>
> IBM Certified Systems Expert
> eServer i5 iSeries Technical Solutions
>
> ---------------------------------
> Finding fabulous fares is fun.
> Let Yahoo! FareChase search your favorite travel sites to find flight and hotel 
> bargains.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.