Getting Started with PTC Orbit > Data Sources
Data Sources
PTC Orbit ingests asset, product, parts, and maintenance data from ServiceMax Core, Windchill, Salesforce, and AWS S3 through Matillion ELT pipelines.
PTC Orbit aggregates data from multiple external systems into a unified asset profile. Each source system contributes a distinct category of data. Matillion ELT pipelines handle extraction, transformation, and loading into Snowflake, where the data becomes available to the application layer.
Supported Sources
Source system
Data provided
Integration method
ServiceMax Core
Assets (installed products), accounts, locations, work orders, service history, and preventive maintenance objects (PM Plans, PM Coverage, PM Schedules, PM Schedule Definitions, PM Processes, PM Expressions, PM Work History).
Matillion pipeline with Salesforce connector
Windchill
Product structures, parts hierarchies, 3D CAD models (PVZ files), and bill-of-materials data.
Matillion pipeline with REST connector
AWS S3
Bulk CSV and JSON files for initial data loads, historical imports, or custom data feeds. Also, for on-premise source system, S3 can serve as a bridge where data can be exported to S3, and PTC Orbit can load data through pipeline.
Matillion pipeline with S3 connector
Canonical Data Model
Data from source systems is normalized into the PTC Orbit Canonical Data Model (CDM) before downstream features consume it. The CDM defines a consistent schema for maintenance objects, asset attributes, and service records regardless of the originating platform. For the full CDM object reference, see Canonical Data Model Maintenance Objects.
Ingestion Modes
PTC Orbit stage objects support two ingestion modes that control how data flows from Snowflake staging tables into the application database:
• Staging Review: Data is staged for manual review before an administrator commits it to the database. The Asset object uses this mode by default.
• Direct Sync: Data is ingested, temporarily staged, then written to the database automatically through system sync jobs. For example, the Account object is recommended to be a Direct Sync object.
For ingestion mode configuration, see Setting Up Data Sync.
Was this helpful?