Oracle Communities

Oracle Analytics and AI

Child Item

OBI11.1.1.9 Dynamic database source

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

Find more posts tagged with

Accepted answers

All comments

Yossi Belitsky

HI Christian,

We would like to switch according to an initialization block parameter.

Thanks

Yossi

[Deleted User]

1.) Why "combine"? You said either one or the other. Not "both together".

2.) How is your session variable instantiated? Maybe '0' vs 0 ? Data types are important.

3.) This must work because it's an extremely basic concept that's being used all over the place.

Robert Angel

As Christian says fragmentation does work, I would; -

a. Double check your data source actually has the values you think it does

b. Double check that it always takes the first source by adding; AND 1=2 to the first condition and OR 1=1 to the second - if it fails in this condition then I would open an SR

Yossi Belitsky

Thanks Christian , I tried this also, regarding the data types - unfortunately, didn't work..

Yossi Belitsky

Thanks Robert, I tried this also as you suggested:

first source:

"Alma Funds Expenditure"."D15 Item Loan"."Source" <>'1651'

and 1=2

Second source:

"Alma Funds Expenditure"."D15 Item Loan"."Source" ='1651'

or 1=1

Still it went to the first one..

I think I'll open an SR as you suggested.

Thanks a lot

Yossi

[Deleted User]

As I said this is basic config and must work - so best post screenshots of the business model, the LTS details and so on

Yossi Belitsky

As you could see below the first source "D15 Item Loan" will always be false, and the second "D15 Item Loan_Vertica" should always be true but still the source is pointing to the first not to the second database:

Robert Angel

And any good reason you have the content level set on the first but not on the second?

Can you try with the second also set and see what result you get?