Connect sas program

Question

Hi ,

1. Is ADF to SAS connection feasible and How it can be achieved?
2. Can we directly call the SAS and trigger the program or should this be done through a script?

Kind Regards,
Gowri Shankar

Answer 1

Hi @Gowri Shankar ,

As per the conversation with internal teams, ADF doesn't natively support SAS.com

Please refer to below resources that may be helpful. It seems to me that SAS needs to first export data to somewhere where ADF picks up data.

1. https://sasexamplecode.com/how-to-export-data-from-sas-to-microsoft-excel/
2. https://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003102694.htm

But if you have any feature request suggestion, I would recommend you to please submit your feedback in ADF user voice forum - https://feedback.azure.com/forums/270578-data-factory. All the feedback shared in this forum are monitored and reviewed by ADF engineering team.

Hope this info helps.

----------

Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi, @KranthiPakala-MSFT ,
it's been a while since your response was posted. Any update or change on your reply? We are looking for the ADF connection to on-prem SAS database.