Devart ODBC Driver for Zoho People: HR Data for Headcount, Attendance and Org Reports
Devart ODBC Driver for Zoho People is a Windows ODBC driver, $109.95 a year, that lets HR teams and analysts query Zoho People with SQL from Excel, Power BI, Access or SQL Server. Its 34 tables cover employees, departments, designations, attendance, benefits, company assets, announcements, and the clients, projects and tasks of Zoho People's time tracking.
HR reporting usually ends up in spreadsheets: headcount by department for the finance plan, attendance for payroll checks, new hires by source for recruiting. This driver feeds those spreadsheets straight from Zoho People instead of from repeated exports.
Quick facts
- Version: 1.9.0, out October 16, 2026; first released December 15, 2021
- Developer: Devart
- System: Windows Vista or newer, 32-bit or 64-bit, Terminal Server supported, .NET Framework 4.5 or later
- Sign-in: Zoho data center plus a refresh token from "Sign In with Zoho". Unlike Devart's Books, Desk, Inventory and Invoice drivers, no Organization ID is needed
- Tables: 34, including Employees, Departments, Designations, Attendances, Benefits, Assets and Announcements
- Price: $109.95 per year or $219.95 perpetual for one desktop user
- Trial: 30 days with a key from a free Devart account
- Refund: within 30 days if a technical problem prevents use and support can't resolve it
- What we checked: the order page charged $109.95 for Desktop for Windows on a 1-year subscription, and the download page listed version 1.9.0 at 32.59 MB, on November 14, 2026. We didn't sign it in to a Zoho People account
Before you buy
This driver moves personal data (names, e-mail addresses, gender, job details, attendance) out of Zoho People's access controls and into whatever workbook or database you load it into. Agree with whoever handles data protection where those copies may live, use a Zoho account that sees only the employees a report needs, and avoid emailing refreshed workbooks around.
Download Free Trial Buy Now
Overview
Zoho People organizes HR data as forms, and Devart's driver turns them into tables. The Employees table carries the employee record (first and last name, e-mail ID, photo link, job description, source of hire, gender and more); Departments include a parent department ID, so you can rebuild the org tree; Designations hold job titles with their approval status; and Attendances hold attendance records.
Excel Navigator connected to a Zoho People DSN: 34 tables (ADA, Announcements, Assets, Attendances, Benefits, Clients and more) and a preview of Employees.
Setup is the simplest of Devart's Zoho drivers: choose the data center and sign in to Zoho. Because the connection has no Organization ID field, the driver works with the Zoho People account of whoever signed in.
Features
Headcount and org structure
Devart ODBC Driver for Zoho People exposes Departments with a ParentDepartmentId column and Designations with approval status, so headcount per department, top-level department counts or titles awaiting approval are single queries. Devart's sample combines both counts with UNION ALL.
Attendance data for payroll checks
Devart ODBC Driver for Zoho People includes an Attendances table, which lets payroll or operations staff total attendance per employee or team for a pay period in Excel.
Benefits, assets and announcements
Devart ODBC Driver for Zoho People also returns Benefits, Assets (equipment issued to staff) and Announcements, useful for audits such as listing laptops held by people who are leaving.
Time tracking objects
Devart ODBC Driver for Zoho People covers the clients, projects and tasks from Zoho People's time tracking module, so project hours can be reported beside HR data.
Edits from SQL
Devart ODBC Driver for Zoho People supports INSERT, UPDATE and DELETE, for example to correct a field on many employee records after a reorganisation.
Benefits
- Headcount for finance without exports. Budget workbooks refresh from Zoho People.
- Recruiting insight. SourceOfHire on Employees shows which channels (direct, referral) bring in staff.
- Asset accountability. Join Assets with Employees to see who holds which equipment.
- HR next to payroll and projects. A SQL Server linked server combines People data with payroll or project systems.
Real-World Uses
- Monthly headcount pack. An HR analyst refreshes a Power BI report of headcount by department and designation for the leadership meeting.
- Attendance reconciliation. A payroll officer compares Zoho People attendance totals with timesheets in Excel before each pay run.
- Offboarding checklist. IT lists the assets assigned to employees who are leaving so equipment is collected on time.
- Hiring source review. A recruiter counts hires by source of hire per quarter to decide where to advertise.
Who It's For, and Who Should Skip It
The Zoho People driver serves HR analysts, payroll staff, HR IT administrators and finance planners on Windows whose company runs Zoho People and who build HR reports in Excel, Power BI or a SQL Server database.
Skip it if Zoho People's built-in reports and dashboards already satisfy your HR team, if you work on a Mac, or if your data protection rules don't allow HR data in local spreadsheets.
Usage Guide
- Use the Download button on this page to get the trial (a free Devart account is required) and install it.
- Open the ODBC Data Source Administrator that matches your program (32-bit or 64-bit) and add a DSN for Devart ODBC Driver for Zoho People.
- Enter the trial key on the License tab.
- Select the Zoho data center that hosts your Zoho People account, click Sign In with Zoho, approve access and keep Save Token ticked.
- Click Test Connection, then connect Excel, Power BI or another tool to the DSN.
Tip
Sign in with a dedicated reporting account that has access only to the employee data your reports need. Since the DSN has no Organization ID or separate permission layer, the Zoho user behind the token is your only access control.
Where It Falls Short
- Windows only. There is no Mac or Linux build.
- API speed. Large attendance histories come through the Zoho People API page by page and can be slow; requests count toward Zoho's API limits.
- Sensitive data leaves Zoho. Once in Excel, employee data is outside Zoho People's permissions and audit trail.
- Schema not documented per table. You discover the columns of the 34 tables in your tool; Zoho People custom forms and fields may need checking in the trial.
What Users Say
Zoho People users haven't published reviews of this driver; Devart's ODBC drivers are rated as one product line.
The line in brief
Capterra users give Devart ODBC Drivers 4.7 out of 5 (26 reviews), and Software Advice shows 4.4 out of 5 for support. The comments name database and Salesforce drivers, not HR systems, and centre on easy setup and fair pricing, with a learning curve for SQL beginners as the usual drawback.
For HR use, the more important check is coverage: confirm in the trial that your custom Zoho People forms appear as tables before relying on the driver for regular reports.
Comparisons
ODBC driver vs. Zoho People reports
Zoho People's own reports stay inside its permission model and cost nothing extra. Devart ODBC Driver for Zoho People ($109.95 a year) is for HR data that must be combined with finance, payroll or project data in other tools.
People driver vs. Devart's other Zoho drivers
Devart's Books, Desk, Inventory and Invoice drivers each ask for an Organization ID; the Zoho People driver asks only for the data center and a sign-in. All five cost $109.95 a year except Zoho Desk at $139.95.
Editions and Pricing
| Edition | 1-year subscription | Perpetual | Who can use it |
|---|
| Desktop for Windows | $109.95 | $219.95 | One user at a time on one computer |
| Server Standard for Windows | $799.95 | $1,599.95 | Several users on one server with up to 6 cores, one legal entity |
| Server Enterprise, Site, OEM | Quote | Quote | Any core count, a whole company, or shipping the driver in your own app |
One Buy Now button covers all editions: checkout starts at Desktop for Windows, 1-year subscription, and the edition, the 1-, 2- or 3-year term or the perpetual license is chosen there. Priority support can be added, and orders of 5, 10 or 20 copies get 5, 10 or 15 percent off.
FAQs
Does Devart ODBC Driver for Zoho People need an Organization ID?
No. Devart ODBC Driver for Zoho People connects with only the Zoho data center and a refresh token from Sign In with Zoho.
Can the Zoho People driver read custom forms?
Devart ODBC Driver for Zoho People lists 34 tables in its documentation screenshot, covering Zoho People's standard forms. Check custom forms and fields with the 30-day trial.
Which data centers can the Zoho People ODBC driver use?
Devart ODBC Driver for Zoho People has a Data Center setting that includes Europe, and versions 1.4.0 to 1.7.0 added Japan, Canada and Saudi Arabia.
Can HR and payroll share one license?
Not at the same time on Desktop. Devart ODBC Driver for Zoho People Desktop is for one user at a time; a shared reporting server needs Server Standard at $799.95 a year.
Can I update employee records with the Zoho People driver?
Yes. Devart ODBC Driver for Zoho People supports UPDATE, INSERT and DELETE, limited to what the signed-in Zoho user is allowed to change.
System Requirements
- Windows (Vista or newer, desktop or server, 32-bit or 64-bit, Terminal Server too)
- .NET Framework 4.5 or later
- 32.59 MB installer; only one driver version installed
- A Zoho People account with access to the data you report on
- HTTPS connection to the Zoho data center, optionally via proxy
Conclusion
Devart ODBC Driver for Zoho People is worth $109.95 a year for HR and payroll teams that rebuild the same headcount, attendance and asset reports from Zoho People every month. The 34 tables and the two-field sign-in make it the quickest of Devart's Zoho drivers to set up.
The reason for caution is the data itself: employee records end up outside Zoho People, on Windows only, at API speed. Agree on where the data may go, then test it with the free trial.
Download Free Trial Buy Now