Clarity PPM

Expand all | Collapse all

Any experience running Jaspersoft on SQL Server 2016?

  • 1.  Any experience running Jaspersoft on SQL Server 2016?

    Posted 02-28-2018 07:38 AM

    Hi. The infrastructure area of the company is going to upgrade his database cluster. Currently we are running CA PPM 15.3 + Jaspersoft 6.2.1 on a MS SQL Server 2014 (SP2) instance. The DB cluster will be upgraded to SQL Server 2016 in a while.

     

    We are aware that the official compatibility documentacion mentions SQL Server 2014 as the only supported database engine for Jaspersoft.

     

    Source: Release Notes (On Premise) - CA PPM - 15.3 - CA Technologies Documentation 

     

    But, as happened on other releases, this could be only a lack of certification and not necessarily a technical incompatibility.

     

    Do you have any succesfull experience running Jaspersoft 6.2.1 on SQL Server 2016 ?

     

    Regards



  • 2.  Re: Any experience running Jaspersoft on SQL Server 2016?

    Posted 02-28-2018 09:02 AM

    Hi Juan,

    Based on the Jasper 6.2 documentation certification matrix, it looks like SQL 2016 is not mentioned, thus it is not currently certified.  The certification matrix can be found here:  Certification Matrix - CA Business Intelligence JasperReports® Server - 6.2.0 - CA Technologies Documentation 

    Thanks,

    Jon I.



  • 3.  Re: Any experience running Jaspersoft on SQL Server 2016?

    Posted 05-08-2018 04:32 PM

    Thank you, Jon. Clearly is oficially not supported.

    But sometimes the lack of support is only a matter of time until CA certifies newer releases.

    So, we wonder if anyone could make Jaspersoft run on SQL 2016 despite this.

     

    Juan