PowerCenter
- PowerCenter H2L
- All Products
[ODBC Data Sources] DSN_SQLSERVER_KERB=SQL Server with Kerberos Authentication
Property
| Description
|
---|---|
Driver
| Required. Absolute path to the Data Direct New SQL Server ODBC driver. By default, the driver is located at
<INFA_HOME>/ODBC7.1/lib/DWsqls27.so
|
Description
| Optional. Describes the connection information.
|
HostName
| Required. Name of the machine where you installed the Microsoft SQL Server database.
|
PortNumber
| Required. Port where the Microsoft SQL Server database server listens. Default is 1433.
|
Database
| Required. Name of the Microsoft SQL Server database.
|
Authentication Method
| Required. Authentication method to access Microsoft SQL Server. To enable Kerberos authentication, specify the authentication method as 4.
|
GSSClient
| Required. Location of the Informatica Kerberos libraries.
|
Domain
| Required. Domain administrating both Microsoft SQL Server and the machine that runs the Integration Service.
|
[DSN_SQLSERVER_KERB] Driver=<Informatica installation directory>/ODBC7.1/lib/DWsqls27.so Description=SQL Server Connection with Kerberos Authentication HostName=<hostname of the machine where SQL Server is installed> PortNumber=<port no> Database=<database name> AuthenticationMethod=4 GSSClient=<Informatica installation directory>/server/bin/libgssapi_krb5.so.2 Domain=<The domain administrating both SQL Server and the machine that runs the Integration Service>