Connecting Streaming Analytics to Design Studio
SAP BusinessObjects Design Studio supports connections to streaming analytics as a data source for your applications and dashboards. It connects to streaming via the Web Services Provider and provides your application with real-time data. Before you create the connection though, there are a few things to set up on the streaming side: you’ll need to confirm your WSP configuration info, set streaming permissions, and enable web services for your project.
First, in cockpit, click on Configure Streaming Cluster, then the Web Services Provider tab. Check the REST port that the WSP is using, and whether it’s configured for HTTP or HTTPS. WebSocket connections also need to be enabled, but you won’t need the port number for it – Design Studio uses the REST connection to get the WebSocket details.
Once you’ve got the connection details, make sure that the WSP is running. Go back to the system overview and click on Manage Streaming Nodes, then the WSP tab for your node. If the status isn’t already running, start it.
The user that connects to the project from Design Studio needs two permissions: one for viewing your project, and the other for reading from the stream or window. You can set these by going to Manage Streaming Permissions from the system overview.
Finally, open the CCR file for your project and enable web services, then save the change and deploy the project.
Now that everything is set up on the streaming side, you’re ready to connect. In your Design Studio application, right-click the Data Sources folder and select Add Custom Data Source > Streaming Data Source.
Fill out the configuration, security, and credentials sections in the properties panel and click Connect. You’ll see a green circle confirming that you’re connected to the streaming server. In the data source section, choose the workspace, project, and topic (stream or window) to subscribe to, and set an update interval (in milliseconds).
On the data selection tab, set the measures and dimensions for your data, and check ShowLivePreview. You’ll see another green circle indicating that the subscription to the streaming project is working.
When you assign the data source to a component in your application, ShowLivePreview gives you a real-time preview of how the component looks with the streaming data flowing into it.
Now you can create dashboards and applications with real-time visualizations of data from your streaming analytics projects.
Hi Aaron,
Thank you very much for this very valuable sharing.
I tried to do same thing but I got Network error when I tried to connect to Streaming Analytics.
First, I was enable WSP and gave necessary permission to the user. You can see the http connectino in the picture below.
From Design Studio, I add Streaming Analytics source and entered host and port with user credentials however I couldn't connect. It says Network Error.
I turned the log level to Debugging Information to see what is the problem and saw following lines in the log file.
!ENTRY com.sap.ip.bi.zen.rt.client.servlet.lib 0 0 2017-11-27 18:40:46.334 !MESSAGE Exiting method: handleRequest !ENTRY com.sap.ip.bi.zen.ui 0 0 2017-11-27 18:40:46.428 !MESSAGE [ZEN APS] DS_1: ds_propertyValuesChanged called with arg(s): [configuration={"config":{"host":"10.5.2.31","port":"9091","workspace":"","project":"","topic":"","livePreview":false,"isStream":true,"streamRetention":100,"updateInterval":1000},"workspaces":{},"projects":{},"topics":{},"measuresDimensions":[],"staticDimMeasure":[{"type":"Dimension"},{"type":"Measure"}],"charttype":"viz/column","query":"","wsPort":"","https":false}] !ENTRY com.sap.ip.bi.zen.ui 0 0 2017-11-27 18:40:46.434 !MESSAGE [ZEN APS] DS_1: ds_propertyValuesChanged called with arg(s): [configuration={"config":{"host":"10.5.2.31","port":"9091","workspace":"","project":"","topic":"","livePreview":false,"isStream":true,"streamRetention":100,"updateInterval":1000},"workspaces":{},"projects":{},"topics":{},"measuresDimensions":[],"staticDimMeasure":[{"type":"Dimension"},{"type":"Measure"}],"charttype":"viz/column","query":"","wsPort":"","https":false}] !ENTRY com.sap.ip.bi.zen.ui 0 0 2017-11-27 18:40:46.438 !MESSAGE [ZEN APS] DS_1: ds_propertyValuesChanged called with arg(s): [configuration={"config":{"host":"10.5.2.31","port":"9091","workspace":"","project":"","topic":"","livePreview":false,"isStream":true,"streamRetention":100,"updateInterval":1000},"workspaces":{},"projects":{},"topics":{},"measuresDimensions":[],"staticDimMeasure":[{"type":"Dimension"},{"type":"Measure"}],"charttype":"viz/column","query":"","wsPort":"","https":false}] !ENTRY com.sap.ip.bi.zen.ui 1 0 2017-11-27 18:40:46.480 !MESSAGE [ZEN] READY !ENTRY com.sap.ip.bi.zen.ui 0 0 2017-11-27 18:40:47.540 !MESSAGE [ZEN APS] DS_1: if(window.ds_focusLost){window.ds_focusLost();}Do you have any idea about the reason? What could be the problem?
Regards,
Bulut