Terms & Conditions

Integration Terms & Conditions

The terms outlined on this page are specific to the Ajera On-Premise 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 Ajera On-Premise:

Data TypeFields
Employees- Name
- Email
- Title
Clients- Title
Project, Phases- Title
- Fee
- Client (Projects only)
- Schedules
Time Entries- Date
- Hours
- Employee
- Project
- Phase
- Work Category
- Description
- Billable
- Rate
Work Categories- Title
- Number

For a list of supported Target Fields in Ajera On-Premise 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 the Ajera production database (Server SQL)
  • Windows admin user that doesn't expire
  • SysAdmin access to the Ajera SQL Server database

Important Information

  • The integration is a one-way sync of data from Ajera On-Premise to Mosaic
  • Data will update in Mosaic up to 24 hours after it is entered/updated in Ajera On-Premise
  • Phases/Tasks will appear in the order they are created in Mosaic, which may be different to the order in Ajera On-Premise.