Re: BI / Reporting tools

[Charles Wilt <charles.wilt@xxxxxxxxx>]

An AS/400?  You might be out of luck.

Now if instead of an AS/400, you actually have a relatively recent POWER
system running a relatively recent version of IBM i...

Then you've got lots of options.

IBM provided v1 of it's own Web Query product for free to customer who had
a license to Query/400.
Moving to v2 had some costs associated with it unless you were current on
maintenance for v1.
https://www-03.ibm.com/systems/power/software/i/db2/webquery/

What constitutes a reasonable cost for you?

I suspect you'll probably want to look at open-source BI tools.  Most of
them should support an ODBC/JDBC connection to an DB2 database on IBM i.

JasperReports is one I've heard of being used with the IBM i.

Charles


On Wed, Apr 13, 2016 at 7:18 AM, Aljahmi, Jamal <
Jamal.Aljahmi@xxxxxxxxxxxxxxxxxxxxx> wrote:

> We have an critical AS/400 application that is a DB2 file base system that
> has limited reporting. We are looking for a reasonable cost BI/reporting
> tool that will allow the users to access reports easily with possible
> dashboard. Any suggestion would be appreciated.
>
> Jamal
>
>
> ------------------------------------------------------------------------
>
> This message and any attachments originated from a computer at the 36th
> District Court in the city of Detroit and are intended only for the use of
> the addressee(s) and may contain information that is privileged and
> confidential.  If the reader of the message is not the intended recipient
> or an authorized representative of the intended recipient, you are hereby
> notified that any dissemination of this communication is strictly
> prohibited.  If you received this communication in error, notify the sender
> immediately by return email and delete the message and any attachments from
> your system.  Furthermore every effort has been taken to ensure protection
> against virus infection; we cannot accept any responsibility for viruses.
> Consequently, please ensure that all attachments are virus checked prior to
> opening.
>
> ------------------------------------------------------------------------
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.