Effort required to run same WebI reports when database is migrated from Sybase IQ to HANA DB?

[bassam]

Hello Experts,

I would like to know what level of effort will be required for the existing WebI reports to be running if we have to migrate the data from SYBASE IQ database to HANA database?

Currently the SAP WebI reports are developed on a Universe using a relational connection on top of SYBASE IQ database.

Plan is to run the same WebI Reports after migrating all the tables/data from SYBASE IQ database to HANA Database.

Do we need to redevelop the reports? or just connection level changes at the universe level will be fine. I am trying to estimate the effort required for this migration.

I look forward to your response.

Regards,

Bassam Jamil

[DellSC]

You'll change the connection in the universe and then validate it to make sure that everything is still working correctly - there may be syntax differences that you'll need to fix. From there, test a random sampling of reports that use that universe. You may or may not need to manually run each report once against the updated universe in order for the SQL to update for any syntax updates.

-Dell