OneAnalytics docs

Connect Tally Prime / ERP 9

Tally does not expose a network API by default. OneAnalytics connects via Tally's built-in ODBC server plus our gateway agent, which runs on the same Windows machine Tally is on and relays queries over an mTLS tunnel to our cloud.

1. Enable ODBC in Tally

  1. Open Tally Prime with your company loaded.
  2. Go to F1 → Settings → Connectivity → ODBC Server (ERP 9: F12 → Advanced Configuration → Client/Server).
  3. Set ODBC Server to Yes.
  4. Set the port to 9000 (OneAnalytics default — change if it conflicts, and update the gateway config).
  5. Keep Tally running. ODBC is live only while Tally is open with a company loaded.

Verify from a terminal on the same machine:

Test-NetConnection -ComputerName 127.0.0.1 -Port 9000

TCP 9000 must be LISTENING. If not, check Windows Firewall and re-enable ODBC in Tally.

2. Install the gateway agent

Download the installer from Sources → Add → Tally → Download agent in the OneAnalytics UI. Run OneAnalyticsGateway-Setup.exe as Administrator.

During setup you'll paste an enrollment token (copy from the same dialog). The token authenticates the agent to gw.analytics.rstglobal.in:443, establishes an mTLS tunnel, and registers the agent with your workspace. Token expires in 15 minutes.

The agent runs as a Windows service (OneAnalyticsGateway) and auto-starts on boot.

3. Map the company

Back in Sources → Add → Tally, the just-installed agent appears. Pick the company from the dropdown (the agent enumerates them via the ODBC Company table) and click Test. You should see the row count for Ledger, Voucher, StockItem.

4. Preview the data

OneAnalytics pulls these tables by default:

  • Ledger, Group, StockItem, StockGroup, GoDown
  • Voucher, VoucherLine, LedgerEntries, InventoryEntries
  • CostCentre, CostCategory, Unit, Currency
  • Company (meta)

Incremental sync uses AlterID — the first refresh is a full import (~5 min for a mid-size company), subsequent refreshes pull only changed masters and vouchers since the last AlterID.

Troubleshooting

  • "ODBC Server not running" — Tally is closed, or no company is loaded. See Tally gateway troubleshooting.
  • "Unknown field" — You're on a very old ERP 9 build. Upgrade to 6.6.3+ or contact support.
  • Slow first sync — Disable virus scanner realtime check on C:\Users\<user>\Tally\* during import; memory is the bottleneck, not disk.