topic Running SAS Stored procedure from Talend in Talend Studio

Running SAS Stored procedure from Talend

Anonymous — Tue, 02 Apr 2019 18:00:59 GMT

Hi Experts,

I am using Talend 6.5 Enterprise version.

There is plan to run SAS Stored procedure/ program from talend.

Similar to tOraclerow or tOracleSP for oracle, do we have any component to connect and run SAS program .

I am able to see we have input and output component for SAS, nothing else.

Any pointers will be much more useful.

thanks in advance

Cheers!

Gatha

Re: Running SAS Stored procedure from Talend

Anonymous — Tue, 02 Apr 2019 18:39:04 GMT

Hi Gatha,

For SAS, we have only tSASInput and tSASOutput components available in standard set.

https://help.talend.com/reader/MTRTyjq8c4lDtgsWVaWOAQ/49p1fgo2giMHIzB6tJu76Q

If you want to run any stored procedure, you will have to run them through java components like tJava/tJavaFles or through custom routines.

Please refer the below link from SAS forum which details out the process to run a SAS program through Java.

https://communities.sas.com/t5/SAS-Enterprise-Guide/Is-it-possible-to-run-a-SAS-program-from-JAVA/td-p/141961

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Running SAS Stored procedure from Talend

Anonymous — Tue, 02 Apr 2019 22:29:41 GMT

Hi Nikil,
Thanks for the input.
I will check this tomorrow and get back to you.

Cheers!
Gatha