topic Re: How to create a Athena Db connection in Talend Studio

How to create a Athena Db connection

JMartin1 — Fri, 15 Nov 2024 22:27:45 GMT

Hi! I have to create a Db connection to extract information from Athena, What is the best way to create de Db connection?

I have the user id and the password that allow the access.

Thanks!

Re: How to create a Athena Db connection

Anonymous — Fri, 14 Oct 2022 04:49:57 GMT

Hello,

Please follow up this online documentation about: TalendHelpCenter: Using the JDBC connector to connect to Amazon Athena and feel free to let us know if you can connect to AWS Athena and run queries.

Best regards

Sabrina

Re: How to create a Athena Db connection

JMartin1 — Fri, 14 Oct 2022 09:29:58 GMT

Thanks!!

I have already been given the user and the secret key to access Athena, I have created my JDBC URL and I have added the driver and the information about my DDBB (Oracle) but it is giving me the following error when I do the connection test and I do not know why it can be given.

Thanks!

Re: How to create a Athena Db connection

Anonymous — Mon, 17 Oct 2022 04:10:15 GMT

Hello,

It looks like java keeps complaining it can't find a properties file that is right there.

What JDK version are you using and on which talend build version you got this issue? We suspect that there might be incompatibility issue between your AthenaJDBC jar and studio.

Best regards

Sabrina

Re: How to create a Athena Db connection

JMartin1 — Mon, 17 Oct 2022 10:51:54 GMT

Hi Sabrina,

Maybe that´s the problem, I just use 7.3 and the JDK is 1.8.0_202.

even if I will have to upload it to the cloud later.

best regards

Re: How to create a Athena Db connection

Anonymous — Tue, 18 Oct 2022 05:04:05 GMT

Hello,

Please try to go to the Using Athena with the JDBC Driver page on the Amazon website and download the latest Athena JAR file that is compatible with your JDK 1.8.

Try to point the tJDBCConnection to use this JAR, and see if you are be able to connect to your Athena(S3).

Note: the AthenaJDBC42-2.0.5.jar is compatible with JDBC 4.2 and requires JDK 8.0 or later. (Source).

Best regards

Sabrina

Re: How to create a Athena Db connection

JMartin1 — Thu, 20 Oct 2022 11:04:17 GMT

Hi, I get access and connect to Athena.

Now, when I try to get the retrieve schema to get all tables from the schema, didn´t deploy the table list.

ups.

Re: How to create a Athena Db connection

Anonymous — Fri, 21 Oct 2022 03:49:16 GMT

Hello,

The connected Amazon Athena service is OK with you? No permission and privilege issue from your side?

Are you able to read data from the Amazon Athena service by setting a job to connect to Amazon Athena? tDBInput-->tLogRow?

Best regards

Sabrina

Re: How to create a Athena Db connection

JMartin1 — Fri, 21 Oct 2022 07:33:24 GMT

Hi Sabrina,

I managed to create the connection with the user and secret key that they gave me, at the time of making the retrieve schema I did not deploy anything when I opened the corresponding schema, except at one time of the day that if I achieved it and I managed to create the schema of several tables to test, I made the Job that you indicate and it gave me error.

now I was trying to open one of the tables with the Data Viewer and I get the following error, I think I could not have updated something related to Log4j, because in the execution of the Job puts something related.

the job error

best regards

Re: How to create a Athena Db connection

Anonymous — Fri, 21 Oct 2022 08:03:02 GMT

Hello,

Are you using talend subscription V 7.3.1? Is it possible to create a Support Case in Salesforce in this way we could give you a remote assistance through support cycle with priority?

Best regards

Sabrina

Re: How to create a Athena Db connection

JMartin1 — Fri, 21 Oct 2022 08:08:38 GMT

Hello!

Yes is the 7.3.1 v