nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Can OBIEE 12c connect to 2 Essbase cubes: one on premise and one on the cloud?

PeeyuSoo

Hi forum

Has anyone tried importing an Essbase cube on public cloud (in our case Oracle Fusion GL cube) and another on-premise Essbase cube in the RPD using OBIEE 12c (on-premise)?

I saw that importing 2 Essbase cubes is possible with 12c:

Can OBIEE 12C be connected to 2 Essbase cubes?

Thanks a lot for your help!

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

As stated in the other thread you can connect to 100 cubes since 10.1.3.2 if you feel like it that has nothing to do with version.

Cloud will be the issue. Not sure that you can have a direct connection string which the RPD connection pool object will be able to use to establish a connection any time soon. I.e. not in the current incarnation.

2838450

Thanks Christian. Do you know why it won't be possible create a connection pool to the the Fusion Cloud GL Essbase cube please? Docs states that BI Server uses Essbase client libraries to connect to Essbase data sources.. so wouldn't it just mean specifying the hostname and port?

Saw this:

Using Non-Oracle, and Cloud-Hosted Databases with OBIEE 11g - Rittman Mead Consulting

so thought if 11g can do it why not 12c?

or is the c in 12c not really cloud :-p

[Deleted User]

Well have you tried it?

2838450

Not had a chance yet unfortunately. I will give it a go as soon as I get something to play with. Was hoping someone else has tried before...

Gianni Ceresa

Actually the question is not if OBIEE 12c can do it but more to know if Fusion Cloud GL Essbase cube really act like a "LAN" cube. So are the same services and protocols available? (I assume there is probably a VPN and your cloud cube isn't exposed like that to everyone ....)

So if you can connect by command line from your laptop using the Essbase client to your Fusion Cloud GL Essbase cube then 98% chances (+/- 2%) OBIEE 12c can makes it as well.

Just don't complain about performances as it will also depend on the connection between your OBIEE server and the cloud instance (again I really hope, and assume, there is a VPN in between).

I don't have any Fusion Cloud GL Essbase cube available to test (and didn't use one for now), so can't tell you more.

As long as your cloud act as a local network hosted cube it's fine for OBIEE...

[Deleted User]

yeah +1 on that

Upcoming Event

Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…

Top Leaders