The following table summarizes connection properties which are required for user ID and password authentication.

Table 1. Authentication Properties
Property Characteristic
AccessToken

Specifies the access token required to authenticate to a Salesforce instance when OAuth 2.0 is enabled (AuthenticationMethod=oauth2.0).

Note: If a value for the AccessToken property is not specified, the driver uses the value of the RefreshToken property to make a connection. If both values are not specified, the driver cannot make a successful connection. If both are specified, the driver ignores the AccessToken value and uses the RefreshToken value to generate a new AccessToken value.
AuthenticationMethod

Determines which authentication method the driver uses when establishing a connection.

If set to userIDPassword, the driver uses user ID/password authentication when establishing a connection.

If set to oauth2.0, the driver uses OAuth 2.0 authentication when establishing a connection.

The default is userIDPassword.

ClaimsIssuer

Specifies the consumer key or the client ID of the Salesforce Connected App.

ClaimsSubject

Specifies the username of the user.

ClientID

Specifies the consumer key for your application. The driver uses this value to authenticate to a Salesforce instance when OAuth 2.0 is enabled (AuthenticationMethod=oauth2.0).

ClientSecret

Specifies the consumer secret for your application. This value can optionally be specified when authenticating to a Salesforce instance using OAuth 2.0 (AuthenticationMethod=oauth2.0).

JWTCertAlias

Specifies the alias for the JWT certificate located in the keystore.

JWTCertStore

Specifies the file path of the certificate store containing the private key used for JWT authentication.

JWTCertPassword

Specifies the password of the JWT certificate, if the certificate is password protected.

Password

Specifies the password to use to connect to your Salesforce instance. A password is required. Contact your system administrator to obtain your password.

Important: Setting the password using a data source is not recommended. The data source persists all properties, including the Password property, in clear text.
RefreshToken

Specifies the refresh token used to either request a new access token or renew an expired access token. When the refresh token is specified, the access token generated at connection is used to authenticate to a Salesforce instance when OAuth 2.0 is enabled (AuthenticationMethod=oauth2.0).

Note: If a value for the AccessToken property is not specified, the driver uses the value of the RefreshToken property to make a connection. If both values are not specified, the driver cannot make a successful connection. If both are specified, the driver ignores the AccessToken value and uses the RefreshToken value to generate a new AccessToken value.
SecurityToken Specifies the security token required to make a connection to a Salesforce instance that is configured for a security token.
Note: A security token is not required when Salesforce has been configured for Trusted IP Ranges and the user is logging in from a trusted IP address. Refer to "Set Trusted IP Ranges for Your Organization" in your Salesforce documentation for details.
Note: If setting the security token using a data source, be aware that the SecurityToken property, like all data source properties, is persisted in clear text.
User Specifies the user name that is used to connect to the Salesforce instance.