IBM Db2 for LUW Sources > Before you begin > Create a connection
  

Create a connection

Create an IBM Db2 for LUW connection object in Administrator with the connection details of the IBM Db2 for LUW source system.
    1In Administrator, select Connections.
    2Click Add Connection.
    3Select Db2 for LUW Database Ingestion and click Next.
    4Enter the connection properties.
    The following table describes the connection properties:
    Property
    Description
    Connection Name
    A name for the connection. This name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
    Spaces at the beginning or end of the name are trimmed and are not saved as part of the name. Maximum length is 100 characters. Connection names are not case sensitive.
    Description
    An optional description for the connection. Maximum length is 255 characters.
    Runtime Environment
    Execution platform that runs tasks. The runtime environment is either a Secure Agent or a serverless runtime environment.
    User Name
    The user name to use for connecting to the Db2 for LUW instance.
    Password
    The password to use for connecting to the Db2 for LUW instance.
    Host
    The name of the machine that hosts the database server.
    Port
    The network port number used to connect to the database server.
    Database Name
    The name of the Db2 for LUW database that you want to access.
    Advanced Connection Properties
    Advanced properties for the Progress DataDirect JDBC DB2 driver that you use to connect to the IBM Db2 for LUW source system.
    You can specify the following advanced connection properties:
    • - Specify the path to the SSL certificate. For example, EncryptionMethod=SSL;TrustStore=/data/sslCertificates/DB2_ssl/mydbserverssl.jks;TrustStorePassword=Infa@123.
    • - If you enable credential protection without enabling full encryption, specify the following property: AuthenticationMethod=encryptedUIDPassword
      • Note:
      If you don't specify the property, Test Connection fails.
    • - If you use an Amazon RDS for Db2 database, specify the following properties: EncryptionMethod=requestDBEncryption;AuthenticationMethod=encryptedUIDPassword
      • Note:
      If you don't specify the properties, Test Connection fails.
    5Click Test to test your connection to the source system.
    6Click Save.