Skip to main content
R
rleir17-Peridot
17-Peridot
April 7, 2021
Solved

Cognos to Jasper migration

  • April 7, 2021
  • 2 replies
  • 7057 views

Hi all,

Will there be help in WC 12 for people upgrading from WC 11 with many Cognos reports, to help them migrate the reports to Jasper?

thanks -- Rick

    Best answer by JeffZemsky

    Some background information for the thread

    1. Customers who have Windchill Business Report Author (Cognos) will be able to continue to use Cognos and their custom reports through the Windchill 12.0.2 release stream
      1. Cognos will not be shipped or available for Windchill 12.1.0.0 and beyond
    2. Customers should plan to transition any custom reports to JasperReports Library during the Windchill 12.0.2 timeframe.
      1. Information on creating custom reports with JasperReports Library can be found in Help:  Jasper Report Customization in Windchill
    3. There are no tools or frameworks to convert a report from one BI framework to another.  Any custom reports will have to be recreated.  Data sources such as Query Builder and Info*Engine can be reused in creating reports with JasperReports Library
    4. There is a an FAQ that can be found on the Support site here:  FAQ: Cognos to Jasper Reports

    2 replies

    A
    acoash11-Visitor
    1-Visitor
    April 12, 2021

    I also have this question!

    R
    rleir17-PeridotAuthor
    17-Peridot
    April 13, 2021

    And more generally, how long can we continue to use the old Cognos reports? Someone said that they would continue to run until 12.01 but you should consider that hearsay. And that the out-of-the-box Cognos reports would be converted to Jasper by PTC? But if, further to that, you wrote more Cognos reports you might need to acquire a Cognos license from IBM? There are several questions above, please help!

    cheers -- Rick

    N
    nmelyani13-Aquamarine
    13-Aquamarine
    June 25, 2021

    Hello Rick, 

     

    Not sure of you got the answer to your request, just found it. to answer your questions: 

    • PTC will provide the OOTB Cognos Report with Jasper
    • Customers will need to migrate their custom reports themselves  as this is third party to third party migration, there are few hints online (convert the cognos reports into xml's for easy reading through the SQL and then create new jrxmls)
    • Cognos will be supported with Windchill versions and will be discontinued starting 12.1.0.0
    • until 12.1 the normal use of Cognos is still in place. 

    I hope this helps

    Nisrine 

     

      J
      JeffZemsky17-PeridotAnswer
      17-Peridot
      November 3, 2021

      Some background information for the thread

      1. Customers who have Windchill Business Report Author (Cognos) will be able to continue to use Cognos and their custom reports through the Windchill 12.0.2 release stream
        1. Cognos will not be shipped or available for Windchill 12.1.0.0 and beyond
      2. Customers should plan to transition any custom reports to JasperReports Library during the Windchill 12.0.2 timeframe.
        1. Information on creating custom reports with JasperReports Library can be found in Help:  Jasper Report Customization in Windchill
      3. There are no tools or frameworks to convert a report from one BI framework to another.  Any custom reports will have to be recreated.  Data sources such as Query Builder and Info*Engine can be reused in creating reports with JasperReports Library
      4. There is a an FAQ that can be found on the Support site here:  FAQ: Cognos to Jasper Reports
      R
      rleir17-PeridotAuthor
      17-Peridot
      November 4, 2021

      Hi Jeff

      Thanks for that info. 

      In point 4, the FAQ that you link to gives me :

      "Note: This article 352015 is not customer visible."

      Rick

      J
      JeffZemsky17-Peridot
      17-Peridot
      November 4, 2021

      @rleir The article should be available today if it is not already.  Sorry for the confusion.

        Terms & ConditionsCookie settingsAccessibility statement