Alternatives to connect to Microsoft Fabric from SAS Viya Marketplace

[fnajera]

Hi team,

We're trying to connect to Microsoft Fabric from SAS Viya Marketplace. According to the previous post https://communities.sas.com/t5/SAS-Viya-on-Microsoft-Azure/How-to-configure-ODBC-JDBC-in-Viya-Market.... We have found that neither JDBC nor ODBC work as expected, since when you put the drivers in the right folders, these are not being mounted in the pods of compute and CAS, so they cannot be used, which complicates a lot the access to datasources.

For that reason, for denodo we used python using the Jupyter notebook that comes with the Viya platform and we could do this because there is a python package called  "denodo-sqlalchemy" which enable us to do the connection without the ODBC driver.

The problem with the connection to Microsoft Fabric is that the only alternatives we have is to use ODBC, which is not possible neither using the default methods provided in Viya Marketplace or using pyodbc, and this last one is because pyodbc requires unix-odbc, and a method to install the driver, and this is not possible in the pod/container used by SAS to run python processes.

What alternatives do we have?

Will the ODBC/JDBC method be corrected?Is there a likely date? https://documentation.sas.com/doc/en/viyaakscdc/v_001/viyaakstasks/n0bcz7tzqtr9lfn1karz9lo4dema.htm 

Will be possible to use pyodbc?

Please share with us alternatives, if the platform is not able to access datasources via odbc, then we're very limited.

Let me know if you need further info 

Thank you.

Fer.