How do i migrate reports from existing platforms to new reporting platforms. Existing platforms are based on Cognos and multiple back-end databases: Oracle, SQL server and DB2. New platform will be Oracle and Business Objects.
You really don’t migrate them. You pretty much have to start over. But, you do have an advantage. The existing reports serve a very detailed specifications. You can certainly use the SQL code from the old reports to help validate that you have built your BO universe correctly.
If you’re looking for automated tools to do this, I think you’ll be disappointed.