Home > System Admin Role > Links & Integrations > Sage ESS

Sage ESS

Leverage Sage HRMS' Employee Self Service (ESS) Single-Sign-On service to automatically launch Cyber Train from the ESS Manager view or the ESS Employee section. Steps must be taken in both Cyber Train and Sage HRMS ESS to achieve this functionality.

In addition, the ESS user name must match either the Cyber Train Login Field (for the employee/student view) or the Cyber Train Login Field/User ID field (for the Manager view.) See each section for further details.  

Sage ESS does not need to be a public site, but Cyber Train does need to be able to browse to the Sage ESS URL. If both are internal to the network, then there’s not an issue, neither are public. However, if Cyber Train is public (hosted externally, or with Visibility Software, for example) and there is a desire to use the Single Sign-On with Sage ESS, then the Sage ESS system would have to be public so that Cyber Train can browse to it.  This would require port 80 or 443 to be open on the server.

Setup for Cyber Train

This step MUST be taken after ESS is already installed and running. 

IIS authentication for the Cyber Train site should have Windows Authentication Enabled. 

During a successful ESS installation, a web service is installed to the ESS web server. The AbraWorkForceConnSSI.asmx file for this service is generally found in the /SSOI folder within the root ESS installation folder but may be different depending on where it was installed. You can check for this file and identify the path necessary below by accessing ESS as a user normally would from a web browser.

When you get to the login page for ESS, do not log in, just add this to the end of the URL: ssoi/AbraWorkForceConnSSI.asmx. This should take you to a page with a header AWCSingleSignOn. If that is correct, copy the full URL with this extension and do the below steps. 

Once you know where this .asmx file exists, to the following:

(1) Navigate to where Cyber Train is installed

(2) Go to Website Folder > appsetting-override file

(3) Edit it in Notepad

(4) Find the section that reads something like this: 

<appSettings/>
     <add key = "ConString" value="25qJIQR7/cVnzsASPQvNhzfAW7dXfBSLwZwU2guvZXArNSkg+gpKO="/>
<appSettings/>

(5) Add the following key:

<add key="AbraAWCSSOI" value="http://www.vs.com/selfservice/SSOI/AbraWorkForceConnSSI.asmx" />

Except replace http://www.vs.com/selfservice/ with the path to your ESS /SSOI/AbraWorkForceConnSSI.asmx file as you identified it above. Notice this is a web path to that file, not a file system path. Your final block should look similar to the following…

<appSettings/>
     <add key = "ConString" value="25qJIQR7/cVnzsASPQvNhzfAW7dXfBSLwZwU2guvZXArNSkg+gpKO="/>
     <add key="AbraAWCSSOI" value="http://www.vs.com/selfservice/SSOI/AbraWorkForceConnSSI.asmx" />
<appSettings>

(6) Go to Website Folder > web.config file

(7) Edit in notepad

(8) Scroll down until you find a block this this:

<applicationSettings>

    <CyberTrain3.My.MySettings>

      <setting name="CyberTrain3_AWCAll_AWCSingleSignOn" serializeAs="String">

        <value>http://localhost/selfservice/SSOI/AbraWorkForceConnSSI.asmx</value>

      </setting>

    </CyberTrain3.My.MySettings>

  </applicationSettings>

(7) Verify the value here matches the key just added to the appsetting-override file. 

Setup for Sage HRMS Workforce Connection

1. Create a link allowing ESS users (students and managers) to automatically login to their Home Page.  ESS Employee Single Sign-On
2. Create a link allowing ESS users (training administrator, instructors and those managers who have a user security profile)  to automatically login to Cyber Train. ESS Manager Single Sign-On

Back to the Top

(2) Check the .asmx file – Can the URL be hit? 

- Open the web.config file and look for a line that looks like this: 

<add key = "AbraAWCSSOI" value="http://other/AWC/SSOI/AbraWorkForceConnSSI.asmx"/>

- Copy the link and put it in a new browser.  If the page comes up this connection is correct.  If the page does not come up, the link is not correct.

- Go to where the ESS executable is installed to find out the right link and update it in the web.config.

​

Login to CT from ESS

(5) Is the .NET accurate?  

- When you run the installer for Cyber Train, it updates the .NET.  See if that extended itself to the ESS.

- If it did change the .NET, then put it back.  (Example - it used to be .NET 2 but CT Installer upgraded it to .NET 4.  Put it back to .NET 2 for that pool.)

(6) Is the key in the appsetting-override file the same as the link in the web.config file?

- In the Website folder > appsetting-override file - edit in notepad.  It should have key that looks something like this:

​

<add key="AbraAWCSSOI" value="http://www.vs.com/selfservice/SSOI/AbraWorkForceConnSSI.asmx" />

- In the Website folder > web.config file - edit in notepad.  It should have a section like this where the link is the same as what is in the appsetting-override file.

<applicationSettings>

    <CyberTrain3.My.MySettings>

      <setting name="CyberTrain3_AWCAll_AWCSingleSignOn" serializeAs="String">

        <value>http://localhost/selfservice/SSOI/AbraWorkForceConnSSI.asmx</value>

      </setting>

    </CyberTrain3.My.MySettings>

  </applicationSettings>

​