OBIEE Migration

Captain_Cook

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?

Gbenga Ajakaye

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

[Deleted User]

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

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

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

Joel

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

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

[Deleted User]

What's the point of using OBI then?

Gianni Ceresa

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).