topic Re: SAS hosted on cloud connectivity with on prem data sources in Administration and Deployment

SAS hosted on cloud connectivity with on prem data sources

vorkady — Fri, 05 Apr 2024 14:30:40 GMT

Power BI hosted on cloud has power BI gateway to establish connectivity with the on prem data sources. Is it possible to leverage power BI gateway to connect Viya 4.0 to on prem data sources. Please advise if SAS has any other API to establish on prem data sources.

Re: SAS hosted on cloud connectivity with on prem data sources

Patrick — Fri, 05 Apr 2024 14:47:33 GMT

Feels like you are looking for SAS Cloud Data Exchange.

Here the SAS docu: Cloud Data Exchange for the SAS® Viya® Platform

Here a recent SAS Communities article: SAS Cloud Data Exchange for the SAS Viya Platform

Re: SAS hosted on cloud connectivity with on prem data sources

ballardw — Fri, 05 Apr 2024 14:41:53 GMT

You may need to be a bit more detailed about what you mean for "connectivity". SAS/Share and SAS/Connect are two ways for SAS use of data. But if you mean use by non-SAS access to the on premises data you need to describe it a bit more.

Note: Since there are so many data systems with odd names you should spell out a word like premises because I found most uses of "PREM" to mean "premiere" as in a soccer league or political office.

Re: SAS hosted on cloud connectivity with on prem data sources

vorkady — Fri, 05 Apr 2024 14:53:27 GMT

Hi
Requirement is to connect SAS VIYA 4.0 hosted on cloud to connect on premises data sources , no direct connectivity allowed for security reasons, but connection NEED TO comply with network layer 7 termination. Can I assume SAS Cloud Data Exchange is similar to Power BI gateway which comply with layer 7 termination.

Re: SAS hosted on cloud connectivity with on prem data sources

Patrick — Fri, 05 Apr 2024 15:12:58 GMT

@vorkady wrote:
Hi
Requirement is to connect SAS VIYA 4.0 hosted on cloud to connect on premises data sources , no direct connectivity allowed for security reasons, but connection NEED TO comply with network layer 7 termination. Can I assume SAS Cloud Data Exchange is similar to Power BI gateway which comply with layer 7 termination.

Given this is an official SAS product I'd say you can assume that it will comply with the usual security requirements. https://documentation.sas.com/doc/en/pgmsascdc/v_049/dataagentag/p0h72wof7so3rhn0zci6j3o1168h.htm

To get further security details confirmed is something your architecture needs to ask SAS directly as part of contract negotiation and/or prep for install & config of the agent.

Re: SAS hosted on cloud connectivity with on prem data sources

SASKiwi — Sat, 06 Apr 2024 21:31:43 GMT

This library article describes how this works: https://communities.sas.com/t5/SAS-Communities-Library/Connecting-SAS-Viya-in-the-Cloud-to-on-Premises-Data-Sources/ta-p/922576