Cognos to MS BI

  • We have a requirement of migrating cognos reports (around 200) to MS BI reports. Could someone throw us some light on how to migrate cognos reports to ms bi - SSRS reports?

    Any articles/documents/ideas would be really appreciated.

    Thanks in advance.

    Loganathan

  • I know there was a white paper and web cast for Crystal to SSRS, have not seen or heard of one for Cognos. It sounds like William Pearson III might have some very useful knowledge based on the comments in this blog posting though (haven't seen anything on the web yet in regards to this or in the MSDN forums).

    Peng! (Crystal to SSRS Migration Guide) [read the comments]

    Migration from Cognos ...[/url]

    Migrating from Business Objects Crystal Reports to SQL Server 2005 Reporting Services

    MSDN Webcast: Migrating Your Crystal Reports to SQL Server 2005 Reporting Services (Level 100)

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • Dear Dan,

    Thanks a lot for your contribution. But still searching for some valuable documents on cognos to SQL 2005 migration.

    Logan

  • Don't believe there is anything officially posted and available. I found another recent posting in the MSDN forums - Migrating Cognos 8 to Reporting Services[/url]. Sounds like you will want to stick to the same concepts as in the Crystal Migration paper and map everything out appropriately. I checked a couple of Cognos forum areas and did not find anything either. Best bet would probably be to talk to contact a local consulting company to see if they have any experience in doing this type of a conversion.

    ----------------------------------------------------------------------------------------
    Dan English - http://denglishbi.wordpress.com

  • logan.techdump (12/22/2008)


    We have a requirement of migrating cognos reports (around 200) to MS BI reports. Could someone throw us some light on how to migrate cognos reports to ms bi - SSRS reports?

    Any articles/documents/ideas would be really appreciated.

    Thanks in advance.

    Loganathan

    Are you using Oracle or SQL Server Technology!?

    Cognos is much better if your databases are running in Oracle, why not also in SQL!

    😉

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • We are using SQL Server 2005 for our datawarehouse/data mart and found SSRS is very effective and perfect. Also it comes along with database pack for free. We are in the process of cutting costs and migrating cognos reports to SSRS will result in saving pennies.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply