How to connect Qlikview to Tally ERP

[#1]

Hi everybody,

I wish to connect my Qlikview Personal edition with the Database of Tally ERP 9.0

I have no info on which database does Tally use. I need your assistance in the same.

[sushil353 · Accepted solution]

Hi,

Use following steps,

1. Install tally on qlikview server.

2. Start tally and load any company.

3. Now in Qlikview under connect, you will see something TallyODBC_9000. Take the first one.

4. Put username and password. Check Connection established.

5. Now press Select button and you will see all the tally tables and its fields.

Check out this:

http://www.tallysolutions.com/website/CHM/TallyERP9/Data_Management/outward_connectivity_from_tally....

HTH

Sushil

[#3]

How this will work, in case tally & qlikview installed on the different server ???

Please help !!!

[Anonymous]

Sushil,

I have tried your mentioned steps, but when I press Select button, I am not getting any Tables and their fields.

Could you suggest me why?

Regards,

Balraj

[palwast]

To connect QlikView with Tally ERP 9.0, you can use the ODBC or OLE DB drivers for database integration. Tally primarily uses its proprietary Tally ODBC driver, which allows you to fetch data for analysis in QlikView. Ensure that Tally's ODBC feature is enabled and set up the connection string correctly in QlikView. If you're exploring robust invoicing and reporting solutions, Sleek Bill offers seamless integration options for businesses. Check it out! https://sleekbill.in