On-Premises Active Directory Connector
Sync the users of your on-premises Active Directory with TimeTonic and your applications, for both reading and writing.
Pathta reads and updates the user accounts of your on-premises Active Directory, custom attributes included, through the Pathta agent installed on your network. Your employees are synced with TimeTonic and your business tools, with no code and without exposing your domain controllers to the internet.
Published by Now-Code, a software publisher based in Bordeaux, France.
Visualize your Active Directory data where you work
The same path opens in the spreadsheet or BI tool of your choice. You refresh, and the numbers follow.
In your spreadsheets
To analyze, rework and share your data every day.
Excel
Load your tables directly into a workbook. PivotTables, formulas, and charts stay connected to fresh data: one click on Refresh is all it takes.
The Pathta add-in for Excel →Google Sheets
Import your data and share an always up-to-date table with your teams or your clients. Ideal for collaborative tracking and quick exports.
The Pathta add-on for Google Sheets →In your BI tools
To steer your business with dashboards that are always up to date.
Power BI
Build reports on your directory: accounts by department or site, disabled accounts, missing attributes. Pathta acts as the data source, with no CSV export from Active Directory.
The Power BI connection in detail →Data Studio
Select the Pathta connector from the gallery, paste your key, and choose your path: your reports populate and can be shared with a single link.
The Data Studio connector →How to connect Active Directory with Pathta
A few minutes are enough to set up your first flow, no developer needed.
Each data flow is called a path: a selection of tables, fields and filters you can reuse anywhere.
Create your account
Sign up at pathta.io (30-day free trial)
Connect Active Directory
Install the Pathta agent on your network, add Active Directory as a source and choose the user attributes to read or write.
Build a path
Select the tables, fields and filters you need.
Choose the destination
Open the path in Excel, Google Sheets, Power BI or Data Studio, or schedule a sync.
How our customers use Active Directory and Pathta
HR and IT
An employee created in Active Directory automatically appears in the TimeTonic HR application, with their department, job title and custom attributes.
Directory updates
A change of job title, department or phone number entered in TimeTonic is written back to Active Directory: the directory stays up to date with no re-keying by IT.
Audit and compliance
Directory accounts land in Excel or Power BI: disabled accounts, missing attributes and gaps with the staff register are spotted with no script.
Frequently asked questions about the Pathta connector for Active Directory
Can't find your question here? Email us at contact@pathta.com.
The connector at a glance
What is the Pathta Active Directory connector?
The Pathta Active Directory connector is a no-code tool that reads and writes user accounts in an on-premises Active Directory through the Pathta agent. It syncs your employees with TimeTonic, a database or a business application, and displays them in Excel, Google Sheets, Power BI or Data Studio (formerly Looker Studio).
Does the connector work with an Active Directory hosted on our own servers?
Yes, it is designed for on-premises Active Directory. The Pathta agent, installed on your network (Docker container, executable or Windows service), opens an outbound connection to Pathta: no inbound port needs to be opened and your domain controllers stay inside your information system.
Which Active Directory data can I read and write?
User accounts and their attributes: first name, last name, login, email, department, job title, phone, manager… as well as the custom fields of your directory, for example the extensionAttribute1 to 15 attributes.
How do I sync Active Directory with TimeTonic?
In Pathta, link the Active Directory source to your TimeTonic database, map AD attributes to TimeTonic fields, then choose the sync direction and frequency. New employees and changes are picked up automatically.
Can I update Active Directory from a business application?
Yes. The connector writes to the directory: information entered in TimeTonic or in a SQL database (job title, department, phone, custom fields) is applied to the matching user accounts.
How do I export Active Directory users to Excel?
Install the Pathta add-in from Excel, sign in to your Pathta account and load the Active Directory path you need. The user list lands in an Excel table you refresh in one click, with no CSV export.
On-premises Active Directory or Microsoft Entra ID?
This connector targets the Active Directory installed on your own Windows servers (AD DS). Microsoft Entra ID, formerly Azure AD, is Microsoft's cloud directory service.
Do I need to code to use the Active Directory connector?
No. Everything is configured in the Pathta interface: no PowerShell script and no LDAP query to maintain.
Connect Active Directory to your tools today
Create your account, connect your source, and open your first path in Excel in just a few minutes.
