Welcome back. So in this lesson we're going to install the PI server components.
First off we're going to install PI data archive on PISRV01 and we're going to install PI asset
framework server on PISRV02 and during the installation of PI AF server it's going to ask us
what SQL server we'd like to connect to and we're going to set up this link.
So these two server components we could theoretically install them on the same
machine there's nothing to stop us doing that in fact we're going to run the same
install kit on both machines just select different components to install. So for a very small system
there's nothing really wrong with installing them both on the same machine but they're
always going to be fighting for resources. Something else that's going to be installed
here when we install AF server is the analytics engine. So the analysis service
is in charge of performing calculations, now we usually install this on the PI AF server but
there's nothing stopping us from installing on a completely different server as well.
So theoretically we could have an additional server just for analysis.
So this once we set it up it's not really going to ask us for much but in normal operation
generally it'll be connecting to asset framework server seeing what calculations it needs to run
and then performing those calculations writing the result back into PI data archive tags.
So during the PI data archive installation we're going to have to find a license file.
Now the license file is already there in our training environment we've already gone through
the process of obtaining it and downloading it. In real life you'll need to do that yourself,
so check out the prerequisites for installation for that. Additionally we're going to rely on a
bunch of service accounts being created for us. These were also covered in the
prerequisites chapters but we're going to just go through and select them one by one.
So here we're on PISRV01. We're going to install the PI data archive on here.
So first up let's check out what drives we have available to us
so open up windows file explorer here so we have a c drive for our operating systems installed
and we have a d drive where our installation kits currently are if we open that up.
We've just got our installation kits in there and we also have e drive which is going to contain
our archives and we've named it PI archives. This is about the minimum that I'd recommend
it's nice to have different partitions for different jobs and we'll when we
assign them during the installation we'll go over what those jobs are going to be.
So I'd like you to open up this folder PI install kits
and inside here we have a PI server install kit so let's right click and run this as administrator.
All right here we are. So first off we're going to click next to this splash page up here
and then we're going to choose the components we're going to install on this machine.
So if you remember from previously we're going to install the PI data archive role on this machine
and we're going to install AF server on the other one. So this one make sure you're on PISRV01
down the bottom right hand corner, we're installing PI data archive and down here
a fairly important part, we've got our different directories. Now the easiest way to
change these is just change the text in here. We could click on the ellipsis here and navigate down
but we already know that we're going to install the PI System directories on d
drive and the archives on e drive. So let's just change those. I'm just going to change this c
to d so this not only installs the PI data archive server but also the management tools
they're going to be installed in program files pipc in program files x86 pipc and our actual
data archive the the real meat of it is going to be installed in program files PI, okay next up.
It's asking us where our license is we need to choose it here.
We have a little link to license information generation now if you are generating a license
and you will be if you're installing on a production system you'll need to click this link
and follow the steps that it goes through, you'll need to generate a machine signature
upload that to us and we'll give you a special license just for this machine. So we're going to
select the license we've already generated we're going to pretend that we've done this before,
click on the ellipsis and then click on the license inside training license.
Over here we're being asked where our archives are so all of these are on e drive.
So lastly the event queues we're going to put the event queues on d-drive.
Now down below is our archive settings now the installer looks at how well sized this machine
is it looks at how much RAM it has, how much disk space it has, it makes an assumption .
So here it says it's decided that two gigabyte archives is pretty good for us
and that'll support a maximum point count to a million points. Which is
far more than we're going to create in this training class, but for more information here
on archive size recommendations we've got some links here and we'll also link some documentation.
So let's click next.
So here we see a summary of what will be installed and looks good to me. We're going to install it.
Now speed the video up here feel free to
pause the video and then resume when your installation is finished.
All right looks like we're done.
SO our install completed successfully, let's close that down and let's see what's installed.
So we're going to this PC and we're going to go into PI System. It's got the folders that we
defined in the installation. Our actual PI data archive files are in these program files and PI
so we're going to navigate to this folder a few times over this course when we're doing
administration tasks. Now let's move on to part two here which is installing the
asset framework server. So I'd like you to go to PISRV02,
so note that we're at PISRV02 now and we're going to install AF server.
So again we're double clicking on install kits and AF server is here. So we're right clicking on it
and running as administrator.
So remember on PISRV02 we have a Microsoft SQL server pre-installed, it's SQL server express,
it allows local connections and it'll be suitable for our needs in this class. SQL
server express is also suitable for you if you've got a very small PI System.
So here we are we're going to click next on this splash screen
and choose the services we're going to install. Now this is a small system
we're going to install asset framework server and analysis service on the same machine,
on this machine. So it's both going to serve up users our data in a hierarchical format and it's
also going to run all of the calculations in our PI System and right back to the data archive. S
another service here is PI notification service, we're not covering the service in this class but
setup is fairly straightforward and if you'd like to install it in production then the documentation
is there for you. So again we're going to change these directories we have the same drive
letters available to us in this server as well everything's going to go on d drive. We'd like
to keep everything separate from the operating system. Looks pretty good to me let's go next.
So it's asking us what SQL server we'd like to use as the back end for this service
and we'd like to use PISRV02 SQL express, if you're not sure what to do in production
this is where you would work with your IT department or your database administrators
for a SQL server for you to use. Usually you'd have a dedicated instance for asset
framework if you've got a large system or you could be on a corporate server of some kind.
So there's some options here with the setup. Here we're going to both install scripts and
run them so these scripts will set up our SQL server to be a backend to AF. If your database
administrators are concerned with running these kinds of scripts on their system then you can
just install them and then they can review the scripts before they run. Let's click next here.
Next up we need to select a certificate. So we covered certificates in the text-based
lessons in the previous chapter and we already have a certificate that's created for us here.
We're going to click on select and we're going to select the only certificate that's there
there. Are any more choices this is really the only suitable one here
now this has been pre-installed you will need to obtain a certificate
from your IT department or whoever manages them at your organization.
Okay there we go. So this certificate is for the real-time query processing engine
this is a service that runs and serves up the asset framework as if it were a SQL server.
So applications can connect and get data in a tabular format. So these
are applications like Microsoft Power BI, Tableau etc. All right let's click next
and here's where we need to select the service accounts we're going to use for asset framework.
So the account names here it's got some default ones we're going to change these to be domain
accounts. I really recommend you do this in a production system it makes security
much much easier to manage. So here we've got accounts that have already been created for us.
For each of these we're going to click browse
and we're going to search for accounts. In our training system some service
accounts have already been created for us, these are group managed service accounts.
They all start with svc dash so I'm going to type in svc dash here and then check names
this will do a search and find all of the accounts that have been created for us so
in a production system in real life if you're installing this then you'll
need to type in the account names that are given to you by your IT department.
So here svc PI AF is our account that's been created for the AF service.
Okay note that the password is blank it's been grayed out managed service accounts do not
have user configurable passwords. Passwords are managed by the domain.
If you're using an ordinary account here you would need to type in the password.
Analysis services here we're going to do the same thing,
svc dash and svc-pianalyt is what we'd like and our RTQP engine
svc dash
and svc dash PI RTQP. All right okay that's that, we're going to click next.
So here's a summary of the features that are going to be installed I'm happy with that
let's click install
and.
We're done okay so we can close this and let's see what was installed. So here in PI System no
there's no well when we go into program files there's no PI folder anymore there's just PI PC
the PI PC folder PIPC contains uh client applications for the PI server,
the PI folder contains the server components the PI data archive because
we have an installed PI data archive on this machine we've got no PI folder.
Right so that's that really we can actually test and see if this is succeeded
so we can click on start down the bottom left-hand corner
and we can open the client tool to asset framework PI System explorer.
So it says the AF server only contains system configuration database where I
like to create a user database at this time sure yeah i would.
Okay database 1 is good for a test
and we're in. So it looks like we were successful,
we can connect we can create a database we're fine.
So we're done here with our server installs, so in the next lesson we'll go through important post
install tasks mostly on the PI data archive side which involve backups and security.