Home
Corporate Marketer Guide
Corporate marketers develop templates for reusable campaign logic and lists of customer contacts.
About processes
Using queries to select data
When you configure a Select, Segment, or Extract process in a flowchart, you can use queries to identify contacts from your databases or flat files. There are several different query methods.
Specification of pre- or post-processing SQL statements
If you are using a Select or Extract process, you can optionally include raw SQL statements to run before or after the process.

Specification of pre- or post-processing SQL statements

If you are using a Select or Extract process, you can optionally include raw SQL statements to run before or after the process.

Pre-processing: Enter raw SQL to be processed before the query runs.
Post-processing: Enter raw SQL to be processed after the query runs.

Use this feature to include SQL procedures as part of the process run, which can be useful for ETL, routine data mart updates, performance tuning, and security. For example, you can use pre- and post-processing SQL statements to:

Run stored procedures in the database
Create, drop, and re-create tables and indexes
Grant or change privileges to other users or groups
Organize multistep database commands
Run complex database routines without having to use external scripts to connect to the database