Terms & Conditions

Integration Terms & Conditions

The terms outlined on this page are specific to the Deltek PIM integration, please also review the page linked below for additional Integration Terms which apply to all integrations

Data Included in the Integration

Mosaic Data Types and Data Fields populated from Deltek PIM:

Data TypeFields
Employees- Name
- Email
- Default Role
Project, Phases- Project Title
- Project Number
- Fee
- Client (Projects only)
- Phase Name
- Phase Number
Time Entries- Project
- Phase
- Date
- Employee
- Hours
- Rate
- Work Category
Work Categories- Title
- Number
Role Rates- Role
- Start
- End
- Bill Rate/Hr

For a list of supported Target Fields in Deltek PIM please refer to this page.

Integration Requirements

  • Standard Edition or Enterprise Edition SQL Server 2012 or later
    • Express edition is not supported
    • If using SQL Server 2012: must have the latest Service Pack installed
    • If using SQL Server 2014: must have Service Pack 3 and Cumulative Update 4 or later installed
  • Replication components for SQL Server must be enabled
  • Remote access to the server hosting Deltek PIM production database (Server SQL)
  • Windows admin user that doesn't expire
  • SysAdmin access to the SQL Server database

Important Information

  • The integration is a one-way sync of data from Deltek PIM to Mosaic
  • Data will update in Mosaic up to 24 hours after it is entered/updated in Deltek PIM