COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS 8 Administration => Topic started by: tupac_rd on 08 Apr 2010 10:13:36 AM

Title: Lotus Notes database
Post by: tupac_rd on 08 Apr 2010 10:13:36 AM
Hi All,

Has anybody been able to successfully query against a Lotus Notes db using Cognos 8.4 or 8.4.1, if yes what version of the Lotus Notes Driver did you guys use.

thanks
2pac
Title: Re: Lotus Notes database
Post by: cognosfan on 07 May 2010 02:30:47 AM
Hi
we use NotesSQL ODBC driver 3.02i
After some efforts we made it to work correct
Title: Re: Lotus Notes database
Post by: Ganesh Kedari on 10 May 2010 10:14:21 AM
Is there any documentation or How-To available while working with Lotus Notes database as datasource to cognos?
Title: Re: Lotus Notes database
Post by: tupac_rd on 11 May 2010 10:33:54 AM
cognosfan,

We are using the 3.02 version as well. Just wanted to see if somebody is using a more later version, so that all the stuff we need to make the 3 version work, is not needed.

Thanks
2pac
Title: Re: Lotus Notes database
Post by: tupac_rd on 11 May 2010 01:03:00 PM
cognosfan,

by the way what other stuff you had to do to make it work.... Did you have to change the query for query subjects in Framework Manager from Cognos SQL to Native SQL, manually everytime you import a new query subject.

Thanks
2pac