Extract BLOBs

The Extract BLOBs option speeds up the time for collecting large amounts of accounting data and loading it into a different Eagle environment for diagnosing accounting issues. With this option, you do not need to involve a DBA to get the data extracted. This option also provides a secure mechanism for collecting detailed data typically restricted due to permissions. Data from the ESTAR_COST_POSITION, ESTAR_CASH_POSITION, and ESTAR_INCOME_POSITION tables is collected for an individual portfolio account, asset Id, and account bases and then delivered to a specified location.

To extract an accounting BLOB:

  1. In System Management Center, click Diagnostics in the left navigation and click Extract BLOBs.
    You see the Required Parameters dialog box.

    Extract Blobs wizard
  2. In the Required Parameters dialog box, select the Position Type, Entity ID, and Security Alias to identify the BLOB data. Click Next.
    The Account Basis field is automatically filled in based on the entity/security combination.

    Extract BLOBs wizard - Required Parameters tab
  3. In the Optional Parameters dialog box, complete the appropriate fields. Click Next.

  4. In the Positions dialog box, click the tab based on the type of positions you specified and check the appropriate check box to select the data. Click Next.

  5. In the Details dialog box, complete the appropriate fields. Click Next.

  6. In the Delivery dialog box, complete the appropriate fields. If you select email as the delivery method, the file size must be less than 20MB. Click Next.

  7. In the Progress dialog box, review the status of the BLOB extract.

  8. Click Finish.
    The BLOB data extract is delivered to the location you specified.