COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: Nemo on 03 Feb 2016 07:07:32 AM

Title: What is the best way to connect MS Azure SQL DW with Cognos?
Post by: Nemo on 03 Feb 2016 07:07:32 AM
Hi,

Can someone help me with this one. My client has MS Azure SQL DW (cloud) and Cognos BI v10.2.2 (on-premises). We are testing this and I'm wondering what is the best (for reporting performance point of view) way to do this?

We have done testing with JDBC connector (MS JDBC v4 drivers), but it didn't work. We have tested also with ODBC connector (this works), but is this the only way to do it or is there any other way to do this (with good/high performance on reporting)?

-Nemo
Title: Re: What is the best way to connect MS Azure SQL DW with Cognos?
Post by: jlouis on 17 Jun 2016 11:56:41 AM
Any luck with this? I'm trying to figure out the same thing.