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 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 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 and add a new user
6. Name the user something like “Mosaic”, and assign it the role that you just created
7. Ensure that the user is marked as “Active” and deselect the option “Force User to Reset Password at Next Login”
8. (Optional) Use field level security to disallow access to any sensitive information. See Field Level Security for details.

Integrate with Mosaic

Please provide the following details:

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

Versions 4.0 and 4.5

To retrieve your Client ID and Client Secret:

1. Navigate to Integrations -> API Authorization
2. Provide the Client ID, Client Secret and Database Name to Mosaic along with your web application URL

Version 5.0

To retrieve your Client ID and Secret:

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

Steps

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

5. Please follow the steps in the Adding Stored Procedures to Vantagepoint guide to upload stored procedures to Vantagepoint Cloud. Reach out to your Customer Success Manager to obtain the necessary scripts for the following processes:
   • To synchronize Time Entries, upload the "Combined Time" Stored Procedure.
   • To synchronize Work Plans, upload the "Work Plans" Stored Procedure.
   • To synchronize Profit Centers, upload the "Profit Centers" Stored Procedure.

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.