Live Data Connection to SAP Universes

1 1 live data Connection to SAP Universes You can create a live data Connection to SAP universe using the SAP businessobjects Enterprise (BOE) live data Connector component deployed on your application server. Prerequisites for live data Connection to SAP Universes : SAP businessobjects Enterprise BI SP4 system installed Java application server. If you use Tomcat, it must be configured in Secure Sockets Layer (SSL) For a list of supported system types and limitations, please see System Requirements and Technical Prerequisites and Limitations to SAP Universes . 1. Deployment and setup of the SAP BOE live data Connect component 1.

2 Create a context for the component: a. Open the file located in the conf folder of your Tomcat installation directory NOTE: In the below examples, we are using Apache Tomcat shipped with SAP BOE BI platform . 2 b. Locate the Server/Service/Engine/Host node in the file and add the following line: <Context docBase="cs_ina_agent" path="/sap/boc/ina" reloadable="true"/> c. Save the file 2. Create a file in the same conf folder a. Open the file and update it with the following lines # BOE Server info ://<BOE_SERVER_NAME>:6405 compatibleUniverseFolder= Universes /Sampl es temporaryDocumentFolder=BOELiveProviderT empFolder NOTE: By the above specification we configure the Universes /Samples folder to be accessible in English language while using enterprise authentication.

3 You may be able 3 to specify a higher level folder then add view rights only for particular folders in CMC later. You can specify localhost as well if you re using the Tomcat deployed on the same machine as the Central Management System of the BI platform , where 6405 is the default port. Like in the below example: http://localhost:6405 3. Stop Tomcat and point to the file you have just created. You have multiple ways to perform this action according what type of Tomcat you are using. Standalone Tomcat (batch) i. Open file ii. Set the JAVA_OPTS variable at the beginning of the file: set JAVA_OPTS=%JAVA_OPTS% -DBocInaAgentConfigurationFile=<BOE_PROP_PATH> 4 Standalone Tomcat (Service) i.

4 Run the executable file ii. In the Java tab, add the following line in Java options: -DBocInaAgentConfigurationFile=<BOE_PROP_PATH> NOTE: If your Tomcat runs on Linux or you re using the Tomcat shipped with SAP BOE BI platform , follow the steps as described in our SAC Documentation. 4. Download and deploy the SAP BOE live data connect component a. Go to SAP Software Downloads page and login with your SAP Credentials b. Enter live data Connect into the search bar at the top 5 c. Download the latest version of the SAP BOE live data Connect component d. Extract the zip file and copy the file to your Tomcat > webapps directory e.

5 Start Tomcat 5. Configuring Cross-Origin Resource Sharing (CORS) When deploying the component, you can configure CORS requests so that the browser accepts requests coming from the SAP Analytics Cloud server. It's a way to secure the component by making sure that you control what servers are accessing your BI system via the component. 6 NOTE: If you are using a reverse proxy, you don't have to set up CORS. Please follow the SAC Documentation how to set up Reverse Proxy for SAC and live universe Connection a. After starting the Tomcat a cs_ina_agent folder should appear in the webapps folder, meaning that the component has been deployed successfully b.

6 Go to the webapps > cs_ina_agent > WEB-INF folder and open the file using Notepad c. Locate the <param-name> </param-name> line 7 d. Edit the <param-value>*</param-value> line underneath it as follows <param-value> <SAP_ANALYTICS_CLOUD_TENANT_URL> </param-value> NOTE: Fill the squared brackets with your SAP Analytics Cloud tenant URL. You can provide more URL s as well, separating them by a comma. e. Save the file Setup of BI Users for SAP Analytics Cloud You must set up rights and permissions in the Central Management Console of the SAP BI platform to make sure that BI users can view Universes and access their data in SAP Analytics Cloud.

7 As a best practice, we recommend that you create a dedicated folder containing all the BI Universes exposed to SAP Analytics Cloud via the SAP BOE live data Connect component. We also advise you to create a dedicated group in the BI platform in which all users are given the specific Web Intelligence rights to create, save and delete documents in the folder containing the BI Universes . Also, make sure that users that are part of the group have viewing right on the Universes and connections that you want to use in SAP Analytics Cloud. 1. Giving BI users rights on Web Intelligence a. Log in to the Central Management Console (CMC) by navigating to the URL: http://<BOE_System>:8080/BOE/CMC b.

8 Choose Applications from the home screen of from the dropdown list 8 c. Right click on Web Intelligence and choose User Security d. Select a user or user group and click Assign Security e. In the Access Levels tab, add Full Control to the Assigned Access Levels column 9 f. Click on Apply 2. Giving BI users access to Universes in SAP Analytics Cloud a. Log in to the Central Management Console by navigating to the URL: http://<BOE_System>:8080/BOE/CMC b. Choose Universes from the home screen of from the dropdown list c. Make sure that the Universes folder in selected in the folder structure 10 d.

9 Click on Manage > User Security e. Select a user or a user group and click Assign Security f. In the Access Levels tab, add View to the Assigned Access Levels g. In the Advanced tab, click Add/Remove Rights 11 h. In the left pane click on System > universe i. Grant the data Access and Create and Edit Queries Based on universe right j. And click Apply k. In left pane click on System > universe (information design tool) l. Grant the data Access and Create and Edit Queries Based on universe right 12 m. Click Apply After performing all the steps properly, you ll need to see these rights assigned to your user or user group: 3.

10 Giving BI users access to connections in SAP Analytics Cloud a. Log in to the Central Management Console by navigating to the URL: http://<BOE_System>:8080/BOE/CMC b. Choose Connections from the home screen of from the dropdown list c. Make sure that the Connections folder is selected in the folder structure 13 d. Click on Manage > User Security e. Select a user or a user group and click Assign security f. In the Access Levels tab, add View to the Assigned Access Levels column g. In the Advanced tab, click Add/Remove Rights 14 h. In the left pane click on System > Relational Connection i.