Deltek Vantagepoint Integration Guide
Mosaic integrations securely connect your ERP systems to bring the right people, project, financial, and time entry data into Mosaic for resource planning and management. By automating data synchronization, Mosaic eliminates manual data entry, reduces errors, and centralizes critical information in one location.
During onboarding, we'll help you connect your system, review your data to ensure it flows correctly, and CS will guide you through the tools and workflows. Start with the step‑by‑step setup instructions below, then follow the settings guide to finish configuration and validate your data.
1. How do we integrate to Vantagepoint
Connection types
- Cloud: Uses Vantagepoint’s API. Easiest to provision. By default, Cloud does not include timesheets unless paired with Stored Procedures.
- with Stored Procedures: If you use Vantagepoint Cloud and wish to sync timesheet data, you will also need to add Stored Procedures as that will allow us to integrate timesheet and work category data. Please see resources in section 7 for detailed instructions.
- On‑prem: Connects to your SQL Server via replication to Mosaic’s cloud infrastructure on Azure or .bak. This provides broader table access to the integration connectors.
2. What Mosaic syncs from Vantagepoint
| Data Type | What It Includes |
|---|---|
| Employees | Name, email, status |
| Clients | Name, client code |
| Projects | Title, description, fee, client, start/end date, profit center, billing method |
| Phases | Title, fee, start/end date, estimated hours, billing method |
| Work Categories | Vantagepoint Labor Codes |
| Time Entries | Hours, billable status, hourly rates, comments |
| Work Plans | Resource allocations, planned hours, date ranges |
| Roles | Billing categories |
| Rates | Rate tables by category, labor code, or employee |
| Rate Groups | Rate table groupings for roles and activities |
| Cost Rates | Employee cost rates (job cost or provisional) |
| Member Roles | Employee-to-role assignments |
| Member Project Roles | Employee-to-project-role assignments |
| Member Project Rates | Employee-to-project-rate assignments |
| Entity Rates | Rate assignments linking roles or activities to rate groups |
Fee source: Mosaic sets fees from Vantagepoint's Project Contract Management tab, Labor Budgets, or Fee Billing Terms.
3. What Mosaic provides during onboarding
- Integration setup support (guidance, troubleshooting)
- Pre-built connectors and setup instructions (outlined in this document)
- Training & guidance on workflows and best practices
4. Typical implementation timeline & what to expect
Mosaic expects the integration implementation timeframe to be 2-4 weeks for cloud and 4-6 weeks for on-premise*
- Approximate Timeline for Cloud:
- Week 1: Intake form submission + initial validation
- Week 2: Setup & configuration.
- Week 3–4: Testing, troubleshooting, and go-live.
- Approximate Timeline for On-Premise:
- Week 1: Intake form submission + initial validation
- Week 2-4: Replication Setup & configuration.
- Week 5–6: Testing, troubleshooting, and go-live.
- Timeline starts and is contingent upon your successful and timely completion of forms and provision of credentials. Any requests to sync additional fields or change integration behavior will be scoped as Statements of Work which may be billed as implementation hours at the rate outlined in your contract.
5. Readiness Checklist
In order for onboarding to be considered successful, we need these items to be completed:
✅ Internal IT resource assigned and connected with Mosaic
✅ Completed ‘Integration Request’ and ‘Technical Deep Dive’ form (you should have already received this in your welcome packet)
✅ Follow the instructions to set up Vantagepoint integration with Mosaic (see connecting Vantagepoint in section 7)
✅ Mosaic infra is successfully connected to your ERP and data is syncing
✅ Historical data sync confirmed successful by our Solutions team
6. What Mosaic needs from you and next steps
- Submit your integration request form and deep dive form (you should have already received this in your welcome packet)
- Mosaic reviews & starts set up process. Solutions team will review your forms and may reach out.
- Provide IT point of contact in case troubleshooting is needed.
- Provide connection details (see section 7 under “Connecting Vantagepoint” for your system type)
- Review the ‘Vantagepoint Visual Settings Guide’ to plan ahead and consider your settings in Mosaic to prepare for onboarding & SOP discussion
7. Helpful Resources
Connecting Vantagepoint
- Vantagepoint Cloud + Stored Procedures
- Vantagepoint On-prem
Vantagepoint technical documentation
Updated 8 days ago