SQL Server Connector
Sync your SQL Server databases and analyze them in Excel, Google Sheets, Power BI or Data Studio.
Pathta connects SQL Server to your no-code applications and reporting tools, with no code. The local agent, installed on your network, reads your tables without exposing the server to the internet.
Published by Now-Code, a software publisher based in Bordeaux, France.
Sync SQL Server with your other tools
Your data no longer stays siloed. Pathta moves it to the applications that need it, in either direction.
SQL Server and your applications
Move your data between SQL Server and TimeTonic, Airtable, Supabase, Xano, Bubble, PostgreSQL or Access. You can also feed SQL Server with your Fillout form responses.
- Your no-code tools connected to company data
- Less re-keying and fewer duplicates
- Server never exposed, no inbound port
- Scheduled flows, no development
Your internal resources, connected to SQL Server
The agent gives access to data that never leaves your information system: databases, files stored on a server, or corporate directories.
- On-premises databases
- CSV and Excel files on a server or network share
- On-premises Active Directory: users and groups
- No inbound port to open
- Database not exposed to the Internet
- Easier sign-off from your IT department or CISO
Deploy it the way that suits your infrastructure:
Visualize your SQL Server 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 SQL Server tables and views: sales, production, finance. Pathta acts as the data source, without opening the server to the internet.
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 SQL Server 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 SQL Server
Install the Pathta local agent on your network, add SQL Server as a source and choose the tables or views 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.
Connect SQL Server to your tools today
Create your account, connect your source, and open your first path in Excel in just a few minutes.
