Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

web enabled data warehouse

web enabled data warehouse

web enabled data warehouse

hello everybody
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.
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.
thanks in advance...

RE: web enabled data warehouse

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, ...).
Hope this is some help.

RE: web enabled data warehouse

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.

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.

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.

If you want to know more, email me at astephen@uneb.edu. Would enjoy talking to you more specifically about your experiences at NC.

Amy Stephen

RE: web enabled data warehouse

Yes, you should take a look at the tools offered by Cognos (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.

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.

Impromptu web supports basic authentication as well as NT challenge response. In terms of running SSL, you should secure a certificate from verisign.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close