There is a huge difference in ordering a baked potato and a loaded baked potato.
The potato is the same, but it just becomes so much better will all the add-ons.
So, how would you like your NAV 2017 on Azure?
NAV 2017 on Azure, Loaded please…
This blog post is a visual walkthrough of how to setup NAV 2017 on Azure, Loaded. It consists of a LOT of screenshots explaining what to do…
For assistance on easier navigation, I have added links to the sections here:
- Setup your NAV 2017 DEMO environment
- Install the Self Signed Certificate
- Access NAV 2017 using the Web Client
- Add NAV 2017 to the Waffle Menu
- Create a PowerBI dashboard with data from NAV
- Embedding PowerBI
- Configure the Outlook/Office Add-in
- Setup Email
- Setup Email Logging
- Do you want to Edit In Excel
- Create your PowerApps
- Create a Flow
- Access NAV 2017 via a SharePoint Portal
- View a world map of your customers
- Connect your Phone or Tablet to NAV 2017
- Access NAV 2017 using the Windows Client
- Connect to your Virtual Machine
- That was easy
You can also choose to go through the entire story-like post right here:
Setup your NAV 2017 DEMO environment
The system will redirect you to the new Azure Portal, and you will be asked to login and fill out a quesionnaire. You need to at least fill out Resource Group, VM Name and the admin password.
In order to get your NAV 2017 Fully Loaded, you also want to fill out the BingMaps Key (get one here), select Yes to ClickOnce, select yes to PowerBI and type in the administrator username (email) and password for the Office 365 where you want to integrate NAV 2017. Also say Yes to allow NAV to create a Portal with NAV 2017 Content.
When Deployment is done, the new Portal will show the deployment and display 1 Succeeded. In the unlikely event it should say 1 Failed, you can click on the link to see what went wrong. It isn’t easy, but you will probably get there. Then remove the Resource Group and try again:
Install the Self Signed Certificate
If you are using a self-signed certificate (if you followed the process here, you are), click the Download Certificate link and follow the process for installing the certificate in the trusted root certificate authorities:
Note, if you are going to connect to the Virtual Machine with your tablet or your phone, you would need to install the certificate on the device also. You can scan the QR code on the landing page on your device, to navigate to the landing page and download the certificate and the app for your device (link is at the bottom of the landing page).
Access NAV 2017 using the Web Client
Add NAV 2017 to the Waffle Menu
If you want to have NAV 2017 in your Waffle Menu in Office 365, click the “Waffle” Menu in NAV 2017, which will navigate to your apps. Click the … menu next to your NAV 2017 app and say Pin to App Launcher:
Create a PowerBI dashboard with data from NAV
Navigate to https://powerbi.microsoft.com/en-us/ and sign in with your Office 365 username and password:
and in the setup dialog of the PowerBI, you need to paste the URL. Select authentication method Basic and put in your username and password for your admin user. Note: this is NOT your Office 365 username and password, it is the username and password for your NAV user. You can also create a Web Services key in the users dialog in NAV and use that instead of the password.
Now where you have PowerBI, you want to setup embedded PowerBI in NAV 2017. Start your Web Client like described in the section about starting the Web Client. In the Role Center, Click Actions and select Assisted Setup & Tasks.
In the list of Assisted Setup, select Setup Azure Active Directory and go through the Wizard. All values should be pre-populated.
On the Role Center, locate the Power BI Reports at the bottom and click Get Started with Power BI.
Configure the Outlook/Office Add-in
Start your Web Client like described in the section about starting the Web Client. In the Role Center, Click Actions and select Assisted Setup & Tasks.
Setting up E-mail from NAV 2017 is really easy. Start your Web Client like described in the section about starting the Web Client. In the Role Center, Click Actions and select Assisted Setup & Tasks.
In the Assisted Setup list, Select Setup Email. This will guide you through a very easy 4-step wizard, which sets up the E-Mail connection. On Step 3, it is recommended that you click Send Test Mail to check your setup.
Setup Email Logging
Setting up E-mail Logging from NAV 2017 is really easy. Start your Web Client like described in the section about starting the Web Client. In the Role Center, Click Actions and select Assisted Setup & Tasks.
Do you want to Edit In Excel
Good news: Everything has already been setup for you. Start your Web Client like described in the section about starting the Web Client. In the Navigation pane on the Role Center, click Customers and select Edit In Excel in the ribbon.
Now the devil is always in the detail. You might run into issues if Excel is installed with a different Office 365 account. I had to install Excel on a different machine, using the Office 365 credentials used to setup NAV 2017, which was pretty annoying. When Excel opens, you will have to enable editing:
Create your PowerApps
So, you want to create PowerApps… – wait no more. Navigate to https://powerapps.microsoft.com/en-us/ and sign in with your Office 365 account:
In the new connections dialog, add your UNSECURE OData endpoint. On the landing page you can right click the View UNSECURE OData Web Services and copy the link address to the clipboard.
As the Username and password you use your NAV admin username and the password (NOT your Office 365 credentials). Company name is the Company name from NAV, if you are using W1, the company name is CRONUS International Ltd.
Create a Flow
Flows lives in the same area as PowerApps. In order to create a Flow, you need to have a Connection created and you can find information how to do this in the previous section about PowerApps. Click Flows:
If this was a session with an audience, I would ask: Does anybody knows why the customer name is empty? and if the audience had been working with NAV for more than just a short time, they would all answer: Because the created trigger is invoked when the record is created, not when you have filled out the fields and pressed OK on the customer card. It might have been a better demo to hook on to the customer modified event in Flow.
Access NAV 2017 via a SharePoint Portal
View a world map of your customers
Connect your Phone or Tablet to NAV 2017
Before you open your app and connect to your NAV 2017, you will need to install the self-signed certificate on your device as well. At the top of the landing page, you will find a description on how to do and a link to download the self-signed certificate.
Last, but not least, the easiest way to configure the app on your device to your instance of NAV 2017 is to click the Configure App link on the landing page. It should autoconfigure the app to the URL for NAV 2017.
Access NAV 2017 using the Windows Client
The Windows Client is available for ClickOnce deployment on the NAV 2017 environment. On the landing page, click the Install Windows Client link under Office 365 authentication (or under username/password authentication). The system will open a page, on which you need to accept the license terms and press install now.
The Windows Client will now be installed on your PC using ClickOnce. Read more here.
When the installation is done, you will be asked to authentication and you will now be running the Windows Client locally against a NAV Service Tier on Azure.
Connect to your Virtual Machine
If you need to connect to your Virtual Machine, then you will find a link to a Remote Desktop connection to your Virtual Machine (server1) on the landing page. Click that and login with your Virtual Machine Administrator username and password.
BTW – if you ever succeeded in setting up all of this without the Gallery image, please write in the comments how much time it took, from start to finish… (or maybe how much time it took to get some of the way:-)) – we can multiply this with a lot of people – to see how much time people actually save by using the NAV 2017 image on Azure.