Welcome to the SAP HANA Academy. My name
is Bob and in this series of videos
we'll be looking at SAP Data Hub. In
this video we'll have a look at the SAP
Data Hub Cockpit and we'll look at
creating zones, systems and connections
within landscape management. What you can
see here is if I go to my HDFS URL, is we
have a running connection to HDFS. So
this is the Hadoop distributed file
system. We also have a connection to
Spark. As you can see here we have Spark
running. And of course in order to use
Vora we're using Yarn as well. So you can
see we've got a Yarn up and running. Of
course
Vora connects to all of those. Now of
course in this video we're looking at
the SAP Data Hub. So I’ll click on my
connection and what we'll do is we'll
maximize the screen and we're going to
log in as a user called data hub user. So
what we're going to do in this video,
again is just go through a quick
overview of the SAP Data Hub and then
look at building connections. This is
what the SAP Data Hub cockpit looks
like. So what you can see on this screen
is we've got the general overview which
lists our system status, our various
connections. We can have a few zones and
that's what we're going to look at again
in this video. And lastly we're going to
deal with modeling, as well in a lot of
our videos. So that's the general
overview of what's available to us. Now
you've also got of course modeling,
monitoring and scheduling. So you can
execute these things called tasks
workflows, which can be scheduled. And of
course you can also profile your data.
And again we're going to look at that in
a few videos time. At the bottom you've
got a series of quick links, including
the SAP Data Hub Web IDE. Where you do
your modeling. So we have a series of
quick links, including Vora and of course
on the right hand side you have any
documentation. So if I click on this
button we can go and have a look at our
other options. We’ve got landscape
management, discovery, monitoring,
scheduling and launchpad.
So what we're gonna do again is set up a
zone. A zone can be seen as a system
landscape. Now in order to do this you
can see here we only have one zone at
the moment. This is actually our default
zone. So in my system I have no zones. To
build one, I'm going to click and go to
landscape management which is an extra
tab. So as it says this is where you
manage your zones systems and
connections. And you can see I've got
some test connections here. Now you can
import these objects or we can manage
these zones. And we're going to build our
self a zone. So I'll click on the plus
button and we need to give it an ID and
a description. So I'm gonna call all my
objects. I'm going to precede them with
SHA and I'm going to call this SHA zone.
You don't need to give it a description.
All you need to do is save. You'll see
that it says the SHA zone has been
created and you can have multiple zones
for test, production and development.
So how do we know we've got the zone?
Well we'll go back to our overview and
if I click on the overview you can see
here we've got, in a second, if it
refreshes, we've got two zones. A default
zone and an other zone. Of course which
is that SHA zone. So that's how you build
them and again there for, for example,
test, production and development. In case
you want to have multiple zones. So now
we're going to look at building
connections. So for example a connection
to HDFS, a connection to Vora. So if I
again I go back to landscape management
there's two ways to get there and you
can see here I've got three systems.
We're going to add another system. So
we'll select add and then we need to
fill in these options. So we'll need to
give the system an ID. So we're going to
build this one to Vora. So I'm going to
call this SHA Vora. And in this video
we're going to create three connections
which will be used when we're connecting
to Vora.
One which connects to HDFS, which of
course where your data is contained. One
that connects to the Vora pipeline. And
also one that connects to your Vora
catalog, where you do your typical Vora
modeling.
It's obviously these are the various
system types. So we have Hadoop, HANA, Vora
BW. So we're going to select Vora. Of
course we need to assign it to our
landscape, which is our zone. And the way
we're going to connect or the agent type
is the SAP Data Hub SDI agent. So of
course then we need to put in our host
and our port number. So it's gonna be the
host where your agent is. This is the
port 5 50 50 50 by default. So I've
specified the port and if you want you
can specify SSL. So I'll select add. So
that now adds that system into our
landscape management which you can see
here. But because it doesn't have a
connection you'll see that there's a
missing icon here compared to the three
above. We need to build ourselves a
connection. So if I go to a connection
management where you can see that we've
got two test runs here to HDFS and BW.
I'll add another one. We’ll give this
connection an ID. So I'm going to call
this SHA Vora HDFS. Then we need to
choose our system. Of course all this is
the link. So we're going to connect it to
the system that we just created,
SHA Vora. And then we need to specify our
connection type. So you can see we've got
five HDFS S3 SAP Data Services, the Vora
catalog and the Vora data pipeline. So
we're going to of course choose here
we're connecting to the Vora HDFS. So
you can give a description if you want.
We're going to choose the default
connection configuration. And then of
course because it's a connection we have
to give a some form of login. So that
will be my Vora login. We don't need to
specify a password here. So we can see
now that we've set up that connection. So
how do we verify? Well if I go back to
landscape management and just refresh
the screen. We don't see it here but if I
click on the refresh, now we can see
we have associated a system with a
connection. Of course the verify this
will go back to our home page and we’ll
wait a second.
Here we can see we've added another
connection and we've also got an
additional Vora system. We had three
before. Now we've got four systems. So now
let's add another connection. We’ll go
back to connection management. We’ll
click on add and I’m going to build a
connection here to the Vora pipeline. So
I’m going to give it an ID which is SHA
Vora and then pipeline. We’ll then need to
choose of course our system which will
be SHA Vora. The connection type of
course is going to be the Vora data
pipeline. These are the various
connections types. Then you need to
configure. You don't need to give a
description. For the connection
configuration we’re going to do a
default configuration. We’re gonna
authenticate basic authentication. And
for now we don't need to put in a user
or a password. So I can remove the user
and the password. You'll see why later on
and then we've got our authentication,
basic authentication. You don't need to
put in a description. So all I need to do
now is click on add. And here's your
connection. Let's add another one to the
Vora catalog. So if I click
on add. We’ll give this an ID which is
SHA Vora and then catalog. Of course
we'll choose our system which is going
to be SHA Vora. The connection type will
be Vora catalog. And that's all we need
to do here because we'll need to login.
So we'll select add and here you can see
that additional connection. So that's how
connection management works. We’ve added
these connections to these specific
zones. As you can see here SHA zone. If I
go back to landscape management we can
see here, if we refresh nothing's really
changed. If I go back to the homepage we
can see, in a second, that we've got an
additional connection. So we've looked at
building a few different connections in
this video. So now that we've looked at
building connections in systems and in
zones, what we're going to do in the next
video is look at using SAP Data Hub to
do some data discovery.
This allows you to learn more about data
residing in, for example HDFS and SAP
Vora,
by profiling, previewing and viewing the
metadata.