SAS Support Communities

eirigoyen · ‎01-22-2020

We are trying to connect to Athena where users can dynamically change their connection parameters based on their needs. We can connect when we specify all the required parameters in the odbc.ini file (see 1 below). The UID and PWD parameters are being passed via the libname statement inside EG (See 2 below). -------- 1 ------ ODBC.INI [Simba_Athena] Driver=/opt/simba/athenaodbc/lib/64/libathenaodbc_sb64.so AwsRegion=us-east-1 S3OutputLocation=s3://shared-bucket1-us-east-1/user/ AuthenticationType=IAM Credentials #UID=xxxxxxxx #PWD=*xxxxxxx SessionToken=xxxxxxx ------------------------------------------------ -------- 2 ------ libname atena3 odbc dsn=Simba_Athena schema=xyz001_tst UID=xxxxxxx PWD=xxxxx readbuff= 10000; ------------------------------------------------ We need to make this more dynamic and have the S3OutputLocation and SessionToken variables available in the libname statement as we can't change the odbc.ini file every day. We are using: 1) ODBC Driver Manager: unixODBC2.3.6 2) SimbaAthenaODBC-64bit.x86_64 1.0.5-1 We read this post; however, we do not use a proxy server. We read a couple posts about successful connections but need more detail. @JBailey Any help is appreciated (you responded to the post noted above about successful connection)!

eirigoyen · ‎01-14-2019

Greetings, I have noticed that in our SASWork directory there are multiple files that have a very interesting naming convention, they don't seem to be removed when we run our clean up utility. I hope somebody can help me understand what these are. Can we just remove them? Here is a couple of examples of the files: -rw-rw-r-- 1 abc123 games 9371648 Dec 6 14:51 qeXXXXx5Akvo -rw-rw-r-- 1 def456 games 10747904 Jan 8 09:57 qeXXXXOfgxa9 Thank you, Enzo.

eirigoyen · ‎09-18-2018

Greetings, Does SAS stores metrics regarding programs, projects, anywhere? log files, postgre database(s)? We need to get to some specific metrics about programs(.sas7bdat) and projects (.egp) what kind of data sources it uses (databases), who is the owner, who run it last time, when was the program last saved, when was the program last run, what are the output datasets. We currently are running SAS 9.4M5 in a multi server installation on Unix. We are working on enabling the Report Center in Environment Manager, but we are still not quite there yet. Any information is appreciated. Thank you, Enzo

eirigoyen · ‎08-17-2018

@JuanS_OCS and @nhvdwalt, thank you for your replies! We are told that Alation will need to get access to our Metadata. At this time we are scheduled to have a meeting with our business partners to go over in more detail as to what is really needed from SAS. Below is all the documentation from Alation regarding how to connect to SAS. As you can see there is not much detail, i will post next week after we have had our meeting, hopefully we will have more details. ++++++++++++++++++++++++++++++ SAS Configuring SAS in Alation To configure SAS in Alation, you will need the following information: Hostname or IP address of your server Port number Service account with privileges listed below Supported Versions Contact Alation. Preliminaries Firewall Configuration: Open outbound TCP port 8591 to SAS Workspace server. SAS Workspace Server should be installed on your SAS server and Alation should be able to connect to the SAS Workspace Server. Create Service Account You'll need to create an account on the SAS Workspace Server that supports host Authentication. Instructions on defining host authenticated users can be found here http://support.sas.com/rnd/itech/doc9/admin_oma/security/auth/security_impauthhost.html Metadata Extraction You'll need to allocate the following libraries to the SAS WorkSpace Server using the SAS Management Console. Instructions on allocation can be found here http://support.sas.com/documentation/cdl/en/emxndg/67980/HTML/default/viewer.htm#p15m68fofeq4imn1jmsgmg8xp7xp.htm Table Profiles Same as Metadata Extraction. QLI Setup Not Supported

eirigoyen · ‎08-16-2018

Greetings, We have been asked to configure our SAS environment to interact with Alation. I am new Admin and still learning the ropes. We are currently running SAS 9.4M5 on a Unix environment. Has anybody done this before? Any information is greatly appreciated. Regards. Enzo.

eirigoyen · ‎06-21-2018

@JuanS_OCS I will look into this.. Thank you very much!

eirigoyen · ‎06-21-2018

Hi, Some background info, SAS has been installed in our company for many years and we recently upgraded to M5 a few months ago, all is working as expected. Our security group is undertaking a project to make all users passwords more complex to increase security. I was wondering if SAS had a limit on the length for passwords that can be set. When users create a connection from EG, Forecast server, EM, etc. they utilize their corporate userid and password. So I think that would be metadata and we have active directory users, we have SAS 9.4M5 installed on Linux machines.

eirigoyen · ‎06-21-2018

Hi, I am new to the SAS Admin world and I would like to know if there is a limit on the length of the password users can set for their connection profile to the SASApp server. Any help is welcome.

eirigoyen · ‎01-19-2018

Hi @JuanS_OCS, Thank you very much for your reply, I am a fairly new SAS Admin and I am learning as I go :-). We are running on Linux RHEL 6.7. I will post the results after our hot fix patch. Cheers.

eirigoyen · ‎01-18-2018

HI, I know this topic is a couple of months old, but we have been experiencing the same issue since December 6, intermittently, and we are getting around by restarting the ObjectSpawner in our compute machines, 4 in a grid environment. Is there a known root cause for this behavior to occur? We contacted SAS tech support and we were told that we need to install 2 hot fixes (N22016 and N27004) we are running SAS 9.4 M1. We are scheduled to apply the hot fixes this weekend, and we hope this will correct the issue with the spawner. Thank you.

Online Status	Offline
Date Last Visited	‎02-06-2020 01:59 PM

SAS Support Communities

Connect SAS to AWS Athena via ODBC

SASWork - unknow files

How do we find Programs and jobs metrics?

Re: How to configure SAS to work with Alation

How to configure SAS to work with Alation

Re: Limit on length for users passwords.

Re: Limit on length for users passwords.

Limit on length for users passwords.

Re: Unable to connect to workspace server

Re: Unable to connect to workspace server

Re: SASWork - unknow files

Re: SASWork - unknow files

Re: Limit on length for users passwords.

Re: Unable to connect to workspace server

How to configure SAS to work with Alation

Limit on length for users passwords.

Re: Limit on length for users passwords.

Re: Limit on length for users passwords.

Re: Unable to connect to workspace server

Connect SAS to AWS Athena via ODBC

SASWork - unknow files

How do we find Programs and jobs metrics?

Re: How to configure SAS to work with Alation

How to configure SAS to work with Alation

Re: Limit on length for users passwords.

Re: Limit on length for users passwords.

Limit on length for users passwords.

Re: Unable to connect to workspace server

Re: Unable to connect to workspace server

SAS Global Forum 2018

Follow Us

What is...