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 Type	Fields
Employees	- Name - Email - Default Role
Clients	Title
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