Can OAC Desktop Client (DV Desktop) connect to Oracle EPM CLOUD ?

kalikhan

Summary:

In OAC cloud, I can create a connection to 'Oracle EPM Cloud' and do reporting from Hyperion PBCS application. But in OAC Desktop (or DV Desktop) I am not seeing 'Oracle EPM Cloud' option when I create a new connection definition in OAC desktop.

(1). Is there a way to connect OAC Desktop to Oracle PBCS cloud service?

(2). Similarly, is there a way to access RPD Subject areas (of oac cloud) in OAC Desktop?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Wayne Van Sluys11111

1) No, that connection is not available

2) you can connect to the OAC/OAS Instance via Oracle Applications connection or via JDBC connection

-W

kalikhan

Thanks Wayne

After reading your second answer, I tried to create a new connection in OAC Desktop using 'Oracle Applications' and for HOST I entered my oac cloud instance url (first part is hidden here):    https://xxxx.analytics.ocp.oraclecloud.com/analytics

but I keep getting error: INVALID HOST NAME Why does it give this error?

For JDBC connection, what will be the "Driver Class Name" ? Is the URL going to be the same as above?

Wayne Van Sluys11111

I thought i had previously connected from Desktop to OAC. I got same error when I checked. I suggest opening an SR

Here is info on JDBC to OAC

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/query-data-models-remotely-using-jdbc.html

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/query-data-models-remotely-using-jdbc.html

-w