[INUG-Users] Any good tool instead of reporter?

Don Wildman WILDMAN at uk.ibm.com
Mon Jan 28 09:20:54 EST 2008


BIRT itself is open source  - http://www.eclipse.org/birt/phoenix/

Tivoli Common Reporting provides an additional toolset based on BIRT.  You 
will find TCR delivering in the downloads of an increasing number of the 
Tivoli product set together with sample reports.  It is not a separate 
download.

-hth-
Don W
___________ 
Don Wildman 
Senior Product Manager - Tivoli Event Management
  
IBM Software Group, Tivoli - Network Management
IBM United Kingdom Limited
email: wildman at uk.ibm.com   
Mobile: +44 (0) 7879 841569  -  Office/DDI: +44 (0) 20 7021 8144  -  T/L: 
438144  -  ITN: 37438144



brad.bueche at wachovia.com 
Sent by: users-bounces at netcoolusers.org
25/01/2008 14:21
Please respond to
users at netcoolusers.org


To
users at netcoolusers.org
cc

Subject
Re: [INUG-Users] Any good tool instead of reporter?






Do you have a download URL?

brad



"Lane Silas" <Silas.Lane at uk.fujitsu.com> 
Sent by: users-bounces at netcoolusers.org
01/25/2008 02:51 AM

Please respond to
users at netcoolusers.org


To
<users at netcoolusers.org>
cc

Subject
Re: [INUG-Users] Any good tool instead of reporter?






I've used IBM's BIRT (Business Intelligence Reporting Tool) here and
have found it flexible and easy to use/deploy.

Also, it's free!!

Silas

-----Original Message-----
From: users-bounces at netcoolusers.org
[mailto:users-bounces at netcoolusers.org] On Behalf Of
brad.bueche at wachovia.com
Sent: 24 January 2008 23:33
To: users at netcoolusers.org
Subject: Re: [INUG-Users] Any good tool instead of reporter?

You can also roll your own in PHP.   If you are going to do canned
reports 
this is very easy.  Creating a front by which to query takes a little 
longer.

I have set up a front end that allows users to query any field (or set
of 
fields) for any value (or set of values)  using any valid oracle
operator 
(including regex, and IN, NULL, all case independent --- except regex)
and 
this then generates a table in html that can be copied and pasted right 
into excel with no changes.  It also does counts (with drilldown),
handles 
class conversions (for english names) , and displays and allows
searching 
of the journal fields as well.  And I can put in the frigging partition 
(!) so my reports are a heck of a lot faster (I also can queue records
so 
I'm not sending them to the brower 1 at a time).  Query time to the db
is 
displayed. Render time is displayed. And you can hit either our
production 
data or test data by choosing the target db from a drop down.  And you
can 
sort your drill down top level reports by count (if you want)! (Reporter

cant). It also has canned report options with sql that duplicates all
the 
webtop entity filters.  So customer can get reports for the webtop
buckets 
that they are working  (all the way back to 1/1/2007) and see who closed

what and when, and who ack'd what and when. 

Its actually my fist web app/page/anything.   PHP and HTML have to be
the 
most well documented technologies on the net. (doh!) So dont think you 
cant do it! (Admittedly, I'm currently on version 61of this app now!)

The total code was up to about 15k lines but I've cut it back to about
3k 
now as I have learned more. In the begining, I had no concept of 
generating anything dynamically.  Eventually, I'm going to have the
entire 
thing generated dynamically by just pointing to a db then letting the
user 
create the query interface they want.  It will however be geared toward 
netcool archives.  (And of course that means I still have to create user

logins, work with a db for user data, start using sessions, etc 
...........as soon as I have time to learn all that stuff).

Additionally, I've already started incorporating flex so that I can do 
charting as well.  And I'll probably eventually re-do the whole front
end 
in flex/flash.  Flash is soooooooooo much better than java on the client

side.   Nice, small, very fast, and adobe provides the code to check and

see if the user has the correct version of flash and if not downloads it

for them.   (For those of you sick and tired of troubleshooting java 
runtime configuration issues on the client side this is a dream come 
true!).  Did I say its fast? Flash actually incorporates a little web 
engine so your server is on the client. No need for ajax. Its RIA from
the 
get go. Responsive! Drag and drop, stateful, lots of security built in, 
etc.  I'm setting up the engine to read xml so that, really, it can
chart 
any data that meets the format. But it will be geared toward doing event

reporting for command centers.  Yes, xml is larger than binary but this
is 
internal on 100mb connections.  I'm watching the amf3 and blazeds stuff 
though. I dont think they will be as open for input though..........vs. 
just saying make your data look like this xml and the charts will work.

$750 for Crystal reports may get you there faster though!!  ;) 

brad




"Hubbard, Greg L" <greg.hubbard at eds.com> 
Sent by: users-bounces at netcoolusers.org
01/24/2008 03:29 PM

Please respond to
users at netcoolusers.org


To
<users at netcoolusers.org>
cc

Subject
Re: [INUG-Users] Any good tool instead of reporter?






You might Google "Oracle reporting" and see what you get.

I have looked at the Oracle Business Intelligence product, which is a
reporting system from Oracle.  You also might look at Crystal Reports
from Business Objects.  There might even be a way to use Windows tools
against a remote Oracle server via ODBC driver.

I've found that Reporter stacks up fairly well against these other
products if you just look at features, and these other products are not
much different in price.

If you have some flexibility, you MIGHT consider switch Reporter from
Oracle to Microsoft SQL Server, and then you can use some of the
Microsoft reporting tools.  But the last time I tried to use the MS SQL
reporter gateway it did not work very well.

GLH 

-----Original Message-----
From: users-bounces at netcoolusers.org
[mailto:users-bounces at netcoolusers.org] On Behalf Of olga NN
Sent: Thursday, January 24, 2008 2:13 PM
To: users at netcoolusers.org
Subject: Re: [INUG-Users] Any good tool instead of reporter?

Good ideaThank you .But I am looking for GUI interface against ORACLE
-alarms are stored in ORACLE database,i need to build graphs

--- Jason Shamroski <jason.shamroski at gulfsoft.com>
wrote:

> I've used InfoVista in the past for device performance reporting. It's

> expensive - typically for larger enterprises, but it's nice. Very 
> customizable reports, provided you know what you want.
> 
> jason
> 
> 
> On 1/24/08, olga NN <al3457 at yahoo.com> wrote:
> >
> > All,
> > I am looking for a good tool to change
> Reporter,can
> > you recommend something?
> > Thank you in advance
> >
> >
> >
> >
> > 
>
________________________________________________________________________
____________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search.
> >
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> >
> > _______________________________________________
> > Sent by the netcoolusers.org "users" mailing list
> > Post: users at netcoolusers.org
> > Unsubscribe: users-unsubscribe at netcoolusers.org
> > Search:
> http://lists.netcoolusers.org/archives/users/
> >
> 
> 
> 
> --
> Jason Shamroski
> Gulf Breeze Software
> www.gulfsoft.com
> 
> Stand by for Tivoli Conference Announcement...
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search:
> http://lists.netcoolusers.org/archives/users/
> 



 
________________________________________________________________________
____________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

ForwardSourceID:NT0004798E 
_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/

ForwardSourceID:NT000479E6 
_______________________________________________
Sent by the netcoolusers.org "users" mailing list
Post: users at netcoolusers.org
Unsubscribe: users-unsubscribe at netcoolusers.org
Search: http://lists.netcoolusers.org/archives/users/







Unless stated otherwise above:
IBM United Kingdom Limited - Registered in England and Wales with number 
741598. 
Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU








More information about the Users mailing list