Is there an OLAP tool available that has direct connectivity to an Oracle database, or is using a text file the norm when dealing with Oracle?


Chuck Kelley’s Answer: Most OLAP tools have direct connectivity to Oracle databases (using SQL*Net and not ODBC). The second question can be interpreted 2 ways – text file to Oracle or a text file from Oracle. It could also mean text file when dealing with an OLAP tool from Oracle. There are times when you might consider using text file interfaces. During transformations, you may create a transformation that, as a part of the normal run, creates the output need for the Oracle data warehouse as well as a multidimensional database rather than loading the data warehouse and then building a text file for the OLAP tool. I certainly tend to believe the final output of all major dimensions and facts from the transformation process are flat files, which we will then load with the DBMS vendors bulk load facility (SQLLOAD for Oracle).

Douglas Hackney’s Answer: Oracle would probably take the position that their Express OLAP product offers a direct connection to the Oracle RDBMS. If you are referring to a ROLAP or HOLAP product, then all major ROLAP/HOLAP vendors (CA, Microstrategy, Microsoft, Seagate, etc.) would also rightfully claim direct connectivity to the Oracle RDBMS.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access