Skip to content

About Arena DataExtract

Introduction

Arena DataExtract enables you to connect product data to business intelligence, analytics, and reporting tools. It outputs flat CSV files, making them immediately usable in your preferred tools.

Key Features

  • Delta Extracts: Extract only data that has changed since the last run.
  • Full & Delta Mode: Contact Arena support before switching to avoid disruptions in downstream systems like Arena Analytics.
  • GUID Consistency: GUIDs for Items, BOMs, Requests, Changes, Suppliers, Supplier Items, and Quality Process custom attributes match those from the Arena REST API.

Available Views by Data Type

Data Type Views
Changes Summary, Custom Attributes, Lifecycle History, Decisions, Items, Item Inventory Disposition, Requests, Implementation Notes, Implementation Tasks, Implementation Task Notes
Items Summary, Custom Attributes, Non-Revision Controlled Custom Attributes, Bill of Materials, BOM Custom Attributes, BOM Substitutes, Sourcing, Compliance, Item References
Projects Summary, Schedule, Referenced Items, Referenced Changes, Referenced Requests, Referenced Projects, Referenced Quality Processes, Referenced URL Links
Quality Summary, Custom Attributes, Details, Affected Items, Affected Changes, Affected Requests, Affected Projects, Affected Quality Processes, Affected URLs, Affected Suppliers, Affected Supplier Items, History, Decisions
Requests Summary, Custom Attributes, Lifecycle History, Items, Participants, Issues
Suppliers Summary, Custom Attributes
Supplier Items Summary, Custom Attributes, Compliance
Training Summary, Items, Users, Referenced Quality Processes, Records, History

Configuration

  • Admins configure extracts in Account Administration > DataExtract.
  • Specify:
  • Extract name
  • Data types to include
  • Frequency and interval of runs
  • Use a dummy email for the extract user (e.g., jsmith+arenadataextract@ptc.com).
  • Change login info via Actions > Change Login Info in Workspace Settings.
  • Notify the Solution Architect if Analytics is used and password is changed.
  • The extract user appears in Users > Access as “FirstName: [Job Name], LastName: Extraction” and does not consume a license.

Execution Notifications

  • Choose recipients and frequency of notification emails.
  • Recommended: Only notify on failures for frequent extracts.

Output Formats

  1. DataExtract CSV
  2. Original format, compatible with Arena Analytics.

  3. Not true CSV; may require post-processing for other uses.

  4. RFC 4180 CSV

  5. True CSV format (Excel-compatible).
  6. Recommended for non-Analytics use.
  7. Stored in a subfolder named RFC_4180 within the ZIP output.

ZIP Archive Contents

  • Run description TXT file
  • CSV data files for each selected view
  • CTL files for each data type (for Oracle SQL Loader)

Access via Downloads > DataExtract Downloads or programmatically via Arena REST API.

Special Notes

  • In the Change_Decision_History file:
  • Historical = Y: Approval records from Rejection or Withdrawal (shown in History > Decisions).
  • Historical = N: Records from Approvals subview.
  • If no rejection/withdrawal occurred, no Historical = Y records will appear.

Downloading Data

  • Manual download from Arena Dashboard to shared folder.
  • Programmatic download via Arena REST API (requires admin privileges).
  • Recommended: Use the configured Data Extract user for API access.
  • Includes a Log subview with metadata of past runs.

Contact

For setup assistance, email: arena-sales@ptc.com