Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Migration

Received Response
21
Views
8
Comments
Captain_Cook
Captain_Cook Rank 2 - Community Beginner
edited Aug 13, 2024 6:06PM in Oracle Analytics Cloud and Server

Hello,

I am working for a financial company. We are planning to migrate from Oracle 11g to PostgreSQL. There are over 100 reports we have created using OBIEE 11.1.1.7 version (Ad-hoc layer, Direct Database, BI Publisher).

I wanted to know if there are any issues in migrate catalog from Oracle 11g to PostgreSQL I realize my database queries need to be rewritten but are there are other things I need to be aware of?

Answers

  • Gbenga Ajakaye
    Gbenga Ajakaye Rank 5 - Community Champion

    Are you just migrating the data or you intend on migrating other objects like procedures, functions, Packages, BLOB, etc?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    OBIEE is a source-agnostic tool for a reason. If you move the physical structures 1:1 to a different source database then OBI will remain unaffected.

  • Captain_Cook
    Captain_Cook Rank 2 - Community Beginner

    I am thinking possible impact areas:

    1) The underlying queries will change so this will have impact to performance?

    2) Rewriting DDR queries (syntax changes from Oracle)?

    3) Performance of BI/Presentation Server exchanges with PostgreSQL in comparison to Oracle

    Do these make sense?

  • Captain_Cook
    Captain_Cook Rank 2 - Community Beginner

    Migrating everything - tables, functions, data. RPD is based on Oracle db that will point to PostgreSQL post migration.

  • Joel
    Joel Rank 8 - Analytics Strategist

    A point worth noting is that if you haven't side stepped the repository by building Direct SQL reports then your changes will minimal and they'll  just be to the connection pools in the physical layer. Opaque views  are another that will need to be changed if you have any.

  • Captain_Cook
    Captain_Cook Rank 2 - Community Beginner

    Right, that is one thing I am thinking. We have about 50 reports using DDR

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    What's the point of using OBI then?

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Captain_Cook wrote:1) The underlying queries will change so this will have impact to performance?2) Rewriting DDR queries (syntax changes from Oracle)?3) Performance of BI/Presentation Server exchanges with PostgreSQL in comparison to Oracle

    1) The queries generated based on the RPD will change just because the DB is a different one, but the concept of RPD is there to give you the same data out (as long as your model is correct of course). From a performance point of view you can't really compare as it depends on too many aspects, so you can only evaluate that afterwards and do the required analysis to identify new / different bottlenecks.

    2) Well, here you already know it, DDR will not survive for any Oracle-syntax, so yes, rewriting is possible/probable.

    2 b) You said you have Publisher: if you built datamodels on your DB you will have to change that as well as it's outside of the RPD as well.

    3) The Presentation Server will have the same exact performance as it doesn't talk with the DB, the BI server possible impact is what you cover in 1).