Part 1: Deltek Vantagepoint Integration Setup

You must generate an ID and a secret for Mosaic in order to access Vantagepoint through the API.

To set up access to the API:

1. In the Navigation pane, select Utilities > Integrations > API Authorization.
2. On the API Authorization form, click Generate Secret.

• Important: You only need to generate the secret once. However, if you generate a new secret any time thereafter, all current integrations using the old secret will be broken until you refresh your access token for those integrations.

4. In response to the confirmation message, click Generate.
5. Take note of the Client ID, Client Secret, Database Name, Vantagepoint API Username/Password that your applications can use to access Vantagepoint through the API display. You will enter these credentials in Step #4 of "Integrating with Mosaic" below.

🚧

Instructions for Vantagepoint Cloud Version 5.0 and above:

1. In the Navigation pane, select Utilities > Integrations > API Authorization.
2. Select Allow Password Grant Type
3. Take note of the Consumer Key (also known as Client ID), Secret (also known as Client Secret), Database Name, Vantagepoint API Username/Password that your applications can use to access Vantagepoint through the API display. You will enter these credentials in Step #4 of "Integrating with Mosaic" below.

Create a New Role

1. Navigate to Security → Roles

2. Add a new Role
3. Set the “Type of Role” to Administrator and Accounting
4. Select the following permissions:
   1. Hubs → Employees
   2. Hubs → Firms → Firms
   3. Hubs → Projects
   4. Utilities → Integrations → API Authorization
   5. Settings → Accounting → Labor Code

Create a New User

5. Navigate to Security → Users to add a new User
6. Name the User something like “Mosaic”, and assign it the Role that you just created
   1. You do not need enter an associated Employee
7. Ensure that the user is marked as “Active”
8. Deselect the option “Force User to Reset Password at Next Login”
9. (Optional) Use field level security to disallow access to any sensitive information. See Field Level Security for details.

Confirm Requirements for the Integration Setup:

1. The username and password of the new user you’ve created
2. The Client ID, Client Secret, Database Name, and URL for your web application.

   The URL should look like this:
   https://companyname.deltekfirst.com/CompanyName/api

To retrieve your Client ID and Secret:

Deltek Vantagepoint Versions 4.0 and 4.5

1. Navigate to Integrations -> API Authorization.
2. Locate the Client ID, Client Secret and Database Name, which you'll enter in the Deltek Vantagepoint Cloud Connection Modal along with your web application URL.

Deltek Vantagepoint Version 5.0 and above

To retrieve your Client ID and Secret:

1. Navigate to Integrations -> API Authorization.
2. Click on New Authorization.
3. Give the authorization a name like "Mosaic Integration".
4. Choose Match Role Access for Scopes.
5. Enter https://vantagepoint-agent.us-east-1.prod.mosaicapp.com for the Callback URL.
6. If you have an option for Allow Password Grant Type on the form, make sure that it is selected.
7. Provide the Database Name, Consumer Key and Client Secret to Mosaic along with your web application URL.

Part 2: Integrate with Mosaic

Step 1: Upload Stored Procedures to Vantagepoint Cloud

To begin, please refer to our comprehensive guide on Adding Stored Procedures to Vantagepoint for detailed instructions on uploading stored procedures to your Deltek Vantagepoint Cloud environment. You can obtain the required scripts for the following processes by reaching out to your Customer Success Manager:

• For synchronizing Time Entries, you will need to upload the "Combined Time" Stored Procedure (Required).
  • By default, Mosaic retrieves Combined time (both Posted and Unposted time). If you prefer to fetch only Posted time, please contact your Customer Success Manager.
• For synchronizing Work Plans, you can choose to upload the "Work Plans" Stored Procedure (Optional).
• If you wish to synchronize Profit Centers, you can also upload the "Profit Centers" Stored Procedure (Optional - Coming Soon).

Once Deltek has confirmed the successful upload of these stored procedures to your Deltek Vantagepoint Cloud environment, you can proceed to Step 2.

Step 2: Connect to Vantagepoint Cloud in Mosaic

1. Login to Mosaic and navigate to the company settings from the Home screen

2. Select Integrations from the Settings menu

3.Select Deltek Vantagepoint Cloud from the financial options

4. Enter your username, password, client ID, client secret, database name, and URL and click connect

Integration Settings

Fees

You can configure Mosaic to show your fees using your Direct Labor Fee + Direct Consult Fee, or just the Direct Labor Fee. In Vantagepoint, these fields are located in the Projects -> Budget & Revenue tab

Deltek VantagePoint <> Mosaic Best Practices

Projects and Phases

How to Set Fees on Projects

Fees are synced from VantagePoint into Mosaic from the “Direct Labor” amount that is listed in your Projects and Phases, under Projects Hub → Contract Management → Compensation.

There are many ways that the Direct Labor amount can be set, but so long as there is a “Direct Labor” amount visible on this page, it should sync into Mosaic.

One way to set the Direct Labor amount is as follows:

1. Navigate to the Projects Hub under the Hubs menu in your VantagePoint web application
   

2. Inside the Projects Hub, select Contract Management, and choose your Project from the drop down at the top of the screen
   

   

📘

Please Note:

If you are trying to set the fee for a particular Phase, you should use the Project Structure button to the left of the Project’s name to select the appropriate Phase

3. Select Edit on the right hand side of your screen to make changes to this project. Add the fee that you wish to bring into Mosaic Under the Direct Compensation section as the Direct Labor amount and save the Project record.

4. After setting Fees on Phases, navigate to the Project's Contract tab, and select Include In Fees for the phases you wish to include in the Total Project Fee. Selecting this will populate the value under Direct Compensation > Direct Labor page. Mosaic can only sync phase budgets if it is visible under Direct Compensation > Direct Labor.

Start/End Dates

Start and End dates for Projects and Phases are synced into Mosaic from the dates that is listed in your Projects and Phases under Projects Hub → Plan → Schedule.

There are many ways that start and end dates can be set for Projects and Phases, but so long as you have the correct dates in the “PLAN START” and “PLAN END” columns, they should sync into Mosaic.

One way to set the start and end dates is as follows:

1. Navigate to the Projects Hub under the Hubs menu in your VantagePoint web application
   
2. Inside the Projects Hub, select Project, choose your Project from the drop down at the top of the screen, and select the Dates & Costs tab
   
   Note: If you are trying to set the fee for a particular Phase, you should use the Project Structure button to the left of the Project’s name to select the appropriate Phase
   
3. Click “Add Milestone”. Add Milestones for the start and end dates for your Project or Phase using “Estimated Start Date”, and “Estimated Completion Date” respectively.