How to Setup Your Viewpoint Vista SQL User for Trimble's integrations between Procore Financials and Viewpoint Vista

Only for Procore Financials <> Vista integration subscriptions.

How to Setup Your Viewpoint Vista SQL User for the XChange Agent

Please note: If the integration that you are subscribing to includes moving documents such as receipt images to the Viewpoint server, please ensure that these steps are followed for both the Viewpoint database, as well as the VPAttachments database, if applicable. The XChangeServiceUser will require access to both databases.

Creating a Trimble Integrations Service User SQL User 

  1. Within Microsoft SQL Management Studio, expand the Security menu and right-click Logins to expose the “New Login…” menu option. Select “New Login”.

    Screen Shot 2021-05-04 at 2.47.06 PM
  2. Create a new login name
    • Create a login name such as ‘XChangeServiceUser’
    • Select “SQL Server authentication”
    • Establish a password that meets your company password policy. We recommend:
      • contains at least 12 alpha-numeric characters
      • contains at least one exclamation point ( ! )
      • Please do not use any other special characters.
    • Uncheck “Enforce password policy”
      • Note: if this is not done, your integration will be at risk of having a broken sync due to changing credentials over time.
    • Ensure that the Default database is your Viewpoint database

  3. Navigate to the User Mapping page to grant the XChangeServiceUser with database Read/Write permissions for your Viewpoint database
    • Select your Viewpoint database
    • Grant the user the following permissions:
      • db_datareader
      • db_writer
      • public
      • VCSUsers


4. Click OK.

Configuring the Vista Application User

Vista system access is performed through the Viewpoint Vista views and stored procedures. This aligns Trimble Integrations access patterns with those of the standard Viewpoint Vista software. This also means that our user must be a valid Viewpoint Vista user and a member of the appropriate Data Security Groups to Vista Data.

  1. Open the Vista VA User Profile application

    Screen Shot 2021-05-04 at 3.05.19 PM
  2. Create a New Vista User Profile
    • Click the New Record icon
    • Username = XChangeServiceUser
    • Tab out and then change the User Type to 'User Application'
      • Note: most of the form items will become disabled.
    • Full Name = XChange Service User
      • Email Address = email address does not matter and can be any real or fake email. The integration does not use it, but the field may be required by your Vista form.
    • Save.
    • You may be prompted that there is no SQL login that matches that username. Close it out.
      Screen Shot 2021-05-04 at 3.13.13 PM
    • You may also be prompted for SQL User Password. If so, enter the same password used when creating the SQL User name 'XChangeServiceUser'.
      Screen Shot 2021-05-04 at 3.14.23 PM
    • You may see an error message like the one below. Do not be alarmed. The SQL sure created will still be tied to the Vista user you just created. You can close.
      Screen Shot 2021-05-04 at 3.15.11 PM
  3. Assign Proper Security Groups to the new 'XChangeServiceUser'.
    • Your security group configuration is specific to you and how your Vista administrator set it up. You must grant security group access to the data types used by the integration, otherwise the integration will be unable to access the data. If you are unsure which security groups are needed by your integration, contact your Vista administrator. 
    • Confirm whether or not you leverage Vista Data Type Security.
      Screen Shot 2021-05-04 at 3.20.49 PM
    • If none of these Data Types are checked as 'Secured', then you do NOT use Data Type Security and you can skip to the end.
    • Generally, there will be an 'All Data' (or similar group) that will provide the access the XChangeAgent needs. Select the needed Data Type Security groups.
      • Note: App XChange's filtering ensures we only pull the companies you have specified. We will not touch companies that should not be integrated.Pic11-SecurityGroups
    • Click 'OK' to add 'All Data'
    • Click the 'Save' icon on the VA User Profile form.

Once all steps are complete, please respond to your Trimble Integrations representative with the following:

  • Server name
  • Database name
  • PW for the XChangeServiceUser


If you're in the process of migrating to Viewpoint Cloud, return here for Step 4.

If you need help, please contact .