Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

Connections

Db2 for LUW Database Ingestion connection properties

Db2 for LUW Database Ingestion connection properties

When you define a Db2 for LUW Database Ingestion connection, you must configure connection properties. You can use this connection type in database ingestion tasks, which you configure in the Mass Ingestion service.
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.
Type
The type of connection. Ensure that the type is Db2 for LUW Database Ingestion.
Runtime Environment
The name of the runtime environment where you want to run
database ingestion
tasks. You define runtime environments in
Administrator
.
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, which is used to connect to the Db2 for LUW source. If you specify more than one
property
=
value
entry, separate them with a semicolon (;).
The driver properties that you can enter in this field are described in the Progress DataDirect documentation at https://docs.progress.com/bundle/datadirect-connect-jdbc-51/page/Connection-Properties_10.html. For example, you can set the EncryptionMethod property to control whether data is encrypted and decrypted when transmitted over the network between the driver and database server.

0 COMMENTS

We’d like to hear from you!