- Oracle OLAP is the product you will need to do the same things they are doing today with Oracle Express. It is suggested that you use version 10.1.0.4 or 10.2 if possible.
- As well, Oracle no longer has Express Analyzer, which was a VB application. Therefore, If you are using Analyzer and Oracle Web Agent their Web Agent Application will work directly in Oracle OLAP with a simple export/import.
- The Express Database can be exported and imported directly into 10g OLAP; then a migration script can be run to make it compatible for the new Oracle Reporting tools. If you want to use existing OLAP DML (Express SP) code, this is also supported.
- There are several new front-end tools that do the same thing and MORE than Express Analyzer. This includes Discoverer for OLAP and Worksheet Add-in (similar to Express Excel Add-in). There is no way to migrate the Analyzer Workbooks or Reports into Discoverer. If the client has created reports and moved them to Web Publisher and Web Agent they can be moved directly, but there is no tool to allow modifying these reports or moving them into Discoverer. The best way would be to redefine the reports in the new tools, i.e., Discoverer for OLAP or BI Beans. This is really not a hard thing to do! Maybe 15 minutes per report.
- Finally you have the option of using existing Express Data Model or moving it over to the Full OLAP Standard Model. This can be a gradual thing or can be done as part of the migration.
I hope this helps you to get your migration started.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Ian Abramson
A SearchOracle.com member asks why a low-cost query has a slower speed than expected. Continue Reading
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ... Continue Reading
I am new to Oracle's ETL tool and I need information on data migration using Oracle ETL. Continue Reading