One can reference the details in $deploy/sas-bases/examples/data-access/README.md for your installation. The ODBC clients/drive need to be installed in a Persistent Volume storage.  One should typically be able to access with ssh. There must be a jump box to access this. I would prefer creating a separate folder for each ODBC driver Select a driver that could be extracted and used (tar.gz extension) rather that that needs installation (rpm) The video I referred to above and the readme file as above are helpful and the process pretty straight forward. ... View more

Hello @Jed_Klei  When you say, "If the code is run by another user, data is returned with no issue."  then this is an issue specific to you. It could possibly be due to your access, networking or the like. Difficult to pinpoint without investigation. As rightly said by @ballardw, posting a log would be helpful. However, IMHO, the appropriate approach would be to seek assistance from local IT support and the SAS Administrator at your place.   ... View more

Hello @JimmyJoeBob  I see this in the first post "ERROR: CLI error trying to establish connection: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user 'NTAUTHORITY\ANONYMOUS LOGON'." This is an expected behavior. SQL server needs credential to  allow connection. ... View more

The Content under the Content Server is stored in the Web Infrastructure Data server and the content server itself  is a part of the Web Infrastructure data server, typically PostgreSQL. WinSCP is not a tool to connect to it. While in principle one can use pgAdmin , but better avoid it. It is advisable to reach SAS Tech Support for resolving any issues. ... View more

That is something doable using a script . What is the OS? In case you want to use SAS have a look here https://support.sas.com/resources/papers/proceedings17/1136-2017.pdf https://www.lexjansen.com/pharmasug/2006/TechnicalTechniques/TT04.pdf ... View more

- Do we need to install ODBC drivers in Viya access clients mount path? Yes MSSQL odbc client driver  for 64 bit Linux would be needed (unless it is built in to Viya 4) - Do we need to open port of MSSQL database to k8s cluster nodes of sas viya? well the Viya4 environment and the SQL server should be able to connect to each other. You can contact SAS Tech Supports to get  assistance appropriate to your case. Have a look at this video https://video.sas.com/detail/video/6234732546001/sas-demo-%7C-how-to-configure-a-sas-access-interface-in-sas-viya-4 Though it is for Oracle, the concepts apply to your case. You will find answers to your questions.   ... View more

Hello @Maicfel  Did you get a chance to look here SAS Help Center: %MDSECDS Security Report Macro in particular please see if this macro can help you. %mdsecds(identitynames="sasdemo", identitytypes="Person", membertypes="Library", perms="ReadMetadata"); ... View more

Hello @John_Wick  SAS event processing has an Apache Kafka Connector. SAS Help Center: Using the Kafka Connector and Adapter. This is also another option Stream SAS Data Sets Data into Apache Kafka Topics (cdata.com) I would appreciate if you can share your success story in connecting to Kafka from SAS. ... View more

Hello @stove  if any user is running the sas-viya cli on a machine (e.g. laptop, desktop etc.)  behind the proxy/firewall, then the connection has to be allowed between the source and destination in the firewall.  This may be the case in your situation. Please make a request to your local admins to assist. ... View more

Hello @Spachai  Your question is "We got an requirement to encrypt the dataset outside SAS 9.4. ...." Well in IMHO it should not matter what approach one uses to encrypt data when it is outside SAS. When the encrypted data is to be used in SAS again, Then it should be decrypted. I recommend approaching SAS Tech Support for this issue. ... View more

Hello @shparber_m   I would recommend installing SQL Server Management Studio on you client machine (on the machine where you have SAS EG) and test if you are able to connect and see all your table. This step will validate credentials, authorizations etc., Typically, in a corporate environment resolving this type of issues is a team effort. One would need to involve the SAS Admin,  DBA,  OS Admin and Networking (for firewall) and of course desktop support (for SSMS).  ... View more

Hello @W1ndwaker  I hope you have defined a new APP Server Context (for example SAS APP2) for the new workspace server. Make sure that the library is defined in the Workspace Server Autoexec_usermod and not at the App Server level. ... View more

One option is to consider Python. Look here https://stackoverflow.com/questions/51582786/using-python-to-load-template-excel-file-insert-a-dataframe-to-specific-lines-a ... View more

Hello @ronnynch  Your question is "My question is, how do perform the update on SAS itself to reflect the new hostname and IP address? Is updating the information via hostname reference is sufficient?" In short. Well, the part of change in hostnames has to be performed manually by the SAS admin by running the deployment manager. The change in I/P has to be done by the OS Administrator - the windows administrator. Typical industry practice. As an FYI, Disaster recovery operation are a routine and in a typical   DR environment, the restored server has the same hostname as the original. The corporate DNS service takes care of hostname I/P name resolution.  In the case I/P's are hard coded in any of the config files, then the config files are updated to reflect the new I/P's. In my experience SAS servers are a part of the corporate IT infrastructure. Therefore, the corporate policies are followed.     ... View more

Hello @subhashinipala  If the earlier posts are not helpful, it's high time that SAS Tech Support should be approached. ... View more