Driver
. Enter a path to the driver.
An example of the path is as follows:
/data/Informatica/10.1.1/ODBC7.1/lib/DWsqls27.so
.
Description
. Enter the description of the DSN entry.
An example of the description is as follows:
Azure SQL DATABASE Connection for ODL
Address
. Enter the host name of the machine where the database server is installed.
LogonID
. Enter name for the Microsoft Azure SQL Database user.
Password
. Enter a password for the Microsoft Azure SQL Database user.
QuotedId
. Select
No
.
AnsiNPW
. Select
Yes
.
EncryptionMethod
. Enter a numerical value that corresponds to the encryption method that you want to select.
Enter
WorkArounds2=2
.
Enabling the WorkArounds2=2 option causes the driver to ignore the column size or decimal digits specified by the application and use the database defaults instead. Some applications incorrectly specify the column size or decimal digits when binding timestamp parameters.
If the
$ODBINI
environment variable pointing to the
odbc.ini
file was not configured, then configure the
$ODBINI
environment variable as follows:
$ODBCINI=<pwc_install_path>/ODBC7.1/odbc.ini
.
ODBC environment variables are configured before installing
PowerCenter
.

Driver=<PwC_Install_Loc>/ODBC7.1/lib/DWsqls27.so
Description=Azure SQL DATABASE Connection for ODL
Address=<server_name>
Database= <db_name>
LogonID=<usn>
Password=<pwd>
QuotedId=No
AnsiNPW=Yes
EncryptionMethod=1
ValidateServerCertificate=0
WorkArounds2=2