Running Extract Packages

You can run extract packages to a file or a global connection.

Considerations

  • You must have Owner or Data Manager permission on all of the dimensions in all of the extracts in the extract package in order to run it.

  • All of the dimensions in all of the extracts in the extract package must have an Active status in order to run the package.
  • If one of the extracts in the package fails, the extract for the entire package is failed and none of the extracts in the package are run.
  • For incremental extracts that use the Since Last Extract option (see Editing Extracts), the context of where the extract was run from (as an individual extract or as part of a specific extract package) is taken into account:
    • When the extract is run as an individual extract (not as part of an extract package), the Since Last Extract parameter will use the last time the extract was run as an individual extract.
    • When the extract is run as part of an extract package, the Since Last Extract parameter will use the last time the extract was run as part of that specific extract package. Each extract package maintains a separate Since Last Extract value. In other words, if you run the extract as part of Package A, and then you run the extract as part of Package B, the extract in Package B will go back to the last time you ran it as part of Package B, not from when you ran it as part of Package A.
    • If no previous extract is found in a particular context (for example, the extract is run for the first time in a specific extract package), then the viewpoint creation date is used.

To run an extract package:

  1. From Applications, in the Actions column, click action, and then select Extract.
  2. On the Extract page, select the Extract Packages tab.
  3. Select the extract package that you want to run.
  4. In Settings, select an option:
    • Connection: Run the extract package to the global connection specified in the extract package definition. (Available only if a global connection is defined for the extract package).
    • File: Run the extract package to a file. For extracts where the output is zipped, you can edit the name of the file in Zip File Name.

      Note:

      When you the Extract Package Target is File, the output is always zipped if the package creates multiple files regardless of the Zip Package setting in the extract package inspector.

      Note:

      If the extract package combines extracts into a single output file and the Zip Package setting is disabled, no zip file is created regardless of the Zip File Name parameter provided. Instead, only the combined file is output and is named based on the File Name setting in the extract package. See Editing Extract Packages.
  5. Optional: Click the extract package name to inspect or edit it.
  6. Click Run Package.

    A status message is displayed at the top of the page.

Reviewing Extract Package History

On the extract packages screen, review the History section to see the dates and times of the most recent extract packages that were run for this application. By default, the last five are displayed. You can adjust the number of extract packages to display (up to 50) in the Show most recent field. Click refresh to update the table.

You can expand an extract package history row to display the extracts that were run as part of that package as well as the duration, status, and number of records that were extracted for each extract.