SQL Action

Runs an SQL statement on an external database.

The SQL Action can be utilised to insert data into an external database system.

An External Database Connection must have been established via 'Provision | External Connections'.

There are serious security implications when setting up an External Database Connection so this option should be discussed with Noojee support before proceeding.

Fields

Campaign Template

The Campaign Template that this action will pull fields from.

External DB Connection

The external DB connection to be utilised.

Call

Name of the stored procedure to be called.

e.g. mystoredproc

Value List

The value List can contain a comma separated list of encoded fields names that are passed to the stored procedure.

e.g.

${njLeadId}, ${phoneNo}, ${surname}, ${njDispositionAction}

This will result in a SQL call of the form:

call mystoredproc("1","0383208100", "Smith" "Sale")