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.