TECHNOLOGY
Simple integrations solve payroll challenges
A US based technology company which utilises SimPro for capture of Salary and Wage staff hours and timesheets, required integration of this data into their payroll solution, KeyPay.
LOCATION
Australia
INDUSTRY
Technology
EMPLOYEES
50+
PROBLEM STATEMENT
A US based technology company which utilises SimPro for capture of Salary and Wage staff hours and timesheets, required integration of this data into their payroll solution, KeyPay.
The integration required capture of hours booked in time blocks to Jobs and Quotes, in addition to time booked on Activities (per a schedule).
Time allocations for each staff member were to be synchronised into KeyPay with the following functional requirements:
- Timesheet data from SimPro is to be posted into KeyPay on a weekly / daily cadence
- Timesheet data is appropriately mapped to the Activity Schedule (responsibility for maintaining the schedules in both platforms remains manual)
- Timesheet data is appropriately broken down by block and assigned to Jobs and Quotes.
As an optional consideration the customer is currently also using other solutions for reporting and data gathering and may require a BI connector to replace this platform for collecting data from multiple data streams into a central location.
OUR SOLUTION
nanoConnect was deployed for the customer with an integration built to meet the functional requirements. The integration was capable of daily / weekly synchronisation of timesheet data between the two company systems. As time went on, the customer sought to acquire a different payroll solution, with the flexibility of the integrations being written in node.js and executed by the integration platform, this allows nano to rapidly modify and redeploy integrations to a different payroll solution by simply changing the data mapping of the fields being captured.
GET / POST of data from/to platforms with nanoConnect is achieved with a single line of code. When integrations run they validate client data including the credential used to authenticate requests with the customer’s system
CUSTOMER BENEFITS
Built for developers, the nanoConnect platform has allowed rapid development of the required integration and is able to achieve data scaling as the company grows. The platform is deployed with minimal effort and provides the customer with development, testing and production environments in which to build, test and deployed integrations between SimPro and any third-party applications.
As the company grows it will increase it’s need for actionable insights from the data it possesses. nanoConnect provides native BI connectivity to both SimPro, KeyPay, MYOB, SAP and other platforms allowing for easy aggregation of that data in solutions like Power BI.
Furthermore, since the client may wish to build automations and workflows that increase the productivity of their staff, nanoConnect provides a simple platform and framework for creating and maintaining automations and value-added services.
With integrations written in code, developers with JavaScript experience can easily understand and modify integrations in the future and adapt them to the ever-changing needs of the business.