topic Re: Regarding Tally Access with QV in QlikView

Regarding Tally Access with QV

Anonymous — Wed, 13 Aug 2014 05:24:37 GMT

Hello All,

I need to extract Tally ERP 9 data using QV. Can some body help to overcome it?

I have already gone through the blog posting over QV community but have not got the solution.

I have installed Tally Client(32 Bit) and QV Products on the same machine.

Now can anybody help how to make a connection with Tally?

Does it required any ODBC DSN/ODBC drivers?

Need a quick response and solution from you guys...

Regards,

Balraj

Re: Regarding Tally Access with QV

tresB — Wed, 13 Aug 2014 05:27:29 GMT

Refer: Re: How to connect Qlikview to Tally ERP

Re: Regarding Tally Access with QV

Anonymous — Wed, 13 Aug 2014 05:40:38 GMT

Tresco,

Thanks for immediate response.

I have tried the 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.

But when I press select button, I am not able to see tally tables and its fields. It is blank.

Why it is after selecting a company also?

Regards,

Balraj

Re: Regarding Tally Access with QV

Anonymous — Wed, 13 Aug 2014 05:46:48 GMT

This is what I am getting.

Please see the attachment

Please help why it is?

Regards,

Balraj

Re: Regarding Tally Access with QV

tresB — Wed, 13 Aug 2014 05:49:52 GMT

Can't see your screen shot.

Re: Regarding Tally Access with QV

Anonymous — Wed, 13 Aug 2014 06:01:36 GMT

I have attached as a word doc.

Pls Chk.

Regards,

Balraj

Re: Regarding Tally Access with QV

tresB — Wed, 13 Aug 2014 06:07:03 GMT

Couple of checks:

did you test connection wtih username/pwd successfully?

under connect (drop down) did you get ODBC_9000 as the first one(in similar group)?

Re: Regarding Tally Access with QV

Anonymous — Wed, 13 Aug 2014 06:09:52 GMT

Tresco,

I am having Tally Server on different IP address.

And I have installed Tally Client and QV on same IP.

Is this fine?

Can we access Tally Server with Tally Client connection string in QV?

Regards,

Balraj

Re: Regarding Tally Access with QV

tresB — Wed, 13 Aug 2014 06:18:10 GMT

I don't have practical exp in this. See if this: Qlikview to Tally ERP data connectivity? and the tally guy there: sunil.gupta@tallysolutions.com and the pdf attached could help you.

Re: Regarding Tally Access with QV

Anonymous — Wed, 13 Aug 2014 06:19:05 GMT

Yes,

Test connection was successful.

Under connect(drop down) I selected ODBC_9000 first one.