Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: saumil287 on 21 Aug 2012 07:53:45 AM

Title: Ingres database as a datasource support in linux for Cognos
Post by: saumil287 on 21 Aug 2012 07:53:45 AM
Hi All,
I am having a client whose database is Ingres and installed in Linux environment.
How to connect to ingres database in linux with Cognos BI enterprise.

Your guidance is appreciated.

Thanks in Advance
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: tjohnson3050 on 23 Aug 2012 01:21:31 PM
Postgres is supported via ODBC, but it doesn't appear that Ingres is a supported database for Cognos 10.1.1:

http://www-01.ibm.com/support/docview.wss?uid=swg27021368
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: MFGF on 24 Aug 2012 06:16:44 AM
According to the document, Ingres Vectorwise (Actian Vectorwise) 1.6 is fully supported via ODBC. If you're on something like Ingres 10 then that would come under "Other Windows ODBC 3.5 compliant sources" I imagine - if you can find an ODBC for it that conforms to the 3.5 spec, it ought to work. That's a big "if", though :)

MF.
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: saumil287 on 24 Aug 2012 07:04:16 AM
Hi,
Thank you for your replys.
I look more into it and let you know.

Thanks again
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: tjohnson3050 on 24 Aug 2012 08:33:27 AM
One more thing, you didn't mention where Cognos is installed, keep in mind that ODBC connections are only supported if Cognos is installed on Windows.
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: MFGF on 24 Aug 2012 11:20:44 AM
Quote from: tjohnson3050 on 24 Aug 2012 08:33:27 AM
One more thing, you didn't mention where Cognos is installed, keep in mind that ODBC connections are only supported if Cognos is installed on Windows.

Oh! A very good point! My rheumy old muppety eyes missed that it was a Linux environment.
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: saumil287 on 27 Aug 2012 04:18:29 AM
Hi,
Cognos must be installed on linux environment where Ingres is installed or some diff machine of Linux environment.


Thanks again
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: tjohnson3050 on 27 Aug 2012 09:56:04 AM
Cognos does not support connecting to Ingres when Cognos is installed on Linux - period.  You need to let the client know soon and work on a different solution.  For example:

1. Install Cognos on a windows machine and use ODBC to connect to Ingres on Linux.
2. Extract the data from Ingres into a datamart on a platform that is supported by Cognos when installed on linux.

Stick to the supported solutions, or you will most likely fail:

http://www-01.ibm.com/support/docview.wss?uid=swg27021368
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: Lynn on 27 Aug 2012 10:11:37 AM
How is it possible that tjohnson is posting so many great answers all across the forum and yet not getting any applauds!?!?

C'mon people!! Get with the program!! It isn't so hard to click a little link and say thank you.
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: tjohnson3050 on 27 Aug 2012 10:19:21 AM
LOL - thanks for the props Lynn   :)
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: MFGF on 29 Aug 2012 07:21:20 AM
Lynn is right! Let's show our appreciation!!
Title: Re: Ingres database as a datasource support in linux for Cognos
Post by: saumil287 on 29 Aug 2012 11:27:58 PM
Hi All,
Thank you so much for your valuable replies.

Appreciated a lot.

Thanks again
Text only | Text with Images