Home > Ask the Oracle Database / Applications Experts > Data Warehousing, ETL, and business intelligence Questions & Answers > Areas of impact while migrating database from 8i to 9i/10g
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Areas of impact while migrating database from 8i to 9i/10g

Ian Abramson EXPERT RESPONSE FROM: Ian Abramson

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 17 October 2005
We are supporting a BI/data warehouse application. Now the backend database is migrating from Oracle 8i to Oracle 9i/10g. We are using Oracle Express Analyzer 6.3.2 as the OLAP tool for report generation. We would like to know the impact and areas of concern, compatability and dependencies of this upgrade. Help us with our impact analysis.

>
The question that you pose is one that many people need to consider as technology continues to evolve and the Oracle OLAP products are no different. So I asked my colleague Chris Claterbos for some advice. When is comes to these types of questions he is the person I turn to. According to Chris this is what you should consider:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Data Warehousing, ETL, and business intelligence
Analyzing an index after rebuild
Speed of low-cost query
Data warehouse based on operational data model
Method other than DB link for large data transfer
Data migration with ETL
Basic steps for implementing a DBMS
Importing 8i dump file to 9i
Using export/import process to clone to data warehouse
External tables explained
Can ETL tools handle complicated business logic?

Oracle data warehousing
BI strategies of Oracle and the megavendors
Exadata: A first look at Oracle's entry into the appliance market
Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed
Oracle's Top 8 stories of 2008
IOUG chief discusses OpenWorld, DBA pay and security
Oracle enters the appliance market with Exadata
Tip: Exposing logical attributes with virtual columns
Oracle users prepare for MDM
Data modeling tools no substitute for hard work
eHarmony spurns Microsoft, finds match with Oracle 10g

Oracle business intelligence and analytics
BI strategies of Oracle and the megavendors
Ventana's Mark Smith on Hyperion and Oracle BI
Has Oracle's BI strategy become smarter with Hyperion?
Oracle's Primavera PPM software plans to be showcased at OpenWorld
Oracle snaps up GoldenGate Software
Will Sun help Oracle eclipse IBM?
Customizing reports in Oracle CRM On Demand
Oracle New Year's resolutions, part 2: GRC tips and customer resolutions revealed
Oracle's business intelligence unit scores a win at the polls, signs Gallup
Oracle's Fusion Applications: Way behind or right on track?
Oracle business intelligence and analytics Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
multidimensional database  (SearchOracle.com)
operational data store  (SearchOracle.com)
repository  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts