Linux DSN Configuration - ODBC Driver for Azure Synapse Analytics

Linux DSN Configuration

After the linux (DEB or RPM) driver is installed, a DSN with the name DEVART_AZURESYNAPSEANALYTICS is created. You can use it to test the connection with the AZURESYNAPSEANALYTICS server. For this, perform the following steps:

1. Open the odbc.ini file located in the /etc folder. Find the DEVART_AZURESYNAPSEANALYTICS section and specify the required connection settings:

   
   
   User ID=<your AzureSynapseAnalytics User Name>
   Password=<your AzureSynapseAnalytics password>
   Server=<your AzureSynapseAnalytics server address>
   Port=<your AzureSynapseAnalytics Port>
   Database=<your AzureSynapseAnalytics database name>
   

2. Run the UnixODBC Test Command utility and test a connection using the following command:

   isql -v DEVART_AZURESYNAPSEANALYTICS 

   

See Also

Connection Options