My company is beginning to migrate from Cognos8 to Microsoft SQL Server Report Builder 3, and we have some very complex reports within Cognos8 that need to move across.
I have seen mentioned online that using the XML from the Cognos8 report, you can import that into Report Builder 3 to replicate the report, however nowhere mentions where to do it? Has anyone had experience with this?
Is it possible to migrate a report from one system to the other, using the XML or the SQL for instance? The underlying database that is being read is the same.
This article Here seems to mention it being possible, Page 5 of 8:
"The Cognos report needs to be in XML
format for the report to be converted to
an SSRS report. Open a Cognos report
via IBM Cognos Report Studio, go to
Tools menu and select “Show Specification”.
From here, one can get the XML
equivalent of the Cognos report.
Data can be retrieved from XML data
sources directly with Reporting
Services using the XML data provider. It
converts XML structure into a data set
and SSRS utilizes the same to generate
reports."