SAP Analytics cloud Live connection to Universe configuration

[rpuranik]

Hello,

We are on BI 42 SP5 P100, Linux environment with Load balancer, 2 tomcat servers (webapps and RWS deployed) and 2 CMS BOE servers (tomcat installed but not started), LDAP authentication, Configured Live connections to SAP universes on SAC.

In DEV, currently the only configuration that works for me is by deploying and configuring the SAC live data connection on our "CMS BOE" server by enabling the tomcat and enabling SSL on the CMC BOE server and not on the tomcat server. I had to request SSL cert to be created just for our CMS server which I don't think our Co will allow for prod environments. They don't allow https connections directly to the app server while we have tomcat server where SSL is enabled.

Can I configure the same on the tomcat server instead of CMC BOE server, since I already have SSL enabled as well as RWS deployed on tcat? If so, is there a document that you can direct me to? Please advise.

Sorry if this info is out there somewhere but I just cant find anything related to what I am looking for.

Thanks!

[julian_jimenez · Accepted solution]

Hi Roopa,

You should be able to install it in any other server on your network as long as you install Tomcat and deploy the BOE Live Connector and configure to connect to your RESTful server.

The only server that requires SSL is that Tomcat server with BOE Live Connector deployed. This certificate has to be trusted by the client as you connect via CORS and your browser will send two requests and both need to be HTTPS.

When you configure this BOE Live Connector, you only need to indicate in its file boe.properties the URL for your WACS servers.

http://your_bi_wacs_server:6405

Cheers,

Julian

[rpuranik · Accepted solution]

Okay Thank you Julian. I tried but it is not working. I will take a look again if I am missing any step.

[julian_jimenez · Accepted solution]

Hi Roopa,

I was testing in different servers and what I found is that sometimes the Java options were not read correctly.

In the step 2, they offer different options to assign these values:

https://help.sap.com/viewer/8c42716c6977461b8eec8216a28ac1a6/4.2.5/en-US/14b7943431bb4fb08b73b6ef4f4...

One way to be 100% sure that the parameters are correctly read by Tomcat was enabling traces with the file bo_trace.ini. If I don't get traces generated in the file I indicated in bo_trace.ini, these Java parameters were not loaded.

For deployment, I find it easier to rename the default cs_ina_agent.war as sap#boc#ina.war

As indicated in the section Deployment:

https://help.sap.com/viewer/8c42716c6977461b8eec8216a28ac1a6/4.2.5/en-US/39858aeb95fb445e94e845f551e...

Also, if you deploy using the method I indicate, verify that in server.xml you don't have this line:

<Context docBase=”cs_ina_agent” path=”/sap/boc/ina” reloadable=”true”/>

Thanks,
Julian

[IngoH]

Hi,

take a look at the configuration details here:

https://www.sapanalytics.cloud/guided_playlists/connect-sap-universe-live/

Regards

Ingo Hilgefort, SAP

[rpuranik]

Hello Ingo,

Thanks for the reply. I have gone thru this document and configured but this does not answer my question.

Looks like the live configuration only works if tomcat (with SSL enabled) and CMS are ALL on the same server. In our case we have it separate, we don't have SSL enabled on CMS but we do on a separate tomcat server.

Thanks!