topic Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure? in SAS Viya on Microsoft Azure

How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure?

camilovalencia — Thu, 21 Dec 2023 00:01:45 GMT

Hi, I would like to connnect to Azure Synapse Analytics from SAS Viya, does someone know how to install the odbc driver from the jumpbox? Is there an oracle example within the documentation, is there a similar document for synapse?

https://go.documentation.sas.com/doc/en/viyaakscdc/v_001/viyaakstasks/n11m9y4kpdy27en1pcxfozuxvad3.htm

Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure?

shekhar_chavan — Thu, 21 Dec 2023 05:17:01 GMT

Please check below document for the Viya Azure Marketplace place, the document which you are referring is for full Viya license which is not applicable for 'Viya Azure Marketplace'

SAS Viya on Microsoft Azure: Configuration Tasks

pg#17 has example for Oracle connectivity example.

Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure?

camilovalencia — Thu, 21 Dec 2023 16:46:16 GMT

Thanks for your answer, where can i find especific documentation about sqlserver ODBC install?

Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure?

SASKiwi — Fri, 22 Dec 2023 00:00:39 GMT

My understanding is that Viya comes with all common database connectors already installed, including SQL Server (SAS/ACCESS Interface to SQL Server).

Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure?

camilovalencia — Thu, 04 Jan 2024 20:21:28 GMT

In the Pay as you go it is not installed, it presents the error:

Ha fallado la conexión al controlador de la fuente de datos. ERROR: [DataDirect][ODBC lib] Driver Manager Message file not found. Please check for the value of InstallDir in your odbc.ini. Function failed. La acción se ha detenido debido a los errores. uri: /casManagement/servers/cas-shared-default/caslibs/Synapse/tables path: /SASDataExplorer/ui/datasources/validation traceId: ecc75d538f04a219

Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure?

SASKiwi — Thu, 04 Jan 2024 23:34:46 GMT

I suggest you open a Tech Support track for this issue. There are very few Community users familiar with Viya on Azure Marketplace.

Correction: Here is a description of the support for Viya on Azure Marketplace :https://communities.sas.com/t5/SAS-Viya-on-Microsoft-Azure/How-to-get-support-for-SAS-Viya-on-the-Microsoft-Azure/td-p/834841

Using Tech Support tracks isn't available.