Part 1: Integration Setup

Create a New Role

1. Create a new role by navigating to Configuration → Security → Roles → New
2. Under the General tab:
   • Give your role an appropriate name (e.g., MOSAIC), and select “Admin” for role type
   • Check “Allow Access to SOAP API”
3. Select permissions to access the following areas:
   • Info Center
     • Client
     • Employee
     • Project
   • Planning
     • Project Planning
   • Billing
     • Billing Terms
   • Transaction Center
     • Transaction Entry
   • Time & Expense
     • Timesheet

4. Under the Access Rights Tab select the “Functional Area” from the drop down, select “Application Tabs”, then check “Full access to all tabs”
   
5. Save your new role.

🚧

Please Note:

If your company uses the Multicompany feature, you must assign the Role to the Company in Roles -> Access Rights -> Companies. For instructions, see Deltek docs.

Create a New User

6. Create a new user by navigating to Configuration → Security → Users → New

• Unselect Force User to Reset Password at Next Login and Disable Login
  

7. Give your new user an appropriate name (e.g., MOSAIC), and a strong password.
8. In the drop down for “Role”, select the role that you just created
9. Save the new user.
10. Confirm that you can log into Vision Cloud with the New User credentials.
11. (Optional) Use field level security to disallow access to any sensitive information. See Field Level Security for details.

Part 2: Integrate with Mosaic

Step 1: Upload Stored Procedures to Vision Cloud

To begin, please refer to our comprehensive guide on Adding Stored Procedures to Vision for detailed instructions on uploading stored procedures to your Deltek Vision 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).

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

Step 2: Connect to Vision Cloud in Mosaic

Once your Stored Procedure(s) have been uploaded to your Deltek Vision environment, please proceed to entering the credentials on 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 Vision Cloud from the financial options

4. Enter the following information and click Connect
   1. The username and password of the new user you’ve created on Deltek Vision
   2. The URL that you use to access your Deltek Vision web application (this usually looks like https://mycompany.deltekfirst.com/MyCompany/visionws.asmx?wsdl)

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 Vision, these fields are located in the Projects -> Budget & Revenue tab