Get the Latest Version of EMS Campus Web Service

Important!

EMS Cloud Customers must contact EMS Support or their Professional Services Consultant to obtain the files below. All other customers can obtain the files from the Downloads area of Accruent Access. To view the Downloads area, log into Accruent Access and navigate to My Products > EMS Downloads (opens a new tab) > (Release) Releases & Patches.

  • EMSCampusWebService.msi –  EMS Campus Web Service installation file.

  • Views.sql –  Script that will create EMS Campus specific views in your SIS that the EMS Campus Web Service will use to query/update data.

  • Queries.xml –  SIS-specific configuration file used by the EMS Campus Web Service to connect to your SIS. 

Install the EMS Campus Views

EMS Campus clients using the tab-delimited file option can skip to the System Requirements and Prerequisites for EMS Campus Web Service section.

To install the EMS Campus views:

  1. Get the Views.sql file (required for new EMS Campus installations AND upgrades.)

  2. Create an EMS Campus specific account (name and password are arbitrary) in the SIS database that has been granted permissions to execute the EMS Campus views and has update privileges on the table used to store course meeting information.  This account will be used by the EMS Campus Web Service to connect, query, and update your SIS via the views created by the Views.sql file.

    For a list of permissions by table for your particular SIS, contact your Professional Services Consultant.

  3. Execute Views.sql against your SIS database. 

    Depending on your database management system, you might need to execute the Views.sql file using the account created in Step 2.

  4. Complete the following additional steps based on your SIS Database Management System.

Microsoft SQL Server

No further steps required.

Oracle

  1. Install the Oracle Client (version 11.1.x or 11.2.x) on your web server.  Choose the ‘Administrator’ installation type option.

  2. Using the Oracle Net Manager, create a TNSNAMES.ora file.

  3. Verify that the PATH Environment Variable references the location of your TNSNAMES.ora file.

  4. Create a TNS_ADMIN Environment Variable to point to the location of your TNSNAMES.ora file.

  5. Grant to the Authenticated Users group Read + Execute privileges on your main Oracle directory.  Make sure that permissions are propagated to all child objects.

  6. Reboot your web server.

  7. Launch SQL Plus and log-in.

  8. Execute the following statement to verify connectivity to your Oracle-EMS buildings view.

  9. Select * from ems_vwbuildings.

IBM UniData

UniData comes with the following tools, which must be installed:

  • Visual Schema Generator (VSG) – Used to build views and sub-tables for EMS Campus.

  • ODBC Client Software.

Contact Customer Support

If you do not have a customer login, register here.