Define EXTRACT Options

There are several conventional task parameter setups used with the EXTRACT action type, depending on the type of interface and outgoing file. You can also specify SQL filters to limit the records obtained from the Eagle data warehouse to specific effective dates, entities, and securities. Or, limit the maximum number of rows to retrieve from the database.

You can do the following:

The EXTRACT action type allows you to output data of key data categories within the Eagle product suite and to leverage Message Center capabilities to transport over various protocols and using various formats. The extract process uses a foundational technology within the Eagle product suite called EJM; this stands for Eagle’s external job management and is used to manage and control the extract workflow.

Setup for EagleML Tag Value/XML Extracts

You can create tag value extract files or XML extract files containing information retrieved from the Eagle data warehouse by using the default EagleML message streams with the following <taskParameter> paired options:

<taskParameter>
   <name>Compress</name>
   <datatype>S</datatype>
   <value>Y</value>
</taskParameter>

• <name> = ActionType and <value> = EXTRACT
• <name> = StreamName and <value> = eagle_ml-2-0_default_out_q
• <name> = OutputFormat and <value> = TagValue (or NULL for XML)
• <name> = Compress and <value> = Y (use this option if you want to compress data after extraction)
• <name> = FeedType and <value> = Options listed below

The table below lists the feed type options and descriptions used to create the tag value or XML extract file with filtered results.

Setup for STAR Tag Value Extracts

You can create STAR tag value extract files with information retrieved from the EAGLE data warehouse using the Eagle default STAR extract message stream with the following <taskParameter> paired options:

• <name> = ActionType and <value> = EXTRACT

• <name> = StreamName and <value> = eagle_ml-2-0_default_out_star_extracts
• <name> = FeedType and <value> = Options listed below

The table below lists the feed type options, descriptions, and Eagle report panels used by the STAR extract message stream to create the STAR tag value extract file with filtered results.