Database Data Targets

Name

Required

Free text.

Query

Required

Select the query that will generate the data for this target.
See the relevant target type documentation for additional details on what query columns are required for your target.

Query Mode

Required

Select New unless you have a reason to select Latest or Specific.

Credential

Required

Select a Database from the drop-down menu.

Table Name

Required

Enter the Table name you wish to send data.

Primary Key Name

Required

Enter the column name you wish to use to associate the data you are sending to the database with the corresponding table.

A Primary key is a column within your table as well as within your query.

This field does not currently support composite keys.

If your primary key is an auto incrementing ID, be sure to also use the Auto Increment setting.

Use Multi-Value Insert

Optional

Enable or disable the Use Multi-Value Insert toggle to insert multiple records into the database.

This setting is useful when inserting (will not be available for updates) large volumes of net new records. The action DataBlend takes will batch the transactions for more efficient processing of data being sent into the database. If this is not selected, the rows will be created one at a time.

Be mindful that when batching via this setting you may lose per row granularity in the logs which can impact troubleshooting so it is best practice to test your data target sufficiently before enabling this setting.

Delete Records

Optional

Enable or disable the Delete Records toggle to delete records based on a unique id used in the created Query. This changes the action DataBlend is taking from an Insert Statement to a Delete Statement.

Auto Increment

Optional

Enable or disable the Auto Increment toggle to auto increment data based on a unique ids used in the created Query.

If the primary key is auto incremented, this setting will allow it to be excluded from the fields to insert/update.

Disable Commit

Optional

Enable or disable the Disable Commit toggle to ensure a commit is disabled when sending data to a database.

This starts a transaction but doesn't commit it and is useful for testing.

Transaction per Row

Optional

Enable or disable the Transaction per Row toggle to create transactions per row in the database.

Continue on Error

Optional

Enable or disable the Continue on Error toggle to send data regardless of error.

This is useful in conjunction with transaction per row. If one records fails, others may still be inserted.