Skip to main content

Add the DB2 Connector

Authenticate to DB2

  • Server: Enter the address or host name of the DB2 server.
  • Port: Enter the port on which your DB2 server is listening. The default port is 50000.
  • Database: Enter the name of your DB2 database.
CData Sync supports authenticating to DB2 in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

User Id and Password

To connect with user credentials, specify the following settings:
  • Auth Scheme: Select USRIDPWD.
  • User: Enter the username that you use to authenticate to your DB2 account.
  • Password: Enter the password that you use to authenticate to your DB2 account.

Encrypted User Id and Password

To connect with encrypted user credentials, specify the following settings:
  • Auth Scheme: Select EUSRIDPWD.
  • User: Enter the username that you use to authenticate to your DB2 account.
  • Password: Enter the password that you use to authenticate to your DB2 account.

IBM Identity and Access Management Authentication

To connect with IBM Identity and Access Management credentials, specify the following settings:
  • Auth Scheme: Select IBMIAMAuth.
  • User: Enter the username that you use to authenticate to your DB2 account.
  • Password: Enter the password that you use to authenticate to your DB2 account.

Kerberos

To connect with Kerberos, specify the following settings:
  • Auth Scheme: Select KERBEROS.
  • Password: Enter the password that you use to authenticate to your DB2 account.
  • Kerberos KDC: Enter the host name or IP address of your Kerberos Key Distribution Center (KDC) machine.
  • Kerberos SPN: Enter the service principal name (SPN) for the Kerberos domain controller.
  • Kerberos User: Enter the principal name for the Kerberos Domain Controller. The name should be in the form Host/User@Realm.
  • (Optional) Kerberos Keytab File: Enter the full file path to your Kerberos keytab file.

Complete Your Connection

To complete your connection:
  1. For Use SSL, select whether you want to enable Secure Sockets Layer (SSL). By default, the Enable checkbox is not selected.