Migration

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.

Your response is appreciated.
Thanks
Jay


Jay Raj (BOB member since 2004-02-03)

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.


Steve Krandel :us: (BOB member since 2002-06-25)