COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: adoremars on 26 Feb 2016 06:25:50 AM

Title: Connecting Cognos 10.2.2 to Maria DB
Post by: adoremars on 26 Feb 2016 06:25:50 AM

Hi All,

Does Cognos supports Maria DB? If yes, can you please provide the steps to create data source connection?

Thanks much.
Title: Re: Connecting Cognos 10.2.2 to Maria DB
Post by: MFGF on 02 Mar 2016 05:16:54 AM
Quote from: Adoremars on 26 Feb 2016 06:25:50 AM
Hi All,

Does Cognos supports Maria DB? If yes, can you please provide the steps to create data source connection?

Thanks much.

Not seeing it listed on the Supported Environments page, so it looks like you're out of luck here:

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

MF.
Title: Re: Connecting Cognos 10.2.2 to Maria DB
Post by: the6campbells on 03 Apr 2017 11:53:04 PM
Yes as of  11.R5  when using Dynamic Query engine where your connection would use the MySQL Connector/J JDBC driver.
Title: Re: Connecting Cognos 10.2.2 to Maria DB
Post by: Invisi on 07 Apr 2017 04:38:19 AM
MariaDB is basically MySQL but then pureblood and Oracle free.
Title: Re: Connecting Cognos 10.2.2 to Maria DB
Post by: sesidhar9 on 22 May 2017 02:43:36 AM
Any outcome for this post..is cognos 10.2.2 is compatible with MariaDB? atleast can we use MariaDB 5.1 version as datasource for cognos 10.2.2 as they says its same replica as MYSQL5.1
Title: Re: Connecting Cognos 10.2.2 to Maria DB
Post by: the6campbells on 13 Jun 2017 05:30:05 PM
Prior to 11.R5, there is no claim that Cognos Analytics has been tested via JDBC to MariaDB.

As of 11.R5, it is listed as tested using the MySQL JDBC driver.

So pre-11.R5 using JDBC it would be caveat emptor.