The JDBC Output transporter obtains data from the previous module specified in the adapter configuration file and writes it into a database table using JDBC. 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 to which you want the adapter to write. |
| SqlInsert |
Type: string (Optional) Specify which SQL clause you want the adapter to execute. No default value. Set either the Table or SqlInsert parameter. If you define both parameters, the adapter only uses the SqlInsert 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. |