Synbus Solutions
Back to All Articles
HomeBlogTally XML vs ODBC: Which Method to Use?
Tally Integration

Tally XML vs ODBC: Which Method to Use?

TallyPrime offers two ways for other software to reach its data. ODBC is built for reading reports, while XML can also post data back into Tally. Here is how to choose between them.

S

Sumit Singh

Founder & Lead Automation Architect

Published on 2026-11-18
7 min read

1. The two interfaces at a glance

TallyPrime exposes its data through two interfaces. Both are useful, but they do different jobs.

ODBC lets reporting tools such as Excel or Power BI read Tally data as a database. Tally's own documentation describes the ODBC interface as read-only.

The XML interface works over HTTP. It can read masters and vouchers, and it can also send new data into Tally, which makes it the option for two-way work.

ODBC and XML side by side
QuestionODBCXML over HTTP
Read reports and ledgersYesYes
Write vouchers into TallyNoYes
Typical useDashboards and BI toolsImports, exports and two-way sync
SetupEnable ODBC in TallyPrimeEnable the HTTP server and send XML requests

2. When ODBC is the right choice

Choose ODBC when the goal is reporting. Trial balance, stock summary, sales register and receivables can all be read by a tool that connects over ODBC.

Because it is read-only, ODBC is a safer default when you only need Tally data in a spreadsheet or dashboard. Nothing can change your books through it.

  • Management dashboards that refresh from Tally
  • Read-only reports shared with partners or staff
  • Connecting Tally to Excel or Power BI

3. When XML is the right choice

Choose XML when data must go into Tally, not just come out. Creating vouchers from another system is only possible through the XML interface.

XML also suits any system that can send HTTP requests, which makes it the usual choice for custom integrations.

Writing data into Tally changes your accounts. Test every import on a copy of the company before running it on live books.

4. How to enable ODBC

In TallyPrime, open Exchange and then Data Synchronization (older Tally ERP 9 versions use Gateway of Tally, then F12, then Advanced Configuration). Set Enable ODBC to Yes and keep the default port 9000, or choose another free port in the 9000 to 9999 range.

Restart TallyPrime after changing the setting. To confirm the server is running, open Help, then About, then Client/Server and ODBC Services, which shows the active port.

Typical ODBC settings. Exact menu names can change between TallyPrime releases.
TallyPrime > Exchange > Data Synchronization
  Enable ODBC     : Yes
  Port            : 9000
  TallyPrime acts as : Server (or Both)

If port 9000 is already in use, Tally cannot start the ODBC service. Pick another port in the 9000 to 9999 range.

5. Quick decision guide

Start with ODBC if you only need to read data. Move to XML only when you have a clear need to write data back into Tally, and test it on a copy of the company first.

If you want Tally data in Google Sheets without building either integration yourself, see the TallyPrime to Google Sheets guide on the TallySync page.

Sources

Tally Solutions, pre-requisites for integrations: https://help.tallysolutions.com/pre-requisites-for-integrations/

Tally Solutions, XML integration: https://help.tallysolutions.com/xml-integration/

Tally Solutions developer documentation, data exchange: https://developer.tallysolutions.com/build/dataexchange

Frequently asked questions

Can ODBC change data in TallyPrime? No. Tally documents the ODBC interface as read-only. Use XML over HTTP if your process must write vouchers back into Tally.

Which port does ODBC use? The default is 9000. If another application already uses it, pick a free port in the 9000 to 9999 range and restart TallyPrime.

Do I need XML to build a dashboard? No. A dashboard only reads data, so ODBC is usually enough.

Automate Your Business

Ready to Eliminate Repetitive Manual Work?

Schedule a 30-minute operational discovery call. We'll audit your spreadsheets, CRM, and communication channels to build an automated architecture.