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.
| XML Element | 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 elements. |
| 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 the SQL clause you want the adapter to execute. No default value. Set either the Table or SqlInsert element. If you define both elements, the adapter uses only the SqlInsert element. |
| 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 element. This element 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 element. This element is required if the password value is encrypted. |
| RSAKeyStoreAlias |
Type: string (Dependent required) Specifies the keystore alias. This element is required if the password value is encrypted. |
| BatchSize |
Type: integer (Optional) Specify the number of records to process as a batch. |
| BatchPeriod |
Type: integer (Optional) Specify the period for processing a batch, in milliseconds. |