SapphireIMS can integrate to Human Resources Management Systems (HRMS) databases and synchronize the data directly into its database. This is useful in situations where user data in an HRMS database has to be periodically synced with SapphireIMS. This topic describes the steps to perform this integration. SapphireIMS can integrate and pull data from multiple databases.
Note: This configuration
needs database programming expertise. Contact SapphireIMS Support if you
want any integration to be done.
Click Settings, from Advanced System Settings section, click Global Settings.
Select 'HRMS Integration synchronization interval' and enter the ‘Setting Value’. Setting value is the Interval (in days) in which the HRMS data will be synchronized with SapphireIMS. Click on 'Update'.
Select 'Source type used for HRMS synchronization' and enter ‘Setting Value’ as 4. Source values used for the HRMS integration in SapphireIMS are 0 for HRMS Sync disabled, 1 for XML source, 2 for XLS source, and 4 for Database Server. Click on 'Update'.
Add the HRMS database details in 'hrms_database_details' table. Note that this is not supported in the user interface and involves accessing the SapphireIMS database directly.
Insert into `hrms_database_details` (`jar_file_name`,`driver_class_name`,`jdbc_url`,`hrms_dbserver_username`,
`hrms_dbserver_password`,`hrms_dbserver_ipaddress`,`hrms_dbserver_port`,
`hrms_dbserver_schemaname`,`query_type`,`query`,`hrms_table_name`,`sapphire_table_name`,`procedure_name`) values ('mysql-connector-java-3.1.8-bin.jar','com.mysql.jdbc.Driver','jdbc:mysql://MACRO_IP:MACRO_PORT/MACRO_SCHEMA','ims',
'RExVSFptaVM4YnZ1WkRSSm15TTVEdmpHYkY0LzdnPT1fU0FQUF82','localhost','3306','ims','table','','hrmstablename',
'sapphiretablename','');
where jar_file_name is the JDBC driver library name;
driver_class_name is the driver class name;
jdbc_url is the URL of the database to get connected (the format depends on the JDBC driver);
hrms_dbserver_username is the username for the DB Server
hrms_dbserver_password is the password for the DB Server and should be encrypted
hrms_dbserver_ipaddress is the IP address of the system where the DB server is running
hrms_dbserver_port is the port number used by the DB server
hrms_dbserver_schemaname is the name of the schema to connect
query_type can be query or table
query: if the query type is query then the query is to be provided else left empty
hrms_table_name: if query type is table then the table name from which the entire data is to be pulled is provided here
sapphire_table_name is the table name where the data need to be copied
procedure_name is the procedure name with or without parameters
In the following path, create a folder named as 'JarFileNames'
<SapphireIMS Installed Path> / Webmanagement / standalone / deployments / SapphireIMS.ear/SapphireIMS.war/WEB- INF/classes/sapphire/servicedesk/utils/
Place the JDBC driver jar file in the above folder
Any number of database servers can be added.
Data can be synced from multiple tables with each table specified in one row of the HRMS table.