In this video, you will learn how to configure SAP HANA studio for streaming.
Specifically,
you'll learn how to add a connection to a streaming server,
how to improve startup performance,
and how to migrate exampledata.
Before getting started,
add the SAP HANA Streaming Development
and SAP HANA Streaming Run-Test perspective
to your workspace.
If you don't see these perspectives,
you need to install the streaming studio plugin.
Now, let's begin.
To add a connection to a streaming server, first,
open the SAP HANA Streaming Run-Test perspective.
Keep in mind that you can show the perspectives as text,
if you prefer that over the icons.
In the Server View,
click the New Server URL icon.
Then, enter your server details.
The port is 3,
followed by your instance number,
and 26.
Next,
choose the connection type.
A native connection goes directly to a streaming system,
whereas a web service connection goes through the Web Services Provider.
In my case,
I’m using a native connection,
which is the default.
Before moving on,
make sure to check SSL.
As well,
make sure to select a User/Password authentication.
Now, I’ll connect to the streaming server.
Since I already have a project running on the server,
it appears in the Server View.
Of course,
if you’re connecting to a new server,
then you won’t see any projects.
Now that you’re connected to the server,
you need to choose which server you will compile your projects on.
You do this simply by setting the default server URL.
Just go to Preferences,
and navigate to SAP HANA smart data streaming.
Set the Default Server URL to the appropriate server.
Before moving on,
let me briefly show you where to go if you need to connect via a proxy.
Go to General,
then Network Connections.
Here,
you can set up your proxies,
which you might need to do if you’re on a remote client.
I am not using a proxy, though.
Now,
I'll discuss the startup performance improvements.
If you go to SAP HANA smart data streaming,
then Run Test,
in studio 1.0 SP 12 or newer,
you will see a preference called
Automatically reconnect to all projects when connecting to a server.
Prior to 1.0 SP 12
studio automatically reconnected to all projects when you connected to a server.
But from SP 12 onward,
you can choose whether to enable
or disable this feature.
By default,
studio does not automatically reconnect to projects.
This means that you can pick and choose what you want to load and view.
Also,
the default behavior for the preference
Always start previously running run-test views on project start
has changed in SP 12.
In prior versions,
this preference is enabled by default.
But,
from SP 12 onward,
studio no longer automatically loads previously running Run-Test perspective views
when you start a project.
This keeps the startup to a minimum.
Other preferences that can help you improve startup performance include:
setting pulsed subscribe intervals,
and filtering meta-data streams.
For more on these preferences,
check out our blog.
Finally,
if you want to run sample projects in studio,
migrate the example data that comes with the streaming studio plugin
to the studio workspace.
To do this,
go to the folder containing the plugin,
and go to examples.
Then,
copy the exampledata folder to the studio workspace,
which for me is hdbstudio.
And there you have it!
For more information,
take a look at the streaming documentation,
and,
check out the full library of streaming videos on the HANA Academy.
Thanks for watching!