DATA BASE REGISTRATION

KNIME Extensions
1

Hi
How to load ODBC data base of Tally Software in to knime
Please help,

2

Hi @sujesh, welcome to the community!

Typically you should be using a jdbc driver to connect to your database from KNIME rather than odbc, as odbc is no longer generally supported with Java 8 onwards, and therefore KNIME.

You would therefore require a suitable jdbc driver for Tally. Information on registering a jdbc driver can be found here:
https://docs.knime.com/latest/db_extension_guide/index.html

Is there a reason why you specifically wish to use odbc rather than jdbc?

1 Like
3

Thank you for the reply
Could I get steps to be followed for this

4

Hi @sujesh, first off you will have to find a suitable jdbc driver. I don’t know Tally, but if you don’t have a jdbc driver already, then hopefully a search on the internet will find you either a free or commercial driver that you can download.

Once you have that, the steps for registering the driver can be found in the link I posted earlier, but specifically have a look at the following sections:

Register your own JDBC drivers

https://docs.knime.com/latest/db_extension_guide/index.html#register_jdbc

and “Connecting to other databases”:

https://docs.knime.com/latest/db_extension_guide/index.html#connector_generic

Try those steps and please post back for further help if you get errors, or if you have specific questions.

[Edit: I just noticed that this looks to be very similar to the following question:
Tally to Knime Connection]

1 Like
5

Thanks for the detailed reply. I am not specific to odbc. I am a consultant, running a small proprietorship, accounting background. For work automation purpose I learning KNIME.

1 Like