Experiment 02 Data Connect
Every ledger, sheet and table, on one bench.
Connect TallyPrime, Excel, Google Sheets, Zoho, SAP Business One, popular CRMs and SQL databases in minutes. Tatvanow reads them on a schedule you choose and keeps one clean, joined copy ready for questions.
How it works
Four steps, from raw data to a reading you can trust.
- 01
Pick a source
Choose Tally, a spreadsheet, an ERP, a CRM or a database from the connector list.
- 02
Grant read access
Install the Tally connector on the machine running Tally, sign in to cloud apps, or add a read-only database user.
- 03
Map what matters
Tatvanow detects ledgers, vouchers, items and customers, and suggests how sources join. You confirm.
- 04
Set the refresh
Every 15 minutes, hourly, nightly or on file change. Each sync is logged with row counts.
Capabilities
What Data Connect does.
Tally connector
Reads TallyPrime and Tally.ERP 9 companies, ledgers, vouchers, stock items and cost centres over a secure outbound link.
Excel and Sheets
Point to a file on OneDrive, SharePoint or Google Drive. Named ranges and tables are picked up as datasets.
ERPs and CRMs
SAP Business One, Zoho Books, Zoho CRM, HubSpot and Salesforce, plus CSV drops for anything else.
SQL databases
MySQL, PostgreSQL and Microsoft SQL Server, through a read-only user and an IP allow list.
Scheduled refresh
Incremental syncs bring in only what changed, so a 5 lakh voucher company stays current without heavy loads.
Read-only by design
Tatvanow never writes back to Tally, your ERP or your database. Credentials are encrypted at rest.
Specification
Supported sources
Available on every plan. The free plan connects one of these; Carbon connects up to 10; Gold has no limit.
- Accounting
- TallyPrime, Tally.ERP 9, Zoho Books, QuickBooks Online
- ERP
- SAP Business One, Microsoft Dynamics 365 Business Central, Odoo
- Spreadsheets
- Excel on OneDrive and SharePoint, Google Sheets, CSV upload
- CRM
- Zoho CRM, HubSpot, Salesforce
- Databases
- MySQL, PostgreSQL, Microsoft SQL Server
- Refresh options
- Every 15 min, hourly, nightly, on file change, or manual
Questions
About Data Connect
Next experimentAsk TatvaPlain English or Hinglish questions, answered with checkable numbersDoes Tally need to stay open?
The Tally connector reads from Tally when it is running. Most companies keep Tally open on a server or office PC during working hours; syncs resume automatically when Tally starts again.
Can we connect several Tally companies?
Yes. Each Tally company counts as one data source, and Tatvanow can combine them, for example group companies or separate financial years.
What if our ERP is not on the list?
Most ERPs can export to CSV or expose a SQL database. Contact us with your ERP name and we will tell you the cleanest route.
Final reading
Every number your business needs is already in your data. Pour in one source and ask.
Your question is saved to your new workspace and answered as soon as your first source finishes syncing. Prefer a walkthrough? Contact us.