Hey team.
We're considering to deploy SAS Viya Pay-as-you-go, but we have doubts about if it's possible to configure the integration with Cloudera and Microsoft Fabric.
In the official documentation from the product, we see only Azure SQL, JDBC and Oracle, but there's nothing about Cloudera and Fabric.
SAS Help Center: Access Data Sources,
Regarding Cloudera/Impala, this is a ODBC connection, has this been tested? In Viya 4 full deployment, this is completely feasible, but we're not sure in Viya PAYG. We have had issues previously with Denodo.
In the Viya full documentation we see that Fabric now it's supported with SQL Server connector. Is this also applicable to Viya PAYG? I think the limitation of using SSO could be an issue, but I prefer to validate this with you. Additionally, that it seems that it's only possible to access Fabric Warehouses, or does this access also provide access to Lakehouse with SQL endpoint?
SAS Help Center: Working with Microsoft Fabric Data Warehouse and Microsoft Fabric Lakehouse
Thank you.
Fer.
