topic Re: SAS Drivers missing from Talend Studio 7.3 in Talend Studio

SAS Drivers missing from Talend Studio 7.3

PRai — Sat, 16 Nov 2024 00:15:50 GMT

Hello everyone,

Could not test a Metadata SAS connection due to missing drivers (sas.core.jar is mapped to an incorrect file hence not listed below). Download and install is not available and hence went to Maven URI to check but the jar files are missing from there as well (contains only the .pom file).

Can someone please let me know how or where to find the drivers to make this work.

Maven URI

Thanks,

Re: SAS Drivers missing from Talend Studio 7.3

aksharma — Wed, 14 Apr 2021 05:19:33 GMT

I am not an expert but last time when I faced this issue it was related to network .it used to disable the download option.

Could you check if you are able to download any of the other dependencies unrelated with SAS ?

Best Regards

Ashish

Re: SAS Drivers missing from Talend Studio 7.3

PRai — Wed, 14 Apr 2021 05:29:55 GMT

yes, I am able to install other drivers

Re: SAS Drivers missing from Talend Studio 7.3

Anonymous — Wed, 14 Apr 2021 07:07:05 GMT

Hello,

What's SAS Db version are you using?

Are you able to set up all the 3 jars?

sas.core.jar

sas.security.sspi.jar

sas.svc.connection.jar

Do component "tSASinput" and "tSASOutput" have connection issue? Could you connect SAS by these components?

Best regards

Sabrina

Re: SAS Drivers missing from Talend Studio 7.3

Anonymous — Wed, 14 Apr 2021 07:15:15 GMT

Hello,

What's SAS Db version are you using?

Are you able to set up all the 3 jars?

cf:

sas.core.jar

sas.security.sspi.jar

sas.svc.connection.jar

Do component "tSASinput" and "tSASOutput" have connection issue? Could you connect SAS by these components?

Best regards

Sabrina

Re: SAS Drivers missing from Talend Studio 7.3

PRai — Wed, 14 Apr 2021 08:11:54 GMT

Thanks for your reply!

I am using SAS version 9.4

No I have not installed the SAS drivers yet since I cannot find them, I am asking the community to let me know the correct method or location to download from.

Since "tSASinput" and "tSASOutput" are no longer supported in the Talend v7.3 onwards I was not able to test them, I am trying the SAS connection through Metadata connection like below

Regards,

Re: SAS Drivers missing from Talend Studio 7.3

Anonymous — Thu, 15 Apr 2021 06:07:24 GMT

Hello,

Is it possible to download sas jar file from

https://support.sas.com/downloads/

and install required jar files into studio by module?

Here is online documentation about: TalendHelpCenter: Installing external modules manually using the Modules view

Best regards

Sabrina

Re: SAS Drivers missing from Talend Studio 7.3

PRai — Mon, 19 Apr 2021 09:08:26 GMT

Thanks for the information, I was able to download and find the missing drivers. But it did not solve the issue I am getting the below error

Can you suggest what could have caused this issue, is it possible that some class definitions are missing from the drivers?

Re: SAS Drivers missing from Talend Studio 7.3

Anonymous — Mon, 19 Apr 2021 11:35:39 GMT

Hello,

Looks like still a missing jar issue. The problem with some versions Java, not having CORBA available.

What's JDK version are you using?

Best regards

Sabrina

Re: SAS Drivers missing from Talend Studio 7.3

PRai — Tue, 20 Apr 2021 01:45:01 GMT

Hi Sabrina,

Thanks for the suggestion, I am using the jre "1.8.0_281 java version 8.

Re: SAS Drivers missing from Talend Studio 7.3

Anonymous — Tue, 20 Apr 2021 03:49:08 GMT

Hello,

Ensure proper version of JDK is installed. For v6 of Talend products JDKv1.8 is required instead of JRE.

The JDK is the Java Development Kit. The JRE is the Java Runtime Environment. You actually get a JRE when you download the JDK. You cannot develop and compile with the JRE, you can only run your precompiled code. As such you need the JDK for your Studio. It is a good idea to ONLY install the JDK across all of your environments as it comes with the JRE anyway.

Let us know if it helps.

Best regards

Sabrina

Re: SAS Drivers missing from Talend Studio 7.3

gjeremy1617088143 — Tue, 20 Apr 2021 07:20:13 GMT

Hi, the last error message seem to warn you you don't have good parameters for the connection , maybe wrong login or password.

Send me Love and Kudos

Re: SAS Drivers missing from Talend Studio 7.3

PRai — Tue, 20 Apr 2021 23:55:39 GMT

Thank you so much Sabrina, that helped.

I updated the JDK to version 15 from 8 and it started working. It seems Java 8 is missing the necessary CORBA files.

Re: SAS Drivers missing from Talend Studio 7.3

Anonymous — Wed, 21 Apr 2021 04:02:45 GMT

Hello,

Here comes one question. Java 15 is not list in the compatible java environments table.

Please refer to this online documentation about: TalendHelpCenter: Compatible Java Environments

Is JDK 11 OK with you?

In the documentation we provide a list of java environments that are supported, in the sense that we do provide an SLA and technical support for them. This doesn't mean other (non-listed) java environments will not work but simply we won't necessarily be equipped to help you with any issue you may face with them.

Best regards

Sabrina