RE: Business Objects with DB2 data

Before allowing user direct access to the data with sequel/sql I would work with your business users and IT to access this "old bulky ERP data base" with Views. Which the users can use to access the data with "rules". I have seen where five users have five different ways of adding 2 + 2 ... makes for a lot of unnecessary meetings down the road...can't always count on everyone knowing simple math..lol ... save a lot of headaches on all sides...

It will also allow you to keep data out of the wrong hands...even if they are the boss....insert smile here...

Also think about stored procedures.

Regards,
Bill Hopkins



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
Sent: Thursday, August 01, 2013 6:15 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Business Objects with DB2 data

I have clients who got roped into BO by their business partner, who made a
bundle selling BO services to their customers. The effort involved is
extremely complex.

When BO was purchased by Oracle, the business partner was given a year by
Oracle to find another package to hustle. They went with Cognos in order to
keep their services revenue.

Every one of these clients uses SEQUEL for 99% of their reporting needs,
because SEQUEL gives them direct access to the data without having to play
with BO universes or Cognos metadata setups.

Paul Nelson
Cell 708-670-6978
Office 512-392-2577
nelsonp@xxxxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Hoteltravelfundotcom
Sent: Thursday, August 01, 2013 4:50 PM
To: Midrange Systems Technical Discussion
Subject: Business Objects with DB2 data

I am interested in hearing of any Iseries shops which use Business Objects.
We are interested
in that product to use for reports and allowing users to create their own
reports.
I am concerned in that that AS/400 ERP we have is rather old product,
basically
RPG from back in the 90's and data base is very bulky - any experiences
would be welcome.