Tom, Just for some more background here .... is the real reason you are having to go through the ETL is so that the users can "play" with your data using 'standard' BI tools like Cognos against the SQL database ?
Also, what USE is the information going to be put to ?! I remember one of the "classic tales" of a sales manager, CFO & CEO turning up @ a meeting at midday with their figures extracted from their real-time BI tool. The sales manager got his extract @ 10am, the CFO @ 11am, and the CEO was handed his take as he walked in at midday --> and of course none of the figures reconciled. Cutting to the chase (in the version of the story I heard), the company stepped back from real-time for "big picture" stuff - and only used near real time for daily performance review. Just curious ...... your answer will impact your solution - but of course things will mature over time to if this is currently simply a 'me too' exercise, though hopefully there are some well considered objectives in mind. Ross Ferris Stamina Software Visage – an Evolution in Software Development >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On >Behalf Of Dawn M. Wolthuis >Sent: Tuesday, 10 February 2004 3:30 PM >To: 'U2 Users Discussion List' >Subject: RE: Real Time Data Warehouse > >Another possible name for a real-time data warehouse is Operational Data >Store (ODS). You will want a really good handle on the requirements for >this. I have worked in this arena with U2 for almost a decade. There are >many possibilities, but the biggest bang for the buck from my perspective >is >still to have users grab data from U2, where the data "thinks" like they >do. > > >Setting up to be able to populate spreadsheets from whatever is extracted, >for example, is much easier than taking data from a non-1NF database that >is >quite easily understood by end-users and normalizing it only to find that >users are then trying to second guess how the data looks in the new >database >and figuring out how to regroup it for a report. > >Using Cedarville's DOWNLOAD utility (you would want to wrap it for the >end-user) or the www.entrinsik.com Informer tool from a web browser would >let the user think intuitively to extract current data (without need for an >ODS) and THEN populate a spreadsheet with the result. > >Any approach to actually porting data to SQL Server, for example, sounds so >small and innocent until two years down the line you add up the costs of >hardware, software, training for users and IT, on-going support, etc and >find that it was a much bigger expense than anyone estimated up front. > >Just my two cents. Best wishes! --dawn > >Dawn M. Wolthuis >Tincat Group, Inc. >www.tincat-group.com > >Take and give some delight today. > > >-- >u2-users mailing list >[EMAIL PROTECTED] >http://www.oliver.com/mailman/listinfo/u2-users > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.580 / Virus Database: 367 - Release Date: 6/02/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
