NextGen Knowledge Center

Database Writer

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:

ItemNameDefault ValueDescription
ADriver Specifies the type of database driver to use to connect to the database. The following values are supported by default:
  • Sun JDBC-ODBC Bridge
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server / Sybase
  • SQLite

Additional drivers can be added by editing the dbdrivers.xml File.

BURL 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.
CUsername 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.
DPassword 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.
EUse JavaScriptNoIf 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.
FGenerate 
  • Connection: This button is enabled when Use JavaScript is enabled. When selected, it inserts boilerplate Connection construction code into the JavaScript pane at the current caret position.
  • Insert: Opens a window to assist in building an insert statement to insert records into the database specified in the URL above.
GSQL / Template The actual SQL or JavaScript code to execute.