 | |
#1
 
| |||
| |||
|
Inexpensive tools -
08-06-2003
, 08:29 PM
#2
| |||
| |||
|
|
Anyone aware of a low cost ( < $500 US per seat ) query tool. We are looking at using Access for a very constrained data warehouse environment. Looking for thoughts. |
#3
| |||
| |||
|
|
A good decision support system has 3 important elements: 1. Relational data store (the datawarehouse) 2. Multidimensional data store (OLAP - where the preaggregated values are) 3. Front-end tools To go for a ROLAP solution based on Access is far from ideal. Not least because it's not very scalable. Much better to purchase SQL Server/AS & choose from one of the many cheap front-ends that are available (the Excel add-ins are very cheap). It will be easier & better than Access in my opinion. Regards, John Chuck Schuelke <cesjr (AT) airmail (DOT) net> wrote Anyone aware of a low cost ( < $500 US per seat ) query tool. We are looking at using Access for a very constrained data warehouse environment. Looking for thoughts. |
#4
| |||
| |||
|
|
Chuck A couple of questions. 1. Are you wanting to create OLAP cubes off your Access data warehouse and then interrogate these with a browser for the cube? Assuming MOLAP here. 2. Do you just want to be able to just query and report from the Access data warehouse? Regards Howard.Taylor@ domain below www.o2olap.com "Chuck Schuelke" <cesjr (AT) airmail (DOT) net> wrote in message news:1rky8csaqmgst.13q79ctx3501i.dlg (AT) 40tude (DOT) net... Anyone aware of a low cost ( < $500 US per seat ) query tool. We are looking at using Access for a very constrained data warehouse environment. Looking for thoughts. |
#5
| |||
| |||
|
|
Thanks for the response. A couple of clarifying notes. the data warehouse is in oracle 8i, we are looking at very inexpensive data access frontends. We are defaulting to using access as a data access tool, not database. So i am looking for inexpensive clones of tools like bo, microstrategy, brio, etc. I know all the reasons this is a bad idea but if we don't do it someone else will. |
http://www.alphacentauri.be
There should be some activex component that looked very nice... (drilling,
aggregating, etc.)..
Currently, this site seems to be univailable...
Does anybody knows anything about it?
Dario
#6
| |||
| |||
|
|
Path: news-g.iadfw.net!cabal1.airnews.net!cabal10.airnews.net !crtntx1-snf1.gtei.net!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com !fu-berlin.de!Iskon!not-for-mail From: "buky" <_buky_zg (AT) hotmail (DOT) com Newsgroups: comp.databases.olap Subject: Re: Inexpensive tools Date: Mon, 18 Aug 2003 08:57:11 +0200 Organization: IskonInternet d.d. Lines: 25 Message-ID: <bhptal$8r0$2 (AT) sunce (DOT) iskon.hr References: <1rky8csaqmgst.13q79ctx3501i.dlg (AT) 40tude (DOT) net> <bh8gik$l6n$1 (AT) hercules (DOT) btinternet.com> <1bovptqav7fkq$.18s7bvhqfgq09.dlg (AT) 40tude (DOT) net NNTP-Posting-Host: zg04-047.dialin.iskon.hr X-Trace: sunce.iskon.hr 1061189781 9056 213.191.137.48 (18 Aug 2003 06:56:21 GMT) X-Complaints-To: abuse (AT) iskon (DOT) hr NNTP-Posting-Date: 18 Aug 2003 06:56:21 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: news-g.iadfw.net comp.databases.olap:26314 "chuck schuelke" <cesjr (AT) airmail (DOT) net> wrote in message news:1bovptqav7fkq$.18s7bvhqfgq09.dlg (AT) 40tude (DOT) net... Thanks for the response. A couple of clarifying notes. the data warehouse is in oracle 8i, we are looking at very inexpensive data access frontends. We are defaulting to using access as a data access tool, not database. So i am looking for inexpensive clones of tools like bo, microstrategy, brio, etc. I know all the reasons this is a bad idea but if we don't do it someone else will. A few months ago, I had a same question, and somebody give me a link to a http://www.alphacentauri.be There should be some activex component that looked very nice... (drilling, aggregating, etc.).. Currently, this site seems to be univailable... Does anybody knows anything about it? Dario |
#7
| |||
| |||
|
|
Tools like Brio, Microstrategy and BO are NOT inexpensive - unless you only have a VERY limited number of users. A typical example is BO which has a starting price tag of about 800 EUR per user. If you want some functionality above that you can double or triple that price per seat. An example would then be : 50 simple users (just browse the reports) 50 * 800 40.000 EUR 10 Powerusers (Can design their own reports, ) 10 * 1600 16.000 EUR 1 Designer (Can design universes etc) 1 * 2400 2.400 EUR In all 58.400 EUR Maintenence p.a. 10.000 EUR Of course the vendor will give some discounts. The example is not set ip to hang out BO as you will most likely expeience about the same with other vendors Thanks for the response. A couple of clarifying notes. the data warehouse is in oracle 8i, we are looking at very inexpensive data access frontends. We are defaulting to using access as a data access tool, not database. So i am looking for inexpensive clones of tools like bo, microstrategy, brio, etc. I know all the reasons this is a bad idea but if we don't do it someone else will. A few months ago, I had a same question, and somebody give me a link to a http://www.alphacentauri.be There should be some activex component that looked very nice... (drilling, aggregating, etc.).. Currently, this site seems to be univailable... Does anybody knows anything about it? Dario |
#8
| |||
| |||
|
|
I think he knows that tools like BusinessObjects, MicroStrategy and Brio are quite expensive -- that's why he asked for inexpensive *clones* of them. "Bjørn Tingstadengen" <bti (AT) ementor (DOT) no> wrote in message news:f07399d2.0308190341.42f6534 (AT) posting (DOT) google.com... Tools like Brio, Microstrategy and BO are NOT inexpensive - unless you only have a VERY limited number of users. A typical example is BO which has a starting price tag of about 800 EUR per user. If you want some functionality above that you can double or triple that price per seat. An example would then be : 50 simple users (just browse the reports) 50 * 800 40.000 EUR 10 Powerusers (Can design their own reports, ) 10 * 1600 16.000 EUR 1 Designer (Can design universes etc) 1 * 2400 2.400 EUR In all 58.400 EUR Maintenence p.a. 10.000 EUR Of course the vendor will give some discounts. The example is not set ip to hang out BO as you will most likely expeience about the same with other vendors Thanks for the response. A couple of clarifying notes. the data warehouse is in oracle 8i, we are looking at very inexpensive data access frontends. We are defaulting to using access as a data access tool, not database. So i am looking for inexpensive clones of tools like bo, microstrategy, brio, etc. I know all the reasons this is a bad idea but if we don't do it someone else will. A few months ago, I had a same question, and somebody give me a link to a http://www.alphacentauri.be There should be some activex component that looked very nice... (drilling, aggregating, etc.).. Currently, this site seems to be univailable... Does anybody knows anything about it? Dario |
#9
| |||
| |||
|
|
Bjørn, remember there are some good Excel add-ins available for less than 500EUR: XLCubed is less, I think so is Plain, Intelligent Apps & BIXL. These tend to be far better at delivering a good return on your BI investment because the end-users who are in a position to get the return usually know Excel well. www.johnkeeley.com bti (AT) ementor (DOT) no (Bjørn Tingstadengen) wrote in message news:<f07399d2.0308210325.2d4a0deb (AT) posting (DOT) google.com>... Ooops - didn,t read Chucks last posting well enough. I am not sure if Oracle ship their query tool Discoverer free-of-charge (at least for Oracle 9i I believe). Usually there is no thing such as a free lunch so maybe upgrading to Oracle 9i is required? A quite cheap solution to the Oracle data warehouse is of course, as others have mentioned here before - to use MS SQL server Analysis Services as a middle-ware OLAP server between the Oracle Warehouse and the front-end solution. You basically only need to install MSAS, however some of the SQL server database functionality might to be used as well - such as DTS (a Data Transformation Utility) to administrate and automate updating of the OLAP database. A real cheap frontend with usable functionality (pivoting data, drill-down, selecting members etc) would then be Excel - which most users probably alredy have so there is no investments neccesary here. A drawback with this solution is that Excel XP is required, as older versions of Excel are not usable, or have very limited functionality. Microsoft will ship a new WEB based reporting-tool later this automn called Reporting Services. This utility can do drill-down pivoting etc (much like their Office Web component), and can be used to access both relational and OLAP data. Earlier MS indicated that this feature will be shipped free-of-charge to existing SQL server 2000 users, but I think pricing still is not real clear at the moment. For other 3rd party MSAS front-ends expect prices in the area of 5-800 EUR per user which is in the lower end of other Query tools which you can use directly on your Oracle database, so I am not really sure if this would be a good solution in terms of $. Generally I have never came across serious SW that is shipped at prices below 5-800 EUR per user, as there is usually some sales- and administration cost involved. RE Bjørn T kthomas (AT) capitallocator (DOT) com (Kevin Thomas) wrote in message news:<fef13272.0308201145.50c8aa8 (AT) posting (DOT) google.com>... Anyone have any idea what Brio costs? Been looking them but wanted to get a feel for pricing before I called. -K "Nigel Pendse" <nigelp.nospam (AT) compuserve (DOT) com> wrote I think he knows that tools like BusinessObjects, MicroStrategy and Brio are quite expensive -- that's why he asked for inexpensive *clones* of them. "Bjørn Tingstadengen" <bti (AT) ementor (DOT) no> wrote in message news:f07399d2.0308190341.42f6534 (AT) posting (DOT) google.com... Tools like Brio, Microstrategy and BO are NOT inexpensive - unless you only have a VERY limited number of users. A typical example is BO which has a starting price tag of about 800 EUR per user. If you want some functionality above that you can double or triple that price per seat. An example would then be : 50 simple users (just browse the reports) 50 * 800 40.000 EUR 10 Powerusers (Can design their own reports, ) 10 * 1600 16.000 EUR 1 Designer (Can design universes etc) 1 * 2400 2.400 EUR In all 58.400 EUR Maintenence p.a. 10.000 EUR Of course the vendor will give some discounts. The example is not set ip to hang out BO as you will most likely expeience about the same with other vendors Thanks for the response. A couple of clarifying notes. the data warehouse is in oracle 8i, we are looking at very inexpensive data access frontends. We are defaulting to using access as a data access tool, not database. So i am looking for inexpensive clones of tools like bo, microstrategy, brio, etc. I know all the reasons this is a bad idea but if we don't do it someone else will. A few months ago, I had a same question, and somebody give me a link to a http://www.alphacentauri.be There should be some activex component that looked very nice... (drilling, aggregating, etc.).. Currently, this site seems to be univailable... Does anybody knows anything about it? Dario |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.