Help & Support Center
Search:  
Contents
:
IndexPrintBookmark

Home > Guides > Administrator Guide > Integration > HRIS Systems > Sage HRMS  > Pull Via Web API

Pull Via Web API

Need Help on this Topic? Email Support


​

Cyber Recruiter and Sage HRMS can be connected so that when (1) new codes are added to Sage HRMS it will update Cyber Recruiter  (inactive codes in Sage HRMS are ignored) (2) when employees are terminated in Sage HRMS, Cyber Recruiter is updated. Codes must be set up at the Enterprise level in Sage HRMS.

Take the following steps to set up this integration. 

 

Ensure the following components are set up before beginning
  1. .NET 3.5 SP1 needs to be installed/activated
  2. The account accessing the database from the program must be an SQL account (not Windows Authentication) 

Sage to Cyber Recruiter

This section pulls information from Sage HRMS over to Cyber Recruiter and can work independently of the new hire / job change process from Cyber Recruiter to Sage HRMS. 

On the Sage HRMS Server, or for hosted clients or those using a different server for Cyber Recruiter, on a server that can browse to the internet via port 80 and connect to the Sage SQL database via port 1433

Note: If using other ports for this, please contact Tech Support for instructions on how to set up.

  1. Create an empty folder somewhere on the server to hold the integration files 
  2. Download and unzip http://www.vspublic.com/crupdates/SageToCyberRecruiterRemote.zip to that folder 
  3. Right-click on SageToCyberRecruiterRemoteSetup.exe and choose Run As Administrator
  4. This tool can be used with the Enterprise system of Cyber Recruiter.  In order to do so, multiple connections are established between the Sage system and Cyber Recruiter.  For each database connection, add a connection and complete the various tabs which appear.  Use the Add button to add a new connection.
  5. On the first tab (Setup), fill in all the fields to connect the two systems.
    1. SQL Server, Database, User ID and Password = this is the connection to the Sage HRMS database
    2. Select if the two systems will be in the same network (Local) or if the integration will be across networks (remote)
    3. If Local 
      1. Enter the SQL Server, Database, User ID and Password for the Cyber Recruiter database
    4. If Remote 
      1. Web Service = URL to the Cyber Recruiter API
        1. If Visibility Software hosts your system please call our support line for this URL
        2. If the software is on your network, the URL would have been created by your IT group.
      2. Authorization Code = Allows the Cyber Recruiter web service to confirm connection
        1. If Visibility Software hosts your system please call our support line for this code
        2. If the software is on your network, then this can be found by editing the webconfig file in the Cyber Recruiter file structure.  It will be the 'value' found in the line which contains add key = "ConString"
  6. On the second tab (Sage ESS), enter the Sage ESS database information to bring the Sage ESS credentials over to Cyber Recruiter for Single Sign-on from the ESS module. 
    1. SQL Server, Database, User ID and Password = this is the connection to the Sage ESS database
  7. On the third tab (SMTP) 
    1. SMTP Server and SMTP Port = Required for the email to work and is unique to the client site.
    2. From Email and To Email = A log file will be sent nightly, fill in the from and to addresses for the people responsible for this stage. This could be your default email for HR, but should be a monitored account.
  8. On the forth tab (Codes to Sync), choose what info should actually be synced from Sage HRMS to Cyber Recruiter.
    1. Check the fields which should be updated in Cyber Recruiter if they are changed in Sage HRMS.  
    2. The org levels for the codes must match between the two systems if the codes will be automatically updated.  For example, if Location is stored in Cyber Recruiter in Org Level 3 but in Sage HRMS it is stored in Org Level 5, then the codes should NOT be automatically updated.
      1. Employment Types = for example the Full Time / Part Time codes
      2. Functional Title = Job Codes in your Sage system
  9. On the fifth tab (Termination Status), choose the Overall App Status that an applicant will get if they are termed in Sage HRMS. This pulls the statuses directly from Cyber Recruiter but won’t work without a valid Web Service URL and Authorization Code on the Setup page.
  10. In Windows Scheduler, create three tasks
    1. A task to run SageESSToCyberRecruiterRemote.exe (this will be located in the folder where SageToCyberRecruiterRemote.zip was unzipped). This updates the Self Service Login field on the Employee/applicant file.
    2. A task to run SageToCyberRecruiterRemoteCodes.exe (this will be located in the folder where SageToCyberRecruiterRemote.zip was unzipped). This updates the codes selected on the Codes to Sync tab.
    3. A task to run SageToCyberRecruiterRemote.exe (this will be located in the folder where SageToCyberRecruiterRemote.zip was unzipped). This updates the terminations in Cyber Recruiter.