Integrate Tally Prime to MSSQL Server Management

Question

I have my data stored in Tally Prime and I want to create a data flow on a daily basis into MSSQL Server Management. How am I supposed to do this?

Answer 1

1. Make sure you have a Tally ODBC driver installed (64 bit) - one of these should get you going:

https://help.tallysolutions.com/tally-prime/data-exchange-tally-prime/extracting-master-data-to-microsoft-excel-using-odbc-tally/

https://marketplace.visualstudio.com/items?itemName=CDATASOFTWARE.TallyODBCDriver

https://www.youtube.com/watch?v=WnToFwbdSGo

1. Create an SSIS Package and add an ODBC connection to the Tally Prime data
2. Create an ODBC or OLE-DB connection to your SQL Server database
3. Add an Execute SQL task if you need to truncate your SQL Server data before loading the Tally Prime data again
4. Add a data flow task, and a source to your Tally ODBC connection, and a destination to your SQL Server connection
5. Configure whatever transformation needs to happen between them. (A derived column transform might help)
6. Add a destination based on your SQL Server connection
7. Test run the package
8. Deploy the package to SQL Server and configure a SQL Server Agent job to run it as often as required.

Answer 2

Hi @Param Mehta,

You may use ODBC driver to connect to Tally Prime in SSIS package, then load the data to sql server.

See https://help.tallysolutions.com/developer-reference/integration-capabilities/using-odbc-interface/

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.