Details

If you’re running SAP HANA, express edition in a virtual machine or cloud server instance, then depending on the network configuration, you may need to edit the /etc/hosts file on your local machine so Eclipse can connect to the streaming analytics server.

Edit /etc/hosts on Windows

If you are running Eclipse on a Windows machine, follow these steps to update the etc/hosts file:

On your Windows laptop, navigate to C:\Windows\System32\drivers\etc.

In Administrator mode, open hosts in Notepad. See your operating system Help for information on opening applications in Administrator mode.

In a new uncommented row, add the IP address and hxehost (virtual machine) or the hostname of the machine where SAP HANA, express edition is installed (binary installation). Save your changes.

Tip: Spacing is important. Make sure your hosts file in Notepad looks like this image.

Edit /etc/hosts on Mac and Linux

If you are running Eclipse on a Mac or Linux machine, follow these steps to update the etc/hosts file:

Open Window > Preferences and select SAP HANA streaming analytics from the list:

Set Default Server URL to the new server and click OK:

Step 5: Add a HANA service

In this step we will create a named Data Service on the SAP HANA streaming analytics server. In this case, the data service will connect to a particular HANA database. Streaming projects use named data services to connect to database tables.

Switch to the SAP HANA Streaming Development perspective and select the Data Services tab:

Right-click on the new server and select Load Workspaces:

Right-click on the Server-wide folder and select Add HANA Service:

Select newservice1 and, in the Properties view:

Enter the credentials for SYSTEM.

Uncheck Use Default HANA Server.

Select Multi Tenant.

Set Database Name to HXE.

Set HANA Hostname to the hostname or IP address for your SAP HANA, express edition installation

Set HANA Instance Number to the instance number for your installation (for the virtual machine version, the instance number is 90).

Right-click on newservice1 and select Rename Service. Name the new service hanadb:

To confirm that the HANA service is configured properly, right-click on it and select Discover: