Data Importing from Tally ERP Prime

Question

Hi,

I have my data secured in Tally Prime and I wish to integrate that data in MSSQL Server Management on daily basis. How am I supposed to do this?

Answer 1

Hi @Sunil Bahadur

Use Tally Prime ODBC/XML + SQL Server (SSIS or scheduled script).

• Tally Prime exposes data via its built-in ODBC/XML interface.
• You connect to that interface from Microsoft SQL Server (usually through SSIS).
• Pull required masters/vouchers and load them into SQL Server tables.
• Schedule it with SQL Server Agent to run daily.

Key points

• Enable ODBC Server = Yes in Tally (default port 9000).
• Tally must be open when the job runs.
• Use date/voucher filters to avoid duplicates.
• No third-party tools required.

This is the most common and reliable approach used in production for daily Tally → SQL Server integration.

Thanks,
Akhil.

Answer 2

Hi Akhil,**
**how to install in system and connect ? Can you share the process if any or any video link in which this process explain with practical manner.

Thanks and looking you attention on this.