>> Many customers want to take advantage of
the scale and power of the Cloud to run SAP HANA.
Now, you can use Terraform and Ansible
to speed up your deployments on Azure.
Get going in as little as 30 minutes
instead of hours or days.
Paige is here to show us how it works,
today on Azure Friday.
Hi everyone, Donovan Brown
here with another episode of Azure Friday.
I'm here with Paige and she's going to show us how to
deploy SAP HANA into Azure.
So, why would someone want to run SAP HANA in Azure?
>> So, SAP HANA is a database product that a lot of
different customers like to use for
managing transactions or different things.
The reason they would want to run it in Azure
is a lot of companies are moving toward the cloud.
>> Sure.
>> It's very difficult right now,
and can be a tedious process to do
a manual installation into any VM,
whether it be Azure and different Cloud provider,
but our tool aims to make that a lot simpler,
by limiting the number
of steps that the user will have to take.
>> Okay. So, this is something that would normally take,
on the order of minutes,
hours, days, how long does a normal deployment take?
>> The deployment itself using the script,
takes about half an hour.
>> Okay.
>> But, when you have someone manually having
to type in things on the computer,
it can take a matter of hours.
If someone's very unfamiliar,
it can take order magnitude of days.
>> Wow. This is just for a single node,
or is this like a clustered such scenario,
what do people look for?
>> This is for a single node.
>> Okay.
>> It can take even longer
for a cluster or for an each pair,
which we also have available on our GitHub Repo,
but we're not going into detail about it today.
>> Great. So, we have scripts not
only for the one you're going to show us today,
but for more complicated scenarios as well,
which will still drastically
reduce the amount of time it gets to deployed.
>> Yes.
>> Awesome. So, you can show me how it works?
>> Sure. So, if you go to
our GitHub Repo, it's github.com/azure/sap-hana.
So, if you go onto our page,
you'll see that our deployment script is
broken down into Terraform modules,
which we use to deploy
the infrastructure components like the Azure resources,
and then the Ansible playbooks
run different roles to install and configure SAP HANA.
So, to actually melt
the disks that we're creating
and get the database running,
all that activity happens in Ansible.
>> Okay, got you.
>> So, if we scroll down on the Getting Started page,
you can see we can run this even from
Cloud Shell or you can use a local machine,
but I'm going to show up for the sake of the demo,
deployment in Cloud Shell.
>> Okay.
>> Then, there are
a number of input variables that you need to put in,
so I'm just going to show this text file.
This is a template
of the variables that you would need to
input into Terraform before
running the deployment script.
So, you can specify what region you would
like the deployment to go into,
you can specify the resource group,
you need to give some service principle like
credentials for your Azure login,
you can specify how big you would like the VM to be.
For example, here we say that we would like
to run on a ''Standard_ ETs_v3''.
So, you can specify and change it based on
the size and needs that you
would like to have with your database.
You can also specify
how many disks you would like to have,
and there are different tools that are
SAP products that you can opt to install on top of HANA,
that we have optional flags to do that as well.
>> Got it. So, filling out
this file is basically my way of saying,
these are all the inputs that are going to be needed,
I can do that right now we're versus
being prompted during the installation itself.
>> Yes.
>> I can review this, make sure it's good,
and then I'd be able to use
this exact file inside a Cloud Shell,
where Ansible is already running inside a Cloud Shell.
>> Yeah, Ansible is already installed
inside of Cloud Shell.
The only thing that you have to do
is export a few variables,
which are listed in the readme documentation,
so make sure that all of your information is in there,
to run smoothly, but Ansible
entire from both already installed.
>> Perfect.
>> All you have to do is clone the repo,
and then fill out this file.
>> Awesome, okay.
>> So, do you want to move on?
>> Sure I'd love to see it.
>> Okay. So, if you go to Azure Cloud Shell,
I've already cloned the repo,
so I wrote a little script that will load my credentials,
so I'm going to run that quickly.
So they don't type them into their computer.
>> So, you came in the Cloud Shell,
you used to get, and you clone the repo,
and you have it now down on your machine,
already inside a Cloud Shell of your machine.
>> Inside the Cloud Shell.
>> Perfect.
>> So, I just loaded in my credentials,
which is a few steps that you need to take.
I just don't want to put all of
my passwords on the screen.
>> No problem.
>> Then, I go into the repo,
into the deploy directory,
then go specifically into the VM part.
Then, if you look here,
there are three different directories,
it's split into the Ansible roles
and the Terraform modules.
>> Okay.
>> So, we run the script from Terraform.
So I'm going onto the "Modules Directory",
and then the "Single Node HANA Deployment".
So, when you want to deploy,
all you have to do is say,
terraform plan, and this will give
you an output of
what resources you're going to deploy into Azure.
>> Okay.
>> Sometimes takes a second or two
to get it to actually load.
>> No problem. But Terraform is only
going to provision the infrastructure,
not actually configure the databases,
that's what Ansible is going to do.
>> Correct.
>> But now, do I run two commands or do I
run this one command and Terraform goes off and says,
"Hey okay, I'm done provisioning your infrastructure,
hi, Ansible, is your turn, go finish this.".
>> Correct.
>> Okay, got it.
>> That's how it works. So, you just have to do
one command and it calls everything.
>> Perfect.
>> So, in the plan,
you can see all the different
resources that are going to be created,
it's going to make a VM,
you're going to get your network
security groups and all the disks.
So then, to apply it,
I just do terraform apply.
I'm going to hit "Yes" as soon as it asks me,
it's going to give me the same list of resources,
that I just went over.
So, I just type in yes,
and it should be on its way to start
deploying your Azure resources.
>> Great. Because you gave it
a resource group, when this is done,
I can go to that resource group, and I'll see
everything that has been provision for me.
>> Yes. If you want, we can start
going over to portal now.
>> Awesome.
>> So, I called it demo3,
and you can see that it's already starting
to populate the different resources.
>> Okay.
>> It's going to keep populating as the script runs,
so if I refresh a few more already added.
>> Sure.
>> So, you can see them actively.
>> Got you.
>> But it does take about half an hour for
the actual demo to finish running.
>> Sure.
>> So, I've pre-baked another scenario,
so I can show you guys the output.
>> Okay.
>> So, this one is called demo2,
its very similar to demo3,
except for that it's already ready to go.
>> Okay.
>> So, you can see all these Azure
resources have already been created,
then there's some specific HANA tools that you can use,
or SAP products that we did enable to flags for,
that I was talking about,
so that we can get some output from the database.
>> Okay.
> So, first, I'm going to go into SHINE,
which is an SAP delivered demo content.
So, it's a way to show off how the HANA database works,
it's not a product that we wrote,
it's one provided by SAP
but we do actually install it if you enable it,
so that you can get a nice demo like this.
You probably wouldn't use it if you have your own data.
>> It's also nice to see that the tools that were written
for HANA worked just as well if it's hosted in Azure,
so it wouldn't be for you to install it yourself.
>> Yes.
>> So, this is just an example of,
if it understands SAP HANA,
it's going to understand it even
if we host it for you in Azure.
>> Yes. It's correct.
>> Okay.
>> So, this is on the demo2 that I loaded,
so you can check, I have to sign in.
>> Sure.
>> Then, there are different pieces,
like the work purchase order worklist
and different types of graphs that you can get.
>> Okay.
>> So, for example, these are purchase orders,
I've heard it works like Microsoft Contoso,
like the fake Cantoso ads.
>> Sure.
>> So, if you wanted to,
you could even just select the purchase order,
this is all marked data that
this SHINE tool generates for you,
so you don't actually have to come
up with it yourself, it's all here.
You could say for example,
"Accept", and it will accept the purchase order.
>> There we go.
>> Okay. Now, I'd like to show you as a sales dashboard,
this is again another SHINE demo content piece,
the SAP SHINE tool has given us.
You can see a bunch of
different graphs and purchase orders.
>> Got you.
>> Also emulates different data tools
that you would use if you
installed an SAP application
on top of your HANA database.
>> Right, because SAP itself wasn't
installed and anyway during the deployment,
what we did is we deployed the backend
that would then support your SAP.
What we did in this scenario is,
we took SHINE and said, "Hi,
I have this beautiful HANA database,
go connect yourself there,
populate it with sample data,
so that I can now run you against it."
But in a real-world, I would say,''Okay,
now I have my beautiful HANA database,
hi, SAP, there's your data source.''
Then I would just start using it like normal.
>> So, SAP is
the company that provides the HANA database.
>> But not SAP the product doesn't sit on top of that.
>> No, SAP provides different products that in turn
will then sit on top of the HANA database.
>> Perfect, got it. But SHINE
isn't what I would run against it, this is just for demo.
>> This is just for demo.
>> So, what would I actually run against?
This is just for curiosity.
>> As for HANA, or one of
the different products like NetWeaver,
there are several different application
tiers that you would run on time of it.
>> You would just point them now at
the Azure instance of your SAP HANA database,
for those products to use against?
>> Yes.
>> Got it. Okay, now I'm up to speed.
I'm new to SAP myself.
>> No, it's okay.
>> Cool.
>> So, this is just some more demo data,
and you can see the data
has been split into regions by the purchase orders,
you can see countries,
and different things about the demo data,
but we don't want to
spend too much time on the demo data.
>> Sure, because the point here was
how quickly we're able to stimulate the HANA database.
>> Yes.
>> The fact that you can use SHINE or
whatever other products you want on top
of it is just a value add,
and it also just goes to the point that,
no matter where you're hosting it is
just an SAP HANA database.
So, you don't have to do anything special to get
your existing tools to work with
it, they're just going to work with it.
>> Yes.
>> Perfect, awesome.
>> Okay. Then, I'm going to show you cockpit now.
>> Okay.
>> Which is a way that you can monitor and
administer a different pieces of the database.
It's a tool that SAP also provides.
>> Okay.
>> That they're going to use more now,
moving forward instead of the HANA studio,
which is there the predecessor to cockpit,
so the difference is that
HANA studio runs on a machine itself.
>> Okay.
>> It connects to the database,
the HANA cockpit runs in a web browser,
and so you can connect to all the different pieces
here, you can monitor.
So, you can see all the different memory usages
in CPU usage.
You can get a lot of different pieces of data on this.
>> This is the data that I'd want to review to see if
I need to scale up or scale out my HANA database.
>> Correct.
>> Got it. Then again,
this is another product that's provided for me,
once I have my deployment
done using the tools that you just showed us.
>> Yes.
>> All right. So, it's really cool that because
when I saw Terraform
and Ansible I'm familiar with those products.
It's like,'' Oh, now do I have to go install these two,
but I keep forgetting how much power
we actually have in the Cloud Shell.
>> Yes.
>> That's pretty much everything that you
need or want is actually going to be already in there.
So, the steps again just to summarize are,
clone the repo from Cloud Shell,
fill in the few important bits for the security,
and then we'll go ahead and run the script and
Terraform and sit back and relax. That's awesome.
>> Yes.
>> Thank you so much for coming here.
We're learning all about deploying SAP HANA into Azure,
here on Azure Friday.