web enabled data warehouse

[nakul]

hello everybody<br>
i am doing some research on web enablement of data warhouses for the uni of north carolina and would like to know if any one has had any experience with such warehouses yet.<br>
also if any professional here can throw some light upon some of the features and issues which arise due to web enabled data warehouses..like the scalablity and security issues, that would be a grt hlp.<br>
thanks in advance...<br>
ciao

 

[yaffle]

The first major factor here would be whether you were giving access to your DW over an intranet within a particular organisation, or to the world in general (or authorised subset thereof) via internet. Internet enabling would add extra considerations e.g. firewall configuration, and the commercial sensitivity of your information may have to be assessed more carefully. For an intranet system, your network configuration would need to be considered: are most of your users connected to your data centre via LAN (e.g. a head office), or is your user population spread over a number of sites, connected via a WAN (probably with lower transmission speeds that may cause bottlenecks). Other considerations would be the type of data use (fixed format or ad-hoc reports, data-mining, etc.), and what tools or packages to use to supply these needs (Business Objects, Microstrategy DSS, ...).<br>
Hope this is some help.<br>

 

[Madsam]

Yes, we are deploying the web as one way to access our University Data Warehouse. We use SSL for securing the network transmission -- but the web interface is accessable anywhere -- we do not lock the ip addresses down to our campuses.<br>
<br>
I am the Data Administrator for the University of Nebraska. Have been working on dwing for 8 years. The web is a great medium to use for the standard 80% of reporting -- esp. if you are trying to reach your Deans, Chairs, VC/VP, etc. For those people, it's the only way to go.<br>
<br>
At U of NE, we have a SQL Server 200gig database, use MS Active Server Pages for dynamic page development and Frontpage for site mgmt. We build stored procedures for the complex data access pieces. It works great -- our customers are really pleased with the results. <br>
<br>
If you want to know more, email me at astephen@uneb.edu. Would enjoy talking to you more specifically about your experiences at NC.<br>
<br>
Amy Stephen

 

[John1]

Yes, you should take a look at the tools offered by Cognos (

http://www.Cognos.com).

I currently am managing an implementation in which we used the client versions of Cognos, Impromptu and Powerplay(OLAP)to develop reports and cubes so that they can be posted to their web counterparts (Impromptu Web and Powerplay Web). We're running on NT server 4.0.<br>
<br>
For the environment to be stable you will need to be running at a minimum NT 4.0 with SP4 or higher and Impromptu Web server 5 (build 261 or greater) and IIS as well.<br>
<br>
Impromptu web supports basic authentication as well as NT challenge response. In terms of running SSL, you should secure a certificate from verisign.