EnterWorks - ETT 101 - How to Implement an Export or Publication Callout Using SQL

EnterWorks can generate several different types of exports in tabular format (csv, xlsx, and xls) and for multiple linked repositories.  Sometimes the exact desired output cannot be achieved with the template defined through the UI.  The Export and Syndication Template Advanced Callout Function option provides an opportunity to manipulate the export data after it has been collected/staged, but before the file has been generated.  Columns can be added and populated, removed, renamed, or altered in this staged data.  Rows of data can also be inserted or deleted.  Some of the use-cases for invoking a callout include:

• Pivoting values linked records to appear as a delimited list in a single column instead of multiple rows in the export
• Adding metadata not defined in the source repositories but derived from the export data or the submitting user
• Filtering out columns needed for callout processing but not desired in the final file
• Filtering out records based on the submitting user, or other criteria that cannot be expressed in a saved search       
  A built-in callout allows for SQL stored procedures to be invoked to perform the alterations.  This covers how to create and configure SQL stored procedures to perform the callout processing.

Prerequisites - EBA 203