Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.
Hello and welcome!
Thank you for dropping by to watch our latest how two video for Meta5!
We are really pleased to see you drop by.
Today we are going to show you how to install the Microsoft Meta5 demonstrations on to a windows server such as Windows 2012 R Two.
Of course you can also install all these demonstrations on to a windows ten workstation.
It is just more normal to install SQL server and Meta5 server software on to a windows server rather than a windows ten desktop.
We do not do any of our Meta5 testing on windows 10 desktops, so we can not provide you any advice and guidance on how well that works.
In this demonstration we are using an almost blank virtual machine so that you can see things being set up pretty much as you will see them when you first install these demonstrations.
Ok?
So, let us go to the demonstration.
So here we are on our META5 DEV oh one desktop.
The first thing we need to do is to download the demonstration files.
Currently these are available as downloads direct from our web site on the relevant blog post.
You do not have to request the download files via an email form at the current time.
This might change in the future.
So we are mentioning this possibility in this video in case the download button has changed to an email form at some time in the future.
As at the time of writing, and included in the video, the demonstration files are available as a download using the button on the blog post.
So the first thing you will need to do is to download the demonstration files from the blog post.
So now go to your browser.
Now enter our web site address.
Now click on the blog menu item.
Now scroll down to the blog post, H D 0 0 0 2, How Do I Install The Microsoft Demonstrations blog post.
Now click on the blog post.
Now scroll down to the point in the blog post where you can click on the download button.
Now click on the download button.
You will see the download start.
It might take a while because the download is coming from our web server in the U S.
Once the download is complete, then click on show all in your browser.
Now click on show in folder.
From inside the download folder click once on the left mouse button on the download file.
Right click on the download file.
Extract the files from the download file.
Go into the folder you extracted the download files in to.
You will see that we have also provided you the Adventure Works and Wide World Importers data warehouse databases provided by Microsoft.
This saves you the effort of fetching them for your self.
You should see 6 files.
They are as follows.
Oh one. Adventure Works dot M 5.
Fifty one. W W I, Demos dot M 5.
ADVENTURE WORKS D W M 5 A dot back.
ADVENTURE WORKS D W dot back.
WIDE WORLD IMPORTERS D W M 5 A dot back.
WIDE WORLD IMPORTERS D W dot back.
The files that have the suffix dot back, are SQL Server back ups of the demonstration databases.
They are backed up from SQL Server 2016.
They will work on later releases of SQL Server.
They will not work on prior releases of SQL Server.
They will not work on SQL Server Express as far as we are aware.
We are not going to demonstrate how to perform restores on these databases.
If you do not know how to restore a SQL Server backup, please ask your Database Administrators to help you.
Or please perform a google search.
There are many demonstrations of how to do this already out on the web.
So it did not seem sensible to re-do the database restores to show you what happens during that process.
In this demonstration we have already performed the restore process for the SQL Server databases.
We will show you the folder that we placed the databases in to.
This is the folder that we placed the databases into.
We will also show you the SQL Server Management Studio window where the databases have been restored.
This is the SQL Server Management Studio window where you can see the databases have been restored on this server.
Next you will start the Meta5 system.
In our case we are using Meta5 Professional Edition for this demonstration.
So now double click on the Meta5 Icon.
We will pause the video so you do not have to wait for the start up process.
Next you will type in the user id and password for the desktop that you have.
Now your desktop will be open.
Next you will need to move the Meta5 desktop to one side so that you can see the downloads folder.
Now put the mouse over the heading bar of the Meta5 desktop.
Now left click on the mouse and hold down the mouse button.
Now move the Meta5 desktop to the right so that the downloads folder in windows explorer is visible.
Now put the mouse over the file, oh one, Adventure Works dot M 5.
Select the file oh one, Adventure Works dot M 5, by left clicking the mouse and holding down the mouse button.
While holding the left mouse button down, drag the oh one, Adventure Works dot M 5 file from the external Microsoft operating system on to the Meta5 desktop.
Now release the mouse button to drop the file on to the Meta5 desktop.
Meta5 will now translate the archived Meta5 file to the required files on the Meta5 file server.
This process might take a little while for large Meta5 archives.
Next hover over the second file.
Fifty One, W W I, Demos dot M 5.
Then press down on the left mouse button.
While holding the left mouse button down drag the file from the windows operating system across to the Meta5 desktop.
Release the left mouse button to drop the file on to the Meta5 desktop.
Meta5 will now translate the archived Meta5 file to the required files on the Meta5 file server.
This process might take a little while for large Meta5 archives.
The next thing you need to do is to connect the Meta5 demonstrations to the databases that you restored to the windows server.
We have produced a separate how two video to do this task..
It is called H D 0 0 0 1. How Do I Create An ODBC Connection For Meta5.
You can find it on our web site.
Please note that the ODBC connection must be created on the same desktop that is used to install Meta5 Starter Edition.
If you install Meta5 using a different desktop to the desktop you used to create the ODBC connection, Meta5 may not be able to find that connection.
You can always check by reviewing the ODBC 32 Bit connections administration panel.
So by this point we assume you have created the two ODBC Connections.
This will be as per the blog post , H D 0 0 0 1, How Do I Create An ODBC Connection For Meta5.
Now You must move the Meta5 desktop back to the left of the screen.
Move the mouse over the header bar of the Meta5 desktop window.
Press and hold down the left mouse key.
Drag the Meta5 desktop window to the left so that you place it correctly on the windows desktop.
Now you can open up the folder, oh one, Adventure Works.
Hover the mouse over the folder and open the folder by clicking on it twice.
You will see four folders.
oh two. Adventure Works Sample Query Icons.
Eleven. Adventure Works Example Report oh one.
Ninety Eight. Define Workstation Tools Data Dictionary Adventure Works.
Ninety Nine. Workstation Tools Data Dictionary Meta Data V one point six.
You are interested to know if the files in oh two, Adventure Works Sample Query Icons folder made the trip from our web site to your Meta5 system without any problems.
So now open up the oh two, Adventure Works Sample Query Icons folder by clicking on it twice.
Now open up the capsule, oh one Sample Query Icons, by clicking on it twice.
Now you will see nine query icons and nine spreadsheets in the oh one Sample Query Icons capsule.
Open up the oh one Internet Sales Facts query icon by clicking on it twice.
If you have created the ODBC Connection correctly, then the query icon should open up to the query panel and the query control panel will also likely be open.
Now click on Show Data in the header bar of the oh one Internet Sales Facts query icon.
You should get 555 rows returned by the query.
If this happens then you have managed to install the demonstrations properly on your Meta5 desktop.
Congratulations!
Next you need to make some changes to support the example capsule that generates reports for the adventure works database.
So now close the oh one internet sales facts query by clicking on the name of the query in the header.
So now close the oh one sample query icons capsule by clicking on the name of the capsule in the header.
Now close the oh two Adventure Works Sample Query Icons folder by clicking on the name in the header.
Now open the folder, Eleven, Adventure Works Example Report Oh one, by clicking on it twice.
Now open the capsule, oh one, Adventure Works Example Report oh one, by clicking on it twice.
Now open the capsule, Adventure Works Capsule oh one, by clicking on it twice.
Now go to the first PC Directory Icon in the middle of the screen and hover over the top of the icon with the mouse.
Now open the options panel by clicking on the icon once to highlight the icon and then pressing F four.
Now click on Other Data.
You will see that the Directory Name Parameter is set to C, colon, back slash, A, BIDA, HOSTING.
You must create this directory name on your server.
You can not use a different directory name for the demonstration to work.
So now you will go to windows explorer and create this directory name.
Now click back on the Meta5 desktop.
Now close the icon options by clicking on the icon options in the header.
Now move the mouse to hover over the second PC Directory icon in the bottom right hand corner.
Highlight the PC Directory Icon by clicking on it once.
Open the icons option panel by pressing F four.
Now click on Other Data.
You will see the Directory Name is set to C, colon, backslash, change me.
You must put a directory name in this parameter that exists on your Meta5 server.
In our case we will create a directory called, Z oh one dash sample reports.
We will type that name in to this Directory Name parameter in the demonstration now.
We will go and create the folder on the C drive of this virtual machine now.
Notice that we have not put the at , A, A, variable at the end of the Directory Name Parameter as we have it in our demonstration videos.
You can do that if you wish.
However, if you put the at , A, A, variable in to the directory name parameter then you must go and create the three sub directories in the target folder as well.
Meta5 will not create these directories for you.
The capsule will fail if the directories do not exist because the write of the excel spreadsheet will fail.
If everything has been installed correctly it will now be possible to run this capsule.
So we will now run this capsule from the beginning just to see if it will run.
Now close the icon options for the PC Directory Icon by clicking on icon options in the header.
Now Close the capsule Adventure Works Capsule oh one by clicking on the capsule name in the header.
Now you are in capsule oh one adventure works example report oh one.
Click on the white space in the capsule to dee select the capsule adventure works capsule oh one which will still be selected by default.
Now click run in the header of the capsule oh one Adventure Works example report 01.
The capsule will run if all has worked properly.
Please cross your fingers for us!
Ok?
And there you have it.
The capsule ran correctly.
We will now go to the folder called Z oh one dash sample reports.
Now you can see the finished spreadsheets from this capsule.
Now you can open up one of these spreadsheets.
We will open up the Europe spreadsheet just to demonstrate that the spreadsheet is there and working.
If all this has worked on your Meta5 desktop then we wish you congratulations for getting your first capsule to run on your Meta5 desktop!
Congratulations!
Now.
We would recommend you watch the video on the blog post, H D 0 0 0 3, How Do I Know What Data Is Available To Me?
This video will take you through how to check your installation and how to discover the data that is available to you in the demonstrations.
Now you can log off your Meta5 desktop, satisfied with a good days work!
Meta5.
The better way.
This concludes our demonstration of how to install the Microsoft Meta5 demonstrations on to a windows server such as Windows 2012 R Two.
We hope you liked this short how two video.
If you did like it, please hit the like button and please subscribe so that you will receive notifications when we release more how two videos.
Thank you very much for coming by our channel and watching our how two video, we really appreciate you.
I wish you a good day!
Thank you.
