KeyPay to PowerBI (One-Way) Integration FAQs

KeyPay to PowerBI (One-Way) Integration FAQs




This document addresses the variety of questions we encounter while helping clients. If you have a question that’s not addressed her please write to us at support@syncezy.com
. 

General Questions

How often does the sync run?

The sync runs every night and extracts data from Employment Hero Payroll and makes it available to connect from an external dashboard/reporting tool.

Can it be updated instantly?

Automatic sync occurs every 2 hours based on Employment Hero Payroll’s refresh schedule. However, the integration administrator can manually trigger unlimited instant refreshes at any time via the integration portal to update data immediately.

Do I have to use PowerBI or can I connect using another software?

You can use this connection in any analytics/reporting program that accepts database connection.  Typical examples include PowerBi, Tableau, Crystal reports, Klipfolio, Google Data Studio and more.
​

What tables does the integration sync from Employment Hero to Power BI?

The integration syncs the following 29 tables from Employment Hero into Power BI:

1birthday_report
2countries
3detailed_activity_report
4employee
5employee_details
6employee_leave_balances
7employee_locations
8employee_payslip
9employeegrouppermissions
10employeegroups
11leave_allowances
12leave_liability_report
13leaverequests
14locations
15pay_run_super_adjustments
16pay_run_totals
17paycategories
18payrun_activity_report
19payrun_earnings_lines
20payrun_inclusions_report
21payrun_leave_accrued
22payruns
23publicholidays
24reports
25roster_timesheet_comparison_report
26super_contributions_report
27timesheet_report
28timesheets
29timezones

Does SyncEzy build the reports?


We don't build reports for you.  We provide the connection and access to data in PowerBI. You can either build your own reports or there are external service companies who can build the reports/dashboards for you.  We can refer you to companies who understand Employment Hero Payroll and PowerBI very well.

Where is the Data Stored? 

The Data is stored in a SyncEzy Database on SyncEzy’s AWS servers that you can connect to from any analytics program.  Look in your SyncEzy account to see the database connection details.

How secure is the sync?

Short answer: Very secure.

The longer answer, The API keys are encrypted at rest and all our communication with Employment Hero Payroll is through 256 Bit SSL connections.


For servers and back end infrastructure we use the same secure AWS infrastructure that is used by all the world’s leading organizations.

We also offer two-factor authentication for the admin users using the SyncEzy integration.

Accounts and Pricing

Do you offer a free trial?

Unfortunately, due to the amount of work involved in the initial setup, we are unable to offer a free trial.  We can however get together on a call and give you a live demo in as much detail as you need. If you have any specific questions feel free to reach out.

Are there any lock-in contracts?

No contracts, we do not have long-term or annual contracts. We earn our keep every month by providing integration as a service.

What is your pricing?

Please create account https://integrations.syncezy.com/ and look for the integration to see the price. You can also contact us for custom quote. 

Have a support question?

We offer three support channels: 

Chat - Live Chat (24x5 support) from within your integration portal.  

Phone - #1 for Support
AUS: +61 2 9136 9448 
NZ: +64 9 303 2999 
UK: +44 203 670 1109
US: +1 720 500 9302