Hybrid Data Pipeline supports Kerberos authentication when connecting to SQL Server. This authentication method provides enhanced security by using Kerberos tickets instead of username and password credentials.
Note: Kerberos authentication does not work in FIPS enabled environments.

Configuring the data source

To configure a SQL Server data source with Kerberos authentication:
  • Specify values for minimum required parameters for establishing a connection.
    • Set the ServerName parameter to specify either the IP address in IPv4 or IPv6 format, or the name for your server.
    • Set the PortNumber parameter to specify the TCP port of the primary database server that is listening for connections to the database.
  • Set the AuthenticationMethod parameter to Kerberos to enable Kerberos authentication.
  • Set the DatabaseName parameter to name of the database to which you want to connect.
  • Set the KerberosPrincipal parameter to specify the unique identity within a Kerberos realm, representing either a user or a service.
  • Set the KerberosPassword parameter to specify the authentication secret used to verify the identity of the principal within the Kerberos system.
  • Optionally, set the LoginConfigName parameter to specify the name of the entry in the JAAS (Java Authentication and Authorization Service) login configuration file that contains the authentication technology used by the driver to establish a Kerberos connection.