Cognos WEB

Richard Witkopp witkopp@idt.com
Mon, 26 Jul 1999 09:56:28 -0700


Having "bit that bullet" on a medium-size site (took over a year),
I would say the bullet would be doing the biting if the only
reason you were doing the conversion is for the web stuff.
If your web apps are browse only, a data mart built on a relational
database is a good compromise.

> I tend to agree Arthur, but you have to weigh the cost of the 
> ODBC driver
> against the cost of the RDBMS license and the effort to 
> migrate the data and
> applications :-)
> 
> Against that you have the drawbacks such as limited 
> performance which you
> mention (although that might not be an issue on a "lightly" 
> used web site),
> and the fact that the ODBC drivers force you into treating your
> non-relational data as though it was actually in a relational DBMS --
> meaning that any redefinitions, substructures and arrays that 
> you might use
> today will simply not be available any more.
> 
> My own personal preference would be to "bite the bullet" and 
> migrate to a
> relational database. As I said, just my own personal preference.
> 
> Best regards, 
> Conrad 
> 
> > -----Original Message-----
> > From:	Kogan, Arthur(50 Pitt) [mailto:akogan@westpac.com.au]
> > Sent:	Sunday 25 July 1999 8:50 PM
> > To:	Whittall, Conrad; powerh-l@lists.swau.edu
> > Subject:	RE: Cognos WEB
> > 
> > Yes, but ODBC drivers for RMS are rather pricey and would 
> probably be a
> > bit on the slow side.
> > 
> > Arthur Kogan
> > Westpac Financial Services
> > Sydney, Australia
> > 
> > My views are my own and do not necessarily represent the views of my
> > employer.
> > 
> > 
> > 	-----Original Message-----
> > 	From:	Whittall, Conrad [SMTP:Conrad.Whittall@Cognos.COM]
> > 	Sent:	Saturday, 24 July 1999 4:46 AM
> > 	To:	powerh-l@lists.swau.edu
> > 	Subject:	RE: Cognos WEB
> > 
> > 	Conversion to any relational DBMS from non-relational 
> storage such
> > 	as RMS files or TurboIMAGE databases is a non-trivial task :-)
> > 
> > 	Of course, if you want to stay with your non-relational data on
> > 	your trusted mid-range system and try PHWeb on Windows 
> NT (to get
> > 	a feel for what it can do ) you can use an ODBC driver 
> at the PHWeb
> > 	Windows NT end to access the data on your OpenVMS, 
> MPE/iX or even
> > 	OS/400 server.
> > 
> > 	Best regards, 
> > 	Conrad 
> > 
> > 
> > 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
> = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to 
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to 
> majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a 
> subscriber.
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.