Cognos Impromptu

[iadba]

Does anyone know if it is possible to convert a Cognos Impromptu catalog and associated queries/reports from Informix to Oracle without having to recreate all of the reports from scratch?

[nabeel]

I think you have to re-create the catalogs... which version of Cognos you are using?

[iadba]

It's version 6.0. We're really just testing it out now. The developer has made a copy of the original catalog, changed it to pointing to the Oracle database, and tried to create new reports and run previously existing reports. The new reports work fine, but the old reports get an error stating that it can't find the columns specified or can't find the table.