The Web IDE for SAP HANA is a great tool for developing streaming projects, and is continuously getting updated with new and improved features. Because new streaming functionality is no longer being added to studio, it’s important to get Web IDE set up so that you can continue to benefit from these enhancements.

In a new installation of streaming analytics, there are a few additional things you need to set up before you can start working with projects in the Web IDE.

Streaming Service Broker

To start, you’ll need to configure the streaming service broker, which connects streaming servers to XSA spaces. This connection requires a technical user, so the first step is to create that user on the system database and assign it the CATALOG READ and CREATE SCHEMA privileges. You can do this through Cockpit, or through a SQL console using the following statements:

CREATE USER SDS_BROKER_USER PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE;

GRANT CATALOG READ TO SDS_BROKER_USER;

GRANT CREATE SCHEMA TO SDS_BROKER_USER;

After creating the user, there’s one more SQL statement to execute, which grants the user several object privileges it needs so it can be used with the broker:

CALL "SYS_XS_SUPPORT"."XS_SUPPORT_GRANT_SELECT"(SUPPORT_USER_NAME=>'SDS_BROKER_USER');

Now that the user has the right privileges, the next step is to configure the broker. In the XS Advanced Cockpit, select More… and open the Service Broker Configuration link:

On the HANA System Provisioning tab, select Edit and enter the credentials for your service broker user:

Then, on the Streaming Service Provisioning tab, select Register and enter your streaming cluster manager password:

Once the registration process completes, the streaming service broker is configured and ready to go.

User Permissions

In addition to the normal roles required for working in the Web IDE, users who will be working with streaming projects need a role to access to the streaming run-time tool.

In the XS Advanced Cockpit, go to Security -> Role Collections, then either create a new role collection or edit an existing one.

In your collection, add a new role. For Application Identifier select com-sap-xsa-sds-rtt!i1, and for Role Template and Role, select xsa_sds_rtt_developer_template:

If you make a new role collection for this, you’ll need to assign it to any users that will be working with streaming in the Web IDE. Select User Management, then assign the new collection to them:

First Time Setup for Users

To start working with streaming projects, the next time your users connect to the Web IDE they will need to enable two features: the first allows you to add streaming modules to an MTA and the second adds a link to the streaming runtime tool in the Tools menu.

With that, your users are ready to start making streaming projects. For more information about working with streaming projects in the Web IDE, check out the SAP HANA Streaming Analytics Developer Guide.