Integrating Deltek Costpoint (or AutoTime) time entry actuals into Resource Management

JR Laprime
Tera Guru

an hour ago

Hi ServiceNow Community,

 

We’re looking for guidance and lessons learned from anyone who has integrated Deltek Costpoint (and/or AutoTime) time entry into ServiceNow SPM/PPM Resource Management (legacy).

 

Current situation

  • We plan and manage projects/resources in ServiceNow, but actual labor time is entered in Costpoint (and some groups in AutoTime) due to compliance requirements.
  • This creates a gap: ServiceNow resource plans and projects don’t receive actual hours, so plan vs. actual (hours) and forecasting accuracy are limited.

 

High-level goal
Bring hours only (no labor rates/dollars) into ServiceNow so PMs/resource managers can compare planned vs. actual hours at the project level (and ideally resource plan level).

 

What we’re trying to decide

  1. Best-practice target in ServiceNow:
    • Populate native Time Cards / Time Worked records, or
    • Store hours in a custom “actual hours” fact table and roll up to projects/resource plans for reporting
  2. API-first approach (preferred) vs scheduled batch import (daily). We can do daily refresh initially, but would love to know if anyone has successfully used real-time or incremental APIs.
  3. Mapping approach:
    • Charge code → project mapping is straightforward
    • Mapping time entries to the correct resource plan can be tricky when multiple plans exist for the same person/project over time—any patterns for resolving this?

 

Questions for the community

  • Has anyone integrated Costpoint or AutoTime into ServiceNow to support project/resource actual hours?
  • What architecture did you use (IntegrationHub, MID + REST/SOAP, custom API, import sets, ETL/iPaaS)?
  • If you used native ServiceNow timecards, what pitfalls should we expect (approvals, rate models, task mapping, performance)?
  • Any recommendations for incremental loading (e.g., “last updated” timestamps / unique time-entry IDs)?
  • Any gotchas specific to Resource Management legacy?

 

Appreciate any experience, references, or sample patterns you’re willing to share.

 

Thanks,
JR

0 Helpfuls
  • 60 Views
0 REPLIES 0