SAS hosted on cloud connectivity with on prem data sources

[vorkady]

Hi

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.

[Patrick]

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

[ballardw]

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.

[vorkady]

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.

[Patrick]

---

@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.

[SASKiwi]

This library article describes how this works: https://communities.sas.com/t5/SAS-Communities-Library/Connecting-SAS-Viya-in-the-Cloud-to-on-Premis...