Execu/Tech Systems, Inc.
Knowledgebase
Search:
850-747-0581EmailWebsite
Contents
 
IndexBookmarkPrint This Article

Home > Interfaces > OTA / HTNG > OTA / HTNG Installation and Configuration

If this is a new installation, the PMS must be updated to the latest version prior to interface installation, setup and testing. 

TLS 1.2 Requirements 

TLS 1.2 requirements work both ways - outgoing and incoming. Customers with an OTA / HTNG Reservation Interface (CRS Vendors like Travelclick, Synxis, Vertical Booking. etc.) are running IIS on one of their computers. TLS 1.2 will soon be required for incoming connections from your CRS vendor on this computer. You must check with the appropriate vendor to determine the TLS cutoff date for reservation delivery to your server.

If you are a Cloud Hosted customer there is nothing you need to do because we take care of this.

This is different than the TLS 1.2 requirements for credit card processing because those requirements only affect outgoing connections. The requirements discussed here are for incoming connections into your computer that's running IIS.

Meeting this requirement is simple but may require your IT professional's assistance.
  1. Ensure that the computer hosting IIS and our OTA / HTNG Reservation Interface web service is running at least Windows 10 or Windows 2012.

  2. Install all Windows updates.

  3. Install the latest .NET Framework

  4. Enable TLS 1.2.
    Import these Registry settings. After you extract the file you can view the .reg file in Notepad to see what it does. This only addresses incoming connections to the server.
    Download Enable TLS 1.2 Registry Entries
Information about these registry settings can be found here. 
https://docs.microsoft.com/en-us/windows-server/security/tls/tls-registry-settings

Here is more information regarding Server 2008R2 and presumably Windows 7.
https://cloudblogs.microsoft.com/microsoftsecure/2017/07/20/tls-1-2-support-added-to-windows-server-2008/

SSL Certificate Requirements

All CRS companies that we work with require a valid SSL certificate to be installed on your server for PUSH delivery of reservations. PUSH delivery means that they connect to your server and deliver the reservations. Please ask your CRS vendor which type of interface you have with them.

It's your responsibility to obtain, install and maintain this SSL certificate. Make yourself a reminder of the date that this certificate expires so that you can renew it before this date and avoid any issues with reservation delivery from the CRS. If you're not familiar with how to obtain an SSL certificate, your IT professional should be able to help you. You can also contact the company that your domain is registered though and they may be able to sell you a certificate.

* If your software is hosted on the Execu/Tech Cloud Hosting platform then you do not need to worry about the SSL Certificate. Since we host your server, we handle this for you. 

There are 3 parts to the interface:
Web Service 
(ETOTAService.aspx)
 This is an ASP.NET web service that receives the messages sent from the CRS. 
The customer must be sure to install IIS with the ASP.NET role. Otherwise, IIS won't recognize the service and may return a "404" error.
OTA / HTNG Processor
(ETHTNG.EXE)

 This is an application that runs as a scheduled task and processes the information received from the CRS. 
Microsoft .NET Framework 4.0 required.
OTA / HTNG Sender 
(ETHTNG-Sender.exe)		 This is an application that runs as a scheduled task and sends responses to the messages received from the CRS and also sends the 2 way messages. 
Microsoft .NET Framework 4.0 required.

This is the general flow of data.


Installation and Configuration

 All interface files are contained in ETHTNG-Installer.zip 
ETHTNG-Installer.zip  This is the file containing the installation files 
 
To Hotel Folder
This folder contains the Processor and Sender, as well as the folders that contain log files and XML templates.
Extract the contents of this folder into the PMS software folder.
 
To IIS Folder 
This folder contains the Web Service files. 
Extract the contents of this folder into the folder created for the Web Service.

  Download
ETHTNG-Installer.zip 

Installation should only be performed with the assistance of Execu/Tech support staff. DO NOT use this to update an existing install of the interface. 

Firewall Settings  

Web Service

This Web Service consists of these two files:
ETOTAService.aspx - The Web Service application.
ETOTAService.inc - The Web Service settings. 

IIS is required for the two way interface. 

The customer or their IT professional is responsible for the following. 
  • Installing IIS (Microsoft's Internet Information Services) on the PMS server.

  • Obtaining and configuring a static public IP address if it's required by the CRS vendor. This includes configuring all 
    firewalls and routers to ensure that the public IP address is properly directed to the PMS server. All communications are encrypted on port 443, the default SSL port.

  • If you have a 2 way interface (Rates, Availability, etc. are updated from the PMS to the CRS) then your router / firewall will need to allow outgoing traffic to the CRS URL on port 443. The CRS can give you the URL.

  • Obtaining and configuring a domain name if it's required by the CRS vendor. This is part of the URL that the CRS will use to post reservation information to your server.
    Often a domain with a unique subdomain (in this example it's the part before mydomain.com) like crs.mydomain.com or reservations.mydomain.com is used, but this is up to you. It is likely required if you already have a website that uses the same domain name but is hosted on another server.

  • Obtaining and installing an SSL certificate on the PMS server. This certificate must be generated for the full domain including the subdomain or it must be a wildcard. Your IT professional will help you with this.
We will need the domain name before we can provide the CRS with the PMS URL necessary for the 2 way interface.

The Web Service is installed into a folder provided by the customer, similar to WebRes. If they have WebRes, it shouldn't be a problem installing it in a sub folder inside their WebRes folder. If they don't have WebRes, these are the basics they will need to know to provide you with a folder. Items 1 - 4 should be completed by the customer's IT professional. If they have any questions, they should contact Execu/Tech Support before proceeding.
  1. Install IIS with the ASP.NET role. Otherwise, IIS won't recognize the service and may return a "404" error.

  2. They must have a SSL certificate, but they can get this after the install.

  3. Provide Execu/Tech with the folder assiciated with this site.

  4. Provide Execu/Tech with the domain for this site.

    Execu/Tech will typically perform the rest of these steps.

  5. The web service can be installed in:
    • The default site
    • A new site
    • Sub folder in the WebRes site if it is also installed. WebRes

  6. Place the two files in the folder provided by the customer. It is best to create sub folders, just to make it more obvious to anyone looking at the folders and also to separate different brands of interfaces on the same computer, should that ever happen.
    An example of this folder structure is "inetpub\wwwroot\ETOTAService\". 



    • In this example, it's installed in its own folder in the 'default' site. WebRes can also reside in this folder, which is why you create the sub folders "\ETOTAService\".
    • Once the customer has provided the URL to the folder they created, you can give them the URL to the web service. This URL must be provided to the CRS. 
    • In the example, if the URL was "HTTPS://ota.customer.com" then the url for the interface would be "HTTPS://ota.customer.com/ETOTAService/ETOTAService.aspx"
    • The interface URL (PMS URL) must be given to Execu/Tech and the CRS provider (Travelclick, etc.)
    • IMPORTANT NOTE
      If the customer created a new site for the interface, the site's folder will be the root folder of the interface. 
      If the site's folder is "C:\inetpub\wwwroot\ETOTAService\" then the PMS URL will be "HTTPS://ota.customer.com/ETOTAService.aspx" 

  7. The IIS App Pool user (Local machine, not the domain) or IIS_IUSRS group must have full permissions to the "RQFiles" folder.

  8. The settings file "ETOTAService.inc" must be edited. You can edit it in Notepad or any other text editor. Be careful not to mess up the "<%" and "%>" at the beginning and end of the file.
    You may have to grant your Windows user full permissions to this folder to edit.
    • RequestFolder - This is the path to the "RQFiles" folder from the Web Service computer. 
    • ResponseFolder - This is the path to the "RSFiles" folder from the Web Service computer. 
    • ResID_Source - This isn't used, yet, but enter a one word name, all caps, for the interface brand. (TRAVELCLICK, WINDSURFER, etc.)

  9. Test the PMS URL. Enter it into a browser and you should see the following message.
    OTA / HTNG message expected. Nothing received - OTA/HTNG Interface - Execu/Tech Systems, Inc. - www.execu-tech.com - 850.747.0581 

OTA / HTNG Processor (ETHTNG.exe)

This application reads the XML message from the CRS, processes any new, modified or cancelled reservations, and generates a response if needed.

There is one executable and two folders and several sub folders. It's ok for these files to be installed in the HOTEL folder as long as the computer running IIS has permissions to access the "RQFiles" and "RSFiles" folders.
To install:
  1. Copy the contents of the "To Hotel Folder" folder into the Hotel folder.

  2. Run" ETHTNG.EXE" and fill in the settings.  You might get an error the first time you run the application because the settings file doesn't exist.
    Items in RED are provided by the CRS.

    Basic Settings
    Hotel Name 
    		 This is the hotel's name.
    Tokenize CC  This works with Shift4 only. If you want to tokenize guest credit cards, check this box. You must also configure Terminal 98 in MENUS4CO. 
    If cards aren't tokenized using this method, all guest credit card information is stripped before the reservation is imported. The card information isn't saved so it will have to be obtained from the CRS to tokenize by hotel staff.
    Use custom name separator  The default name separator is a comma. If you use something different, check the box and you can choose from the following:
    , / \ | ; : -  
    Dubug Check this to see popup messages to assist in debugging a problem. 
    This should only be used when debugging problems.
    Save log?  Check this to save an additional log of the back and forth communication with the CRS.
    This should only be used when debugging problems.
    Test Mode  Check this to read the incoming XML from a file.
    This should only be used when debugging problems.
    Don't Delete Request  Check this to leave the previous XML request. This allows you to quickly retry the same request over and over. 
    This should only be used when debugging problems.
    HTTP / XML Settings   
    CRS URL 
    		 This is the URL to the CRS Web Service. 
    PMS URL 
    		 This is the URL to the PMS Web Service. Not required with a "Pull" interface. 
    Username  This is the interface username. 
    Password  This is the interface password. 
    Hotel Property Code  This is the Hotel's property code with the CRS. 
    Chain Code  This is the hotel's "Chain Code" that is assigned by the CRS. Rarely used.
    Interface Type  This is the brand of the interface. 
    HTTP PUSH / PULL  Whether the CRS "pushes" reservations to us or we "pull" them from the CRS.
    "Push" means that the CRS uses our Web Service to send messages to us.
    "Pull" means that we use their Web Service to request messages.
    Multi Res  Checked if the CRS sends more than one reservation in a message. 
    HTNG Checked if the CRS uses the HTNG specs. 
    Single Request  Checked if the CRS sends more than one message type (New, Modified, Cancelled) in a message. 
    Check for a Reservation  This is the interval, in seconds, that the "Pull" interface will check for changes. Some CRS companies have preferred intervals.
     
    File Settings   
    Request (Inbound)  This is the path to the "RQFiles" folder. 
    Response (Outbound)  This is the path to the "RSFiles" folder. 
    Execu/Suite Folder  This is the path to the HOTEL folder. 
    Save Requests  Checked only when testing and you need to save a copy of the XML message from the CRS. 
    Remappping   
    Copy Reservation Source  Checked if you want the reservation source (Expedia, etc) placed in the Company field. 
    Override Market Segment  Checked if you want to override the CRS Market Segment code with the specified code. 
    Override Source of Business  Checked if you want to override the CRS Source of Business code with the specified code.
    PMS Rate Use?  Checked if you want to use the specified rate code with the interface. YOU MUST USE AT LEAST 1 RATE. 
    The interface will only update a single RatePlanCode for each PMS Rate Code. For example, PMS Rate Code 2 can update the CRS RatePlanCode "RACK" but not both "RACK" and "AARP". Ask your CRS vendor about linked rates. These linked rates might be 10% lower or $5.00 less than the master rate that the PMS updates. By using linked rates, the PMS can update the CRS RatePlanCode "RACK" with PMS rate code 2, which will cause all of the CRS  RatePlanCodes that are linked to "RACK" to be updated as well.
    *In all cases, regardless of the rate or rate code, we will post the dollar amount provided by the CRS. This ensures that the guest will always be charged the rate they agreed to when booking even if there is a miss-match in the PMS.
    RatePlanCode  This is the Rate Plan Code in the CRS.
    Category  2 way only. This is the Rate Plan Category in the CRS
    ShortDesc  2 way only. This is the Short Description of the rate plan.
    LongDesc  2 way only. This is the Long Description of the rate plan.
    2 Way   
    Enable 2 way interface  Checked if the 2 way interface is used. 
    Number of days  This is the number of days of data that the CRS will accept. Typically 180 or 365, but ask the CRS vendor.
    The interface supports sending 1 - 730 days.
    Send Rates  Checked if the 2 way interface will send rates.
    Send Availability  Checked if the 2 way interface will send availability.
    Send Minimum Length of Stay  Checked if the 2 way interface will send minimum length of stay.

  3. Save the settings and create a Scheduled Task that runs on startup. Use the System user unless the PMS folder or RQFiles and RSFiles foders are on other computers. In that case, the customer will need to provide a user with permissions to these folders.

OTA / HTNG Sender (ETHTNG-Sender.exe)

This application is only used with the 2 way interface. It sends responses to messages from the CRS and also sends the 2 way messages (Rates, Availability and Minimum Length of Stay) to the CRS.

There is only one file with this interface, "ETHTNG-Sender.exe". It must be installed to the same folder as the OTA / HTNG Processor application, "ETHTNG.exe". Because this application uses the same setup file, the setup is easy:
  1. Create a Scheduled Task. Use the System user unless the PMS folder or RQFiles and RSFiles foders are on other computers. In that case, the customer will need to provide a user with permissions to these folders.

  2. Every setting you see is for testing purposes. Don't change them.

Set PMS Company Number

In the PMS software folder, open the file "garimptc.fil" and edit the line where XX represents your 2 digit company number that will be interfacing.

COMPANY=XX
 

After installation
  1. Test the URL of the Execu/Suite Web Service if it was installed. You should see the following message.
     "OTA / HTNG message expected. Nothing received - OTA/HTNG Interface - Execu/Tech Systems - www.execu-tech.com - 850.747.0581"


  2. Make sure the Scheduled Tasks are running.




Article ID
 ota___htng_installation_and_configuration
Views
 6648
Last Modified
 7/10/2020 8:53 AM