OBI11.1.1.9 Dynamic database source

Yossi Belitsky

HI

I would like to offer a dynamic way to connect within the RPD to two diff sources - one Oracle (using OCI)  one non-Oracle (Connect via ODBC).

Both sources are identical in structure & data.

When connecting to each source with it's own RPD - everything works fine.

Now we'd like to have only ONE OBI server (one RPD) and provide the customer an option to connect to either databases using pre-configured parameters.

Is this possible ? would appreciate help here.

We tried "fragmentation"  in the business model - didn't work.

Thanks

Yossi

Gianni Ceresa

1435218 wrote:We tried "fragmentation" in the business model - didn't work.

How it didn't work?

Because dynamic LTS picking is quite a common thing. It isn't really fragmentation as it is intended, it's more a way to pick LTS1 or LTS2 based on a fake column or a variable or things like that. Your situation is a bit different as it isn't just 1 logical table which need to have that behaviour but all of them, right?

Out of curiosity:

1435218 wrote:Both sources are identical in structure & data.

If both have identical data, what's the point? You get the same things out if both have the same data ....

Yossi Belitsky

Thanks for your answer and comment.

1. Regarding  "fragmentation" - we thought that it might help for using it to defer sources as well.. -  unfortunately it didn't..

2. The two different sources are being used in order to test - for few months - a big data database and compare it to the existing db (by changing a parameter) , using the same business layer (same logic)

Thanks

Yossi

Yossi Belitsky

HI

Any other help in a any way to solve this issue will be more than appreciated

Thanks

Yossi

Christian Berg-0racle

You can make many things dynamic but two different database technologies mean two different call interfaces and dialects (of not languages).

What does the customer expect in terms of "pre-configured parameters"? There are several approaches for sure.

Robert Angel

Still not understanding why fragmentation would not work for you, couldn't you use a condition that is always true on the source you wanted, and a condition that is never true on the source you do not want, and drive the condition by variables??

Fragment1 (currently wanted)

EnterpriseModel."Creation_Date" > VALUEOF("FragOne Date")

Fragment2 (currently not wanted)

EnterpriseModel."Creation_Date" > VALUEOF("FragTwo Date")

Where you set "FragOne Date" to be some far past date and "FragTwo Date" to be some far future date

Yossi Belitsky

I know there could be differences between the two in terms of "pre-configured parameters"

Assuming the two databases will use the same general parameters  then if we would be able to do this switch between them - will be great.

Thanks

Yossi Belitsky

Thanks  for the Fragmentation explanation -

The funny thing is that when switching between two tables in the same source - it works fine,

but among two data sources - it always uses the first one and ignores the second...  (maybe a bug - not sure)

Thanks

Yossi

Robert Angel

Hi,

I have used fragmentation from two wholly different data sources and not had any problems, and on your exact version of OBIEE.

Can you show a screenshot of your fragmentation set up?

Christian Berg-0racle

Yes but switch HOW? What do they expect? A button? a server restart? A fairy wand?

Yossi Belitsky

HI Robert

Thanks a lot.

I would really appreciate seeing your way how this worked.

Please see screenshots below with our try.

The problem is that no matter what order of the sources was - the OBI always used the first source...

Thanks

Yossi