Loading...
This destination connector connects to an external database and performs an INSERT/UPDATE statement (or any other statement, like calling a stored procedure). This can be done using a SQL statement, or by using JavaScript mode to execute the statement manually. The database connection will automatically be kept open across multiple dispatches.
Supported property groups:
Item | Name | Default Value | Description |
---|---|---|---|
A | Driver | Specifies the type of database driver to use to connect to the database. The following values are supported by default:
Additional drivers can be added by editing the dbdrivers.xml File. | |
B | URL | The JDBC URL to connect to the database with. This is not used when "Use JavaScript" is checked. However, it is used when the Generate Connection / Insert feature is used to generate code. Use the Insert URL Template button to populate the URL field with a starting template. | |
C | Username | The username to connect to the database with. This is not used when "Use JavaScript" is checked. However, it is used when the Generate Connection / Insert feature is used to generate code. | |
D | Password | The password to connect to the database with. This is not used when "Use JavaScript" is checked. However, it is used when the Generate Connection / Insert feature is used to generate code. | |
E | Use JavaScript | No | If enabled, the JavaScript scripts will be used to run the insert/update statement. If disabled, SQL code (either standard or database-specific) may be used, and the connection will be handled automatically. |
F | Generate |
| |
G | SQL / Template | The actual SQL or JavaScript code to execute. |