The JDBC Input transporter reads database records using JDBC and sends them to the next module specified in the adapter configuration file. Set values for this transporter in the adapter configuration file.
| Parameter | Description |
|---|---|
| Host |
Type: string (Required) Specify the server name of the database to which you are connecting the adapter. |
| Port |
Type: integer (Required) Specify the port number for connecting to the database server. |
| Username |
Type: string (Required) Specify the username you are using to connect to the database server. |
| Password |
Type: string (Required) Specify the password for connecting to the database server. Includes an "encrypted" attribute indicating whether the password value is encrypted. If set to true, the password value is decrypted using the RSAKeyStore, RSAKeyStorePassword, and RSAKeyStoreAlias parameters. |
| DbName |
Type: string (Required) Specify the database name of the database to which you want to connect. |
| DBType |
Type: string (Required) Specify the database type of the database to which you want to connect. |
| DbDriver |
Type: string (Required) Specify the JDBC driver class for your JDBC driver. |
| Table |
Type: string (Optional) Specify the name of the table in the target database from which you want the adapter to read. |
| Query |
Type: string (Optional) Specify which SQL query you want the adapter to execute. No default value. Set either the Table or Query parameter. If you define both parameters, the adapter only uses the Query parameter. |
| RSAKeyStore |
Type: string (Dependent required) Specify the location of an RSA keystore file which contains the key used to encrypt or decrypt the password set in the Password parameter. This parameter is required if the password value is encrypted. |
| RSAKeyStorePassword |
Type: string (Dependent required) Stores the password to the RSA keystore file specified in the RSAKeyStore parameter. This parameter is required if the password value is encrypted. |
| RSAKeyStoreAlias |
Type: string (Dependent required) Specifies the keystore alias. This parameter is required if the password value is encrypted. |