Tally data integration with sql server

XML Generation: It will not be a Real time Data export as you need manual interventions for someone to create those XML file from Tally 9 UI and place it for you.

 

ODBC: ODBC options look great but AFIK, you need to understand bit TDL language of Tally to get the required data.

 

Apart from the above two options I would suggest you to choose with Tally XML Interface (Kind of SOAP web service) which will give you real time data.

 

For more follow this link,

 

http://mirror1.tallysolutions.com/Downloads/TDL%20Developer/Tally.ERP%209%20-

%20Integration%20Capabilities.pdf