topic Re: Exasol Database Connection Not Working! in Talend Studio

Exasol Database Connection Not Working!

Lord-Vader — Tue, 06 Dec 2022 09:58:05 GMT

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.

Re: Exasol Database Connection Not Working!

Anonymous — Tue, 06 Dec 2022 16:18:50 GMT

You appear to have two outcomes in your failure screenshots. A refusal and a timeout. I couldn't see the different between these two situations. Was there a difference? Also, can you create a connection with the tDBConnection component?

I am afraid I do not have an Exasol DB to try this out myself.

Re: Exasol Database Connection Not Working!

jlolling — Tue, 06 Dec 2022 22:16:02 GMT

I know this issue. In the JDBC connection you use a finger print inside the url I guess (thats what you have covered). This works with the newest driver from Exasol but unfortunately Talend ships with an older driver, which does not have this feature.

I suggest to simply remove the fingerprint and it should work.

Re: Exasol Database Connection Not Working!

jlolling — Tue, 06 Dec 2022 22:19:08 GMT

I also recommend not to use the driver file shipped or downloaded from the Exasol web side because here you do not have any version information in the file name. Better you get the file from Maven Central: https://search.maven.org/artifact/com.exasol/exasol-jdbc

Now you know exactly the version and the file is correctly named. Later on you can use a more recent driver and can distinguish between both.

Exasol is keeping the repository updated as well as their own download.

Re: Exasol Database Connection Not Working!

Lord-Vader — Thu, 08 Dec 2022 09:44:26 GMT

No I cannot make a connection via tDBconnection(exasol). Sorry I didn't explain my situation perfectly. When I tried to make a connection at first I was inserting the wrong information that was provided, as in I was putting my IP in like the docs said instead of the connection string that was given of the cluster. But then I began having this authentication error meanwhile I can successfully see my database via DBeaver, DBvisualizer, PowerBI for example. I never made a connection via de tDBconnection(exasol), only via jdbc.

tDBconnection with the exasol database does not work. I gave another example with the job for reference to see what I mean.

exasol docs : https://docs.exasol.com/saas/connect_exasol/data_integration_etl/talend.htm

Re: Exasol Database Connection Not Working!

Lord-Vader — Thu, 08 Dec 2022 09:46:42 GMT

I am not using the fingerprint, I am using just the connection string of the cluster. example: "o2grer4b3gf8bfdwuhqbdsucbgouyrg.clusters.exasol.com"

Re: Exasol Database Connection Not Working!

Lord-Vader — Thu, 08 Dec 2022 09:48:16 GMT

Ok I have changed it to the version you recommended.

Re: Exasol Database Connection Not Working!

Anonymous — Thu, 08 Dec 2022 10:47:23 GMT

Did this resolve your issue?

Re: Exasol Database Connection Not Working!

Lord-Vader — Thu, 08 Dec 2022 14:22:52 GMT

This was not an issue. I don't have an issue when connecting via the "DB Type - JDBC". The issue is that with "exasol tDBconnection" or the "DB Type - Exasol" it doesn't connect, it keeps giving me the authentication error. I also tried retrieving schema but it throws the same auth error.

If I point out the jar file path via the install new module via the "DB Type JDBC" it does work, but I don't want that. I want to use the tDBConnection Exasol. I tried erasing the old jdbc 6.0.9302 folder and restarting Talend with a new folder named exactly the same but with the new driver and new numbers etc(see image). but still it did not work. It keeps making me install the old 6.0.9302 version. It does not recognize the newer version when I put it in the folder like in the image.

But when I do retrieve schema with the "DB Type JDBC" it asks me for the 7.1.16 snapshot jar file(see image).

Folder path to jars: C:\Program Files (x86)\TOS_DI-8.0.1\studio\configuration\.m2\repository\org\talend\libraries

Hopefully this is enough info to cover what I am trying to explain. But if you need more info just let me know.

Re: Exasol Database Connection Not Working!

Anonymous — Thu, 08 Dec 2022 15:19:26 GMT

I have just signed up to the Exasol free trial to test this out and see if I can recreate this issue. Unfortunately (or fortunately) I cannot recreate this. It just works. I am using TOS v8. How might your config be different to the free trial in terms of connection configuration?

Re: Exasol Database Connection Not Working!

Lord-Vader — Thu, 08 Dec 2022 16:10:56 GMT

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 ?

Re: Exasol Database Connection Not Working!

Anonymous — Thu, 08 Dec 2022 17:26:07 GMT

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

Re: Exasol Database Connection Not Working!

Lord-Vader — Fri, 09 Dec 2022 09:47:23 GMT

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

Re: Exasol Database Connection Not Working!

jlolling — Fri, 09 Dec 2022 09:50:55 GMT

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.

Re: Exasol Database Connection Not Working!

jlolling — Fri, 09 Dec 2022 09:52:17 GMT

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

Re: Exasol Database Connection Not Working!

Lord-Vader — Fri, 09 Dec 2022 09:57:40 GMT

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

Re: Exasol Database Connection Not Working!

jlolling — Fri, 09 Dec 2022 10:03:18 GMT

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-uri

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.

Re: Exasol Database Connection Not Working!

Lord-Vader — Fri, 09 Dec 2022 13:19:26 GMT

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.

Re: Exasol Database Connection Not Working!

jlolling — Fri, 09 Dec 2022 14:45:07 GMT

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.

Re: Exasol Database Connection Not Working!

Lord-Vader — Fri, 09 Dec 2022 15:27:32 GMT

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 💪