STS Connector
Sync your STS driver and vehicle data with your applications and analyze it in Excel, Google Sheets, Power BI or Data Studio.
Pathta connects to the partner API of STS (Social Transport Solutions), the French workforce management software for transport companies, and makes your employee, vehicle, activity and infringement data available to your databases, business applications and reporting tools, with no code.
Published by Now-Code, a software publisher based in Bordeaux, France.
Visualize your STS 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 dashboards on your STS data: driver activities and counters, infringements, expenses, employee and vehicle alerts. Pathta acts as the data source, with no connection to develop against the STS API.
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 STS 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 STS
Add STS as a source, enter your STS partner API credentials and choose the tables you want to expose.
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 STS and Pathta
Human resources
Employees created in STS automatically appear in the TimeTonic HR application: one single entry, records always up to date.
Fleet management
The STS vehicle register is synced with TimeTonic, where the team tracks the assignment and alerts of each vehicle.
Operations management
Driver activities, counters and infringements feed a Power BI compliance dashboard, refreshed with no exports from STS.
Frequently asked questions about the Pathta connector for STS
Can't find your question here? Email us at contact@pathta.com.
The connector at a glance
What is the Pathta STS connector?
The Pathta STS connector is a no-code tool that reads data from the STS software (Social Transport Solutions) through the partner API to sync it with a database or business application, and display it in Excel, Google Sheets, Power BI or Data Studio (formerly Looker Studio).
Which STS data can I retrieve?
Employees and the vehicle register, as well as employee activities, counters, events, processed segments and expenses, employee and vehicle alerts, and driver and company vehicle infringements.
How do I export STS data to Excel?
Install the Pathta add-in from Excel, sign in to your Pathta account and load the STS path you need. The data lands in an Excel table you refresh in one click, with no manual export from STS.
How do I display STS data in Power BI?
In Power BI, add the Pathta source, enter your key and select the STS path. You then build your workforce dashboards (activities, infringements, expenses) and refresh them with no re-keying.
Which applications can I sync STS data with?
Pathta sends STS data to TimeTonic, Airtable, Bubble, Xano, Supabase, SQL Server, PostgreSQL, MySQL or Microsoft Access. For a database hosted on your own servers, the Pathta local agent opens an outbound connection: no inbound port needs to be opened.
Does the connector change data in STS?
No. The STS connector is read-only: STS remains the reference, and Pathta copies the data to your applications and reporting tools.
Do I need to code to use the STS connector?
No. Everything is configured in the Pathta interface: no API to call, no script to maintain.
Connect STS to your tools today
Create your account, connect your source, and open your first path in Excel in just a few minutes.
