In this blog we will have a look at the integration of Exchange 2013 with Office Web Apps What are the advantages of this change and we will have a look if there also are some disadvantages.

Starting from Exchange 2007 you needed to install the Office Converter Pack to use the preview, also known as Web Ready view, functionality in Outlook Web Access/App. This gave users the ability to read the content from for example Word files without actually opening Word. So if you had a machine which hadn’t had Word installed you were still able to view the file. This functionality is offered by using the IFilter functionality. Besides the Office Converter Pack some 3rd parties also published their own IFilter packages, for example Adobe.  Keep in mind that IFilters are not only used for the preview functionality but by Exchange Search for content indexing.

Starting from Exchange 2013 you still have the ability to use IFilters for the preview functionality. But there is another method. You can offer some extra functionality to users by integrating Exchange 2013 with Office Web Apps. This software has to be installed on a separate server. The Office Web Apps server can be used to edit Excel, PowerPoint and Word files. If you want to open/edit RMS files then I must disappoint you. RMS files can’t be opened using the Office Web Apps server.

The Office Web Apps server can be deployed in many scenarios.

In the table below you will see the deployment types and there specific requirements

Deployment Requirements
Only internal
  • Internal FQDN
  • Certificate*
  • Both internal and external
  • Internal and external FQDN
  • Certificate
  • External IP
  • Reverse proxy for publishing the OWA server(s)
Single
  • No special requirements besides the internal/external requirements
Pool
  • Multiple servers
  • Hardware Load Balancer

*recommended in production environments and required when Lync also uses the server

So what is the advantage of making this integration? Well the Office Web Apps Server will give users the ability to also edit files via a web browser. Since BYOD is a hot concept at the moment this will not require you to have the Office suite installed on your machine or tablet. Personally I think it is a big advantage for the last type. This because there is still no Office version available for the tablets.

Installing the Office Web Apps server is pretty easy:

  • Install the prerequisites
  • Install the Office Web App server software
  • Configure the Office Wep App server

The prerequisites can be divided in two parts:

  • Windows components
  • Other prerequisits

The Windows components can be installed by using the servermanager module for Powershell:

Import-Module ServerManager

Add-WindowsFeature Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,Web-App-Dev,Web-Asp-Net,Web-Net-Ext,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Includes,Web-Security,Web-Windows-Auth,Web-Filtering,Web-Stat-Compression,Web-Dyn-Compression,Web-Mgmt-Console,Ink-Handwriting,IH-Ink-Support

After the components have been installed you will need to reboot your machine to finish the installation. Once the machine is rebooted download and install the following prerequisites:

After installing the three items above you will need to reboot the server again. Once the reboot has completed it’s time to install the Office Web Apps server software. Since this is just a case of next – next finish I won’t go in to detail for this step.

Once the setup has completed it’s time to configure the Office Web Apps server. To do this we will need to use Powershell.

New-OfficeWebAppsFarm  “https://owa.domain.com” –CertificateName “Office Web Apps”

In this scenario we have configured Office Web Apps to be available only via HTTPS and both the internal and external url are set to https://owa.domain.com

Now we have finished the Office Web App server side let’s have a look what has to be configured for Exchange 2013.

The configuration on the Exchange 2013 side is quite simple. Just open the Exchange Management Shell (EMS) and run the following cmdlet:

Set-OrganizationConfig -WACDiscoveryEndPoint https://owa.domain.com/hosting/discovery

In this case we will set our Office Web Apps connection point to https://owa.domain.com/hosting/discovery. When a user now uses the preview functionality Exchange will send a call to the Office Web Apps Server which will open the file.

To make this function work both on the local network as on the internet you will need to make sure it is accessible via both ways. The local network shouldn’t be a big problem so let’s continue with the internet side.

To offer the functionality on the internet we will need to publish our Office Web Apps Server to the internet. The recommend scenario is to put it behind a reverse proxy, for example TMG. Documentation on how to configure your TMG to publish Office Web Apps can be found here.

But what if you only want to allow this usage on private computers and not public computers? First of all keep in mind that the user is the one who is responsible for choosing the correct option when logging in via OWA.

But how to allow the use of the Office Web Apps Server only from private computers?

Set-OwaVirtualDirectory “EX01\owa (Default Web Site)” -WacViewingOnPrivateComputersEnabled $true  -WacViewingOnPublicComputersEnabled $false

The parameter –WacViewingOnPrivateComputersEnabled will enable the use of Office Web Apps from private computers. The second parameter WacViewingOnPublicComputersEnabled will disable the feature for public computers.

Advantages Disadvantages
Gives users the ability to edit Word, Excel and PowerPoint files Software needs to be installed on separate machine
No additional software is needed on the clients Must be available from the internet if you want to offer the same services as on your local network. (for Lync 2013 this is required)
Can also be used by SharePoint 2013 and Lync 2013 so the server is not only used by Exchange 2013. More than one server required in an HA environment

Comments


Johan Veldhuis