BookmarkSubscribeRSS Feed
RupaJ
Lapis Lazuli | Level 10

Hello,

 

Our users connect to Teradata database from SAS (basically using libnames). Recently the Teradata admin enabled encryption (at TD gateway to be precise) and since then our users were not able to run their libname statements from SASEG anymore. When they execute, the code would be "running" state forever. The program would not even stop (when we tried stopping). It was like SASEG was hung from code per say. So immediately we disabled the encryption after realizing that was the one causing issues and then the libnames worked fine. So question is how to modify the SAS code to go against the encrypted database traffic.

 

Thanks 

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

There was a question many years back on this:

https://communities.sas.com/t5/General-SAS-Programming/Reading-from-an-encrypted-database/td-p/17212...

 

Basically from my understanding, you pass your details over to the database, and that should then feedback plain data.  The database can't send over encrypted data as SAS would then need to implement in the driver a de-encryption for the specific encryption you have used. 

 

So the database should send plain data based on the access rights given in the connection.  If the database encrypts things, then it is up to the database to de-crypt them too.  

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 857 views
  • 0 likes
  • 2 in conversation