COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: Jeremy Gibson on 03 Jul 2012 02:40:54 AM

Title: SQL Server 2012 does this work with Cognos 10.1?
Post by: Jeremy Gibson on 03 Jul 2012 02:40:54 AM
Has anyone experience of connecting Cognos v10 to SQL Server 2012. Any issues so far?
Is SQL Server 2012 formally supported by Cognos 10.1 yet? if not any thoughts on possible availability?

I'd like to know if you have accessed SQL Server Analysis Services Cubes and relational tables.
Has anyone has used the new columnstoreindex feature in SQL Server 2012 and does this work with Cognos v10.

Regards
Jeremy
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: robber on 05 Jul 2012 11:01:01 AM
I could not connect to sql server 2012 using native or oledb connection. I spoke to someone at Cognos and they confirmed sql server 2012 is not yet supported. This link also confirms it:
http://www-01.ibm.com/support/docview.wss?uid=swg27021368#db
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: MFGF on 09 Jul 2012 09:31:33 AM
If SQL Server 2008 native client doesn't work, I'm guessing that JDBC and ODBC probably will, but of course they will not be supported at present. If you want to log anything with IBM you will need to reproduce it against a supported version of SQL Server in order to get support.

Regards,

MF.
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: EarthDog on 24 Aug 2012 05:09:23 AM
Any news on this?

i would love to move to 2012 as i am in the start of redesigning my SSIS processes and i want to update them in 2012 SQL....
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: MFGF on 24 Aug 2012 11:33:57 AM
I would imagine there will be a short wait until IBM can add support for SQL Server 2012 and test it before releasing. It's not supported currently is all anyone can say.

Cheers!

MF.
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: highroller on 12 Sep 2012 10:23:54 PM
It is now supported in version 10.2
:D

http://www-01.ibm.com/support/docview.wss?uid=swg27027080
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: MFGF on 13 Sep 2012 07:28:06 AM
Quote from: highroller on 12 Sep 2012 10:23:54 PM
It is now supported in version 10.2
:D

http://www-01.ibm.com/support/docview.wss?uid=swg27027080

Yep! I couldn't say that on 24th August, though :)
Title: Re: SQL Server 2012 does this work with Cognos 10.1?
Post by: EarthDog on 14 Sep 2012 04:02:10 AM
will have the media end of next week and will update.