Re: i5 data mining tools for users

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.