How to create an ODBC data source to connect to the SQL Server database using ODBC - Open Database Connectivity.
To do this, you must set up a System Data Source Name (DSN):
Doc:
Example with SSL certificate turned off.
[sqlserver_azure]
Driver=/home/oracle/product/fmw/bi/modules/oracle.bi.datadirect.odbc/7.1.6/lib/ARsqls27.so
Description=Sql Server Azure
Address=server.database.windows.net
AlternateServers=
AnsiNPW=Yes
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=AdventureWorks
LoadBalancing=0
LogonID=
Password=
QuoteID=No
ReportCodePageConversionErrors=0
EncryptionMethod=1
ValidateServerCertificate=0