Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: swagar on 06 Jan 2020 01:23:22 PM

Title: New Database connection - Snowflake
Post by: swagar on 06 Jan 2020 01:23:22 PM
We are trying to use Snowflake, cloud database with Cognos 10.2.  It work with the generic ODBC driver except for a few functions which are named differently.  I believe the Cogdmod.ini is the file to edit to translate database function calls, but I'm not sure what types of statements to put in and where.  I see the general syntax, but how will cognos know to use my new function calls?
Title: Re: New Database connection - Snowflake
Post by: bus_pass_man on 06 Jan 2020 01:54:53 PM
Snowflake isn't supported for 10.2.  It is for 11.1.x and 11.0.13.

https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/prereqsForProduct?deliverableId=1391013543612#sw-7


https://www.ibm.com/software/reports/compatibility/clarity-reports/report/html/prereqsForProduct?deliverableId=E32E9AD000BE11EABCF401BE73544226#sw-7
Title: Re: New Database connection - Snowflake
Post by: swagar on 06 Jan 2020 05:01:05 PM
We did find that using the Netezza database type , Snowflake seems to work except for a few functions.  We found the cogdmod.ini and were able to translate the Netezza functions we needed to snowflake functions. 
Text only | Text with Images