Developing a tool to connect an HR system (OBIC) and SmartHR

OBIC and SmartHR logos

This case at a glance

ClientWatanabe Pipe Co., Ltd.
ChallengeDouble entry between the HR system and SmartHR
What we didA two way data integration tool, from requirements to testing
ProductsSmartHR, OBIC HR system, AWS
ResultsNo more manual entry or copying, and fewer input errors
  • About the client

    • Industry: Specialized trading company
    • Company overview: A trading company supporting the construction and building equipment industries, mainly selling plumbing materials and housing equipment. It has sites across Japan and actively promotes DX in the industry.

  • Challenges

    • Workload from limited integration between the HR system and SmartHR
     Two way integration between the HR system and SmartHR was not in place, and data was managed by hand alongside internal systems.

    • Burden of manual entry and checking
     Double entry and copying of data occurred easily, and a lot of time went into input errors and checks.

    • Complicated management of payroll and attendance information
     The latest payroll and attendance data was updated and managed by hand, making accuracy and timely updates difficult.

  • Solution

    1. Building a two way data integration tool between SmartHR and the HR system
     We handled everything from requirements definition to testing, investigating the systems to be connected, understanding their specifications, organizing requirements, and checking nonfunctional requirements. We also designed a stable two way data integration platform, decided the API specifications, and helped create a mechanism that can support future system additions and functional expansion.

    2. Unifying and automating work
     Through infrastructure setup, API development, and data input and output processing, we unified and automated the work, prevented input errors through automatic data integration, and assured quality through unit, integration, load, and security testing.

  • Results

    • More efficient work and fewer input errors
     Automatic integration between SmartHR and the HR system removed manual entry and copying and reduced input errors, greatly shortening the time spent checking and processing HR data.

    • Information shared in real time
     An environment that manages payroll, attendance, and HR information in one place and lets it be checked and updated immediately has, according to the client, made coordination between departments smoother.

    • More accurate HR work
     Processing is always based on the latest data, improving the accuracy of payroll and attendance management and reducing the work of checking and correcting.

    • A platform for future expansion
     The API integration platform can flexibly handle regulatory changes and new systems, establishing a structure that responds smoothly to changes in work.