topic Re: SAS Viya Marketplace - Private links - Integration with third-party databases in SAS Viya (Pay-As-You-Go)

SAS Viya Marketplace - Private links - Integration with third-party databases

fnajera — Mon, 17 Jun 2024 20:03:36 GMT

Hi team,

We're trying to connect to Denodo using Viya Marketplace. However Denodo is on a different suscription. To accomplish this task, we try to create a private link connection. However due the managed node groups have a deny for all principals, we're facing the following error, when we try to create the private endpoint in SAS Viya Resource group. How is the best way to communicate with other databases in sas viya marketplace? How you recommend to face this kind of network issues?

This is the network architecture we're trying to do.

Please let us know if you need further information.

Thank you.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

fnajera — Wed, 19 Jun 2024 17:15:11 GMT

Any update about this question? We're stuck because we cannot communicate with Denodo, please your advise.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

Conor_H — Sat, 22 Jun 2024 12:26:26 GMT

Thank you for bringing the issue with the private link connection to our attention. We understand the importance of seamless integration with third-party databases, such as Denodo, especially when they are hosted on different subscriptions. We are conducting a review of the managed node group’s configuration to ensure that the necessary permissions are in place for creating private endpoints within the SAS Viya Resource group. I will provide an update when that review is complete.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

fnajera — Mon, 24 Jun 2024 19:30:48 GMT

Thank you so much Connor. We're looking forward to knowing the results of the review, so we can complete the private link configuration and the SAS ODBC integration with Denodo.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

Conor_H — Wed, 03 Jul 2024 18:41:30 GMT

The Microsoft.Network/virtualNetworks/subnets/join/action permission has been added to the allowed customer actions for the managed resource group. Please let me know if you are able to make the cross-subscription connection.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

fnajera — Wed, 03 Jul 2024 22:38:12 GMT

Thank you so much Conor, we'll be doing the test again tomorrow. I'll let you know the results.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

fnajera — Wed, 10 Jul 2024 07:05:16 GMT

Hi Conor, thank you so much. We've been able to communicate to Denodo using a private link. However, now we're having issues with the ODBC connection, we've created a new post. Could you please give us a hand?

https://communities.sas.com/t5/SAS-Viya-on-Microsoft-Azure/How-to-configure-ODBC-JDBC-in-Viya-Marketplace/m-p/935266#M249

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

Conor_H — Fri, 12 Jul 2024 12:31:31 GMT

Thank you for providing an update. I am glad that you were able to resolve the private link issue. I will take a look at the ODBC connection configuration.

Re: SAS Viya Marketplace - Private links - Integration with third-party databases

fnajera — Fri, 12 Jul 2024 15:13:58 GMT

Thank you Conor. I really appreciate it