Connection to Oracle Cloud

[jhuebler]

Hi, I'm trying to create a connection to a database within Oracle Cloud. I work with Talend Studio Version 8.

The only Oracle Connection component that sounded promising asked for a tns file.
I used the tnsnames.ora file within the wallet.zip I got from our database administrators. The component in Talend Studio managed to autofill all the connection parameters. Once I start the job, I receive the error message:

java.sql.SQLRecoverableException: IO Error: Connection reset, Authentication lapse 0 ms.

What do I need to do to get access to the Oracle Cloud Database?

I hope you can help me.

Thanks - Jan

[Lusemar_Oliveira]

Hi jhuebler,

If you are using an older Studio version < R2023-08, you may want to upgrade your Studio to a newer version.

A Studio fix for this issue was released in august of 2023.

https://help.qlik.com/talend/en-US/patch-notes/8.0/r2023-09#:~:text=New%20features%20in%20R2023%2D08

I hope it helps.

Good Luck!