I don't use CyberArk (never heard of it) but a quick perusal says they have a REST API (CyberArk AIM) to retrieve the temp password. Use PROC HTTP to access the REST API, get the creds, pass it as macro to the SQL Server connection. Suggested approach.
First of all, I recommend that you post different questions as a separate post, instead of including it under an already-answered one. A lot of people just look for unanswered questions, and this one appears to be answered.
In terms of your CyberArk question, I recommend that you put in a track with SAS technical support. My experiences with them have been really good, and they've got the technical people who can work with you to figure this out (or, sadly, to conclude that it can't work out. I didn't find any statement that SAS is compliant with CyberArk, or vice-versa.)
Also, if they need to get into a discussion with CyberArk to improve interoperation, that's the level where it should be done.
Check with your SAS administrator whether you should submit the track yourself, or if someone else in your organization manages this.
Tom
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.