Connectors

Bring your data in, the way you actually keep it.

Tally, SQL or spreadsheets: pick what you have. Cloud, on-premise, or both.

Available today

Connectors that work in production

Tally Prime & ERP 9

Windows plugin reads from the machine where Tally runs. Read-only.

PostgreSQL

Direct TLS connection with read-only credentials.

MySQL / MariaDB

Cloud or on-premise. Through Edge Sync Runner if needed.

SQL Server

Common in Indian ERPs. Plays nicely with on-premise installs.

ClickHouse

Fast analytical store. Ideal if you already centralise data.

CSV & Excel

Upload one-off files or refresh on a schedule.

On-premise

The Edge Sync Runner

Many Indian businesses keep their accounting and operations data on-premise. The Edge Sync Runner is a small Docker container that runs inside your network. It reads from your databases, syncs structured data to your AnalytAI workspace on a schedule, and never opens an inbound port.

  • • Outbound-only. No firewall changes for inbound traffic.
  • • You control what tables to sync.
  • • Works with PostgreSQL, MySQL, SQL Server, ClickHouse.
  • • Logs and health visible in the AnalytAI app.

Architecture

[ On-prem DB ] ─▶ [ Edge Sync Runner ] ──TLS──▶ [ AnalytAI ]
                  (Docker, in your VLAN)
                                                ▲
                                                │
                                           Your team
                                          (chat / dashboards)
        

FAQ

Connectivity questions

Which databases do you support today?

Tally (Prime and ERP 9 via plugin), PostgreSQL, MySQL, SQL Server and ClickHouse. CSV and Excel uploads are also live.

Is the connection secure?

Yes. SQL connections use TLS and read-only credentials. The Tally plugin only reads. The Edge Sync Runner keeps on-premise databases inside your network. Only answers travel out.

Do you store our raw data?

Cloud workspaces store synced structured data in your private workspace, encrypted at rest. With Edge Sync Runner, raw data stays on-premise; the cloud only sees aggregated answers.

What about a system we use that you do not support?

If it has a database behind it, we can probably read it. Tell us on the demo call.

Tell us what you have. We will tell you how to connect it.