We're currently running reports on our warehousesytem that is based on a ORACLE database. In the near future we will change to DB2 as our database for the application. The table structure will remain the same. Can I still use the current reports or will I have to build new universes on DB2 and start all over again with the reports?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Changing universe connection from ORACLE to DB2
- Thread starter blom0344
- Start date
AndyEdwards
Technical User
If the table structure remains exactly the same (most importantly table and column names as the select statements in your universe objects point to tablename.columnname) then it should be as straightforward as just changing the connection.
This will then follow on to the reports, if the universe is the same then the reports will run without any changes needed.
As a disclaimer (!) I have implemented it between other databases but not between Oracle and DB2.
Hope this is useful
Andy
This will then follow on to the reports, if the universe is the same then the reports will run without any changes needed.
As a disclaimer (!) I have implemented it between other databases but not between Oracle and DB2.
Hope this is useful
Andy
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip