If they have SQL Server they already own the reporting services; you could cube up the data and use OLAP and do quite well using the products they have already paid for. Once you figure out the schema to get it from SQL tables into an OLAP cube it's gravy.
-----Original Message----- From: Caroline Wise [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 5:04 PM To: CF-Talk Subject: Re: Data Warehousing - Help a newbie Thanks, Mike, I'll check out Embarcadero. We are basically in pre-discovery. The client has a web-based application with a SQL Server database backend. At this point I'm assuming we'll set them up with some kind of stand-alone reporting server and replicate the application data to it. Caroline On 5/2/05, Dawson, Michael <[EMAIL PROTECTED]> wrote: > I'm not sure where you are with this project or if you will pull data > from multiple sources, but look at Embarcadero's tools. They have a > great offering. > > M!ke > > -----Original Message----- > From: Caroline Wise [mailto:[EMAIL PROTECTED] > Sent: Monday, May 02, 2005 4:20 PM > To: CF-Talk > Subject: SOT: Data Warehousing - Help a newbie > > All, > > One of our clients is interested in setting up some kind of enterprise > reporting solution/data warehousing system. I'm trying to get a feel for > what kind of tools are out there, other than Crystal Reports / SQL > Server Reports and what kind of experience you have had with them. > > Actually, if someone has some experience (good or bad) with CR or SQL > Reporting Server, I'd be curious as well. > > Also links to good resources would be appreciated. > > Thanks so much, > > Caroline Wise > Senior Applications Developer > Interactive Sites > > 480-707-1600 x223 (office) > 480-707-1601 (fax) > > http://www.interactivesites.com > http://www.planitonline.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205346 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
