Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Create DataVisualizations using DV against Essbase Cloud with https protocol

Received Response
51
Views
3
Comments
R Abel
R Abel Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Connection issue when Essbase Cloud Service now requires encrypted passwords - how to access from DV?

Content

Hi,

I am trying to set up a demo connecting from DV (OAC instance) against Essbase Cloud like last year. The connection from OAC DV instances is now not working anymore using DSN https://Essbase-IP-adress:9000/essbase/agent (trying different users/passwords and ports) - does somebody have similar experience and solved it? Any ideas, which steps need to be performed?

I try to follow these steps: https://docs.oracle.com/en/database/other-databases/essbase/19.3/essad/set-ssl-certificate.html  - I am specifically wondering which self-signed certificate to provide (have no load balancer setup) and not sure if this is the root cause at all.

Background: Since March 2020, Essbase Cloud instances have encrypted passwords and https protocol. It looks like self-signed certificates are used and additional setup is required on Linux Server level in Essbase cloud. Can somebody confirm, that these steps here are important/ required for connection from DV? Or is the issue more in the OCI Firewall setup? I have similar connection issues with DVD (tested this to separate OAC issues from Essbase Cloud issues)

Any ideas and suggestions are welcome

Regards Rodian

Version

Essbase 19c (19.0 / 19.3)

Code Snippet

Failed to save the connection.
Invalid connect string / url to external source.
Tagged:

Answers

  • User_6K1A3
    User_6K1A3 Rank 3 - Community Apprentice

    We are not using SSL, but our connection DSN is "http://Essbase-IP-address/essbase".  We do not have to use the port or /agent suffix.

    Brian

  • Philipp Kaufmann-Oracle
    Philipp Kaufmann-Oracle Rank 4 - Community Specialist

    Hi Rodian,

    I'm experiencing the same issue now that we can only connect ot Essbase from OCI Marketplace using https. I logged an SR and will keep you posted once I got an answer.

    Cheers,

    Philipp

  • Philipp Kaufmann-Oracle
    Philipp Kaufmann-Oracle Rank 4 - Community Specialist

    Hi Rodian,

    I got the solution (thanks to Oracle Support). There are two options:

    1. Use a proper TLS certificate. OAC / DV are not able to work with the provided demo certificate.
    2. Enable port 80 for http access.

    As I don't have a TLS certificate handy, I opted for option 2 (which is probably not the recommended approach for a production environment) which worked perfectly.
    You have to do two things here:

    1. Create a network ingress rule for port 80.
    2. Open port 80 in the firewall on your Essbase node. (see Essbase documentation on accessing WLS console as an example https://docs.oracle.com/en/database/other-databases/essbase/19.3/essad/access-weblogic-console.html)

    Kind regards,

    Philipp