topic Can SAS/Access interface for Snowflake support SSO connections? in SAS Data Management

Can SAS/Access interface for Snowflake support SSO connections?

jrmathieu — Fri, 28 Feb 2020 21:12:36 GMT

We have the new SAS/Access configured and able to access a test database provided by Snowflake. This access is leveraging username and password for authentication.

Our company is planning on using SSO (SAML) authentication to Snowflake but have not seen any documentation on how to configure this authentication method for a Linux environment.

Is this specific to the drivers provided by Snowflake?

Has anyone configure this type of access?

Thanks,

JOHN MATHIEU
Sr Data Engineer – SAS Administrator

Re: Can SAS/Access interface for Snowflake support SSO connections?

billjillnelson8 — Sun, 10 May 2020 18:19:35 GMT

WE have the same question.

Re: Can SAS/Access interface for Snowflake support SSO connections?

SASKiwi — Sun, 10 May 2020 20:06:32 GMT

Since there has been no response, a SAS Tech Support track for this question is a better option.

Re: Can SAS/Access interface for Snowflake support SSO connections?

jrmathieu — Mon, 11 May 2020 14:02:47 GMT

Here is the response I received from SAS TS.

It appears SAS does not provide must support it relates to the OS and third party drivers.

This is why The Hartford is planning to migrate from SAS within the next 4 years.

I received confirmation that these options should be supported as DSN options (which is expected). Unfortunately we do not have the authentication built into the engine options at this time. The CONOPTS is the best bet, but I haven't had a chance to test it for myself yet.

In general, the way I like to think about the authentication is that it is primarily handled outside of SAS. It is a method configured at the system level and SAS only needs to be pointed to it with the relevant options. So in short, so long as the authentication is working outside of SAS it should have no issues in SAS. However this also limits how much documentation we typically maintain since its not a SAS process.

Note that I have experienced issues trying to construct a defined DSN connection to our Snowflake private link using our DataDirect ODBC manager. We must leverage DataDirect since we have this ODBC manager and driver defined for SQL Server already. Only one odbc.ini file can be referenced.

Currently our connections can only be supported using DSN less connections, which it appears to the method that SAS mainly implemented for Snowflake.

With the cost of these connectors and the lack of true support, I will expect other companies will be abandoning SAS soon.

Re: Can SAS/Access interface for Snowflake support SSO connections?

pchegoor1 — Wed, 14 Apr 2021 03:16:47 GMT

Did you ever find a solution to this question? Just curious to know.

Thanks.

Re: Can SAS/Access interface for Snowflake support SSO connections?

Carus — Fri, 23 Jun 2023 11:43:52 GMT

In case anyone is browsing this later, SAS Viya supports single signon using Azure AD and OAuth:

https://go.documentation.sas.com/doc/en/pgmsascdc/v_040/acreldb/n13zmhmguddratn1kfgyzsjyz2n3.htm?fromDefault=

Re: Can SAS/Access interface for Snowflake support SSO connections?

eddieleung305 — Wed, 20 Sep 2023 08:53:50 GMT

I just want to know if any technology update regarding SAS9M7, M8 and SAS/ACCESS to Snowflake in supporting SSO to access Snowflake DB host.

Assuming Windows ID on AzureAD

Re: Can SAS/Access interface for Snowflake support SSO connections?

rhmthomson1 — Thu, 21 Sep 2023 11:53:36 GMT

We dont support SSO with Snowflake in SAS 9, only in Viya 4

Re: Can SAS/Access interface for Snowflake support SSO connections?

SASKiwi — Fri, 22 Sep 2023 04:13:00 GMT

Here's a link to the Snowflake single signon doc in Viya. The SAS 9.4 Snowflake doc does not include single signon.