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.
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 user name 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 that indicates 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 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 element. If you define both elements, the adapter only uses the Query 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. |