Running SAS Stored procedure from Talend

[Anonymous]

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

[Anonymous]

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

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 🙂

[Anonymous]

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

Cheers!
Gatha