Exasol Database Connection Not Working!

[Lord-Vader]

Hello fellow Talenders, I am trying to make a connection with Exasol database SaaS, but it doesn't work.

I contacted Exasol and they too can reproduce the issue. They found another solution via JDBC connection, but it is not optimal. First I kept getting a connection error and than I began getting an authentication error(see images). I can connect via the JDBC Connection(see images), but I can't do certain things, like I can do with the DBconnection components.

I think the issue may sit in the config of the DB Type self. I don't fully understand on how to change things, so I don't know how to change it for testing.

Talend Version: Talend Open Studio Data integration(8.0.1.2021119_1610)

Java version:

jdk-16.0.02 , jdk 17 or 19 doesn't make a difference.

Exasol JDBC: 7.1.14

Any help will be appreciated.

[Lord-Vader]

I don't know, I use the Exasol SaaS Database.

I just use the configuration that is recommended.

Can u give me an example on how your config is ? or what version of Exasol DB you have in your Talend ? can u screenshot your connection and component version ?

[Anonymous]

Here is a screenshot of my connection details for creating the metadata. You can see I have tested it and it works fine.

I've only hidden the username they gave me, which I used for setting up the metadata and is actually used for the schema they give you. Essentially, where you see a red line, it is the same value.

It is Exasol 7.1 and the free trial I was able to sign up to is available here....

https://docs.exasol.com/db/latest/get_started/trial/publicdemosystem.htm

[Lord-Vader]

Hahaha. Again I am using the Exasol SaaS, you are using the Exasol DB. There is a free trial for that too. If you don't mind testing that out you will see what I mean. I have tried the Exasol DB and yes I can make a connection, but I still can't connect to the SaaS.

https://cloud.exasol.com/signup

[jlolling]

I do not think it is an issue of the Exasol database release. On my opinion it has to do with the out-dated Exasol driver Talend use. In a JDBC connection we can use a new driver, but the driver for the native Exasol components is not easy to update.

[jlolling]

Using 2 different drivers in the same job will always cause the newer driver will be ignored.

[Lord-Vader]

Do you know how or a source that tells me how to change it or update it ?

[jlolling · Accepted solution]

Yes: Talend has provided a guid to do that: https://help.talend.com/r/en-US/8.0/studio-user-guide/overriding-external-modules-by-customizing-mvn...

Please try it and check if you find the newer driver in your job.

To do so, please build the job locally and check the folder lib for the existence of the newer driver instead the out-dated old driver. The old driver must disappear, if not it will be used - not what you want.

[Lord-Vader]

So I followed the instrcutions of the link that you gave me. It works, I can make a connection. But when I try to use the tDBInput it keeps giving me an exadriverclass not found error(see images).

In the exasol dbconnection I tried retrieving the tables, it did retrieve the tables. but when I wanna read the tables it keeps giving me the classnotfounderror: com.exasol.jdbc.exadriver.

I keep seeing things about dependency, but I dont know how to change it or update it.

 

[jlolling]

Only to be sure, the exact driver name is: com.exasol.jdbc.EXADriver

It is case sensitive!

Did you have exported the job via Build Job and can you please show us the list of jars there please.

[Lord-Vader]

ATLAST.

Ok, I changed all my exa jar files in window -> show view -> modules to the 7.1.16 , this I had before I had the exa driver error.

Now in window -> preferences -> java -> build path -> classpath variables, I added a new variable and I defined the 7.1.16 jar file path and it works.

I can now crud easily with the exa components.

Thnx all for your help.

Vader out 💪