COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: adoremars on 23 Jul 2015 06:58:12 AM

Title: SQL Server PDW as Cognos content store
Post by: adoremars on 23 Jul 2015 06:58:12 AM
Hi Team,

I wanted to know whether Microsoft SQL Sever PDW can be used as the content store for Cognos BI 10.2?

I understand that SQL server supports content store, but how about PDW (whether both are same)?

Any ideas are much appreciated.

thanks much..
Title: Re: SQL Server PDW as Cognos content store
Post by: cognostechie on 29 Jul 2015 04:35:04 PM
As little as I know about PDW, it is a collection of objects to facilitate concurrent processing of multiple parts of the same query to speed up the execution of the query. Content Store needs one single DB and the size of Content Store will be nowhere near the size of a huge DB containing data. What's the point behind this?