Why I created a blog

Its been many years since I first created this blog. It has remained true to Essbase and related information over those years. Hopefully it has answered questions and given you insight over those years. I will continue to provide my observations and comments on the ever changing world of EPM. Don't be surprised if the scope of the blog changes and brings in other Hyperion topics.

Wednesday, February 24, 2021

Connecting Oracle Analytics Desktop to Essbase 19c

 I had a client the other day want to Connect from Oracle Analytics Desktop to their Essbase 19c instance (and from Power BI) but when they tied they were getting a number of different errors about not finding the server. It had been a while since I got this working on my laptop and I had forgotten what I needed to do to get it to work. I went googling for the answer and didn't find it anywhere, so for when I forget and need this again and for you my blog readers and those who search for an answer, here is what needs to be done. 

First, you need to get your certificate from your Essbase 19c environment. To do that, first log into your Cloud UI . As a note, I have found it best to do this from Chrome. Firefox does not give you the same options. Click on the little padlock next to the URL


You will get the following:


Click on Certificate to get:


Click On the details tab, and then copy to file:


On the next screen make sure you select DER encoded binary X509 cer. the click next.


Save the file onto your machine making sure you save it as a  DER encoded binary X509 cer. type


Navigate to where you saved the downloaded certificate and double click on the certificate, you should get sothing like:


Click on Install Certificate;

This will bring you to the certificate Import Wizard


I changed mine to local machine and clicked Next


I let the system select the correct certificate store You will get a confirmation page 


If it looks good (How would you know), click finish. 

It will give you a confirmation that it imported successfully. I forgot to capture that screen image. If it does not import, you might have security issues or are missing JAVA on your machine.


But wait, we are not done yet. There is one more thing we need to do. 

In your system tray in the search, type Environment. You want to find Edit the System Environment variables 


Select that. On the screen that comes up, select the Environment Variables button



Create a new variable. In my case, I did it as a user variable, but you can do either a user or system variable


 In the dialog that comes up The variable name is API_DISABLE_PEER_VERIFICATION

and the value you need is 1  (This is a numeric 1 in case the font makes it look like an l or I)



Click OK, Close the environment variables and other windows you opened to do this, and you should good to go . You should not get errors any more trying to connect.