Skip to main content

Authentication

Connecting to Cloud Versions of Vista

The below provides an overview of how to connect to cloud or hosted versions of Vista. It takes about 15-30 minutes to complete.

Step 1: Create an Agave User in Vista

The first step is to create a dedicated User to connect to Agave Sync. We recommend using a dedicated User for the integration, so you can track activity from your integration with your PM system.

To create a dedicated User, you can follow Trimble's guide. We recommend naming this user "Agave-User".

danger

Your password must meet the following criteria:

  • Be at least 8 characters long
  • Contain at least one letter, one number, and one special character (e.g. !, @, #, $, etc.)
  • Not be part of an online data leak
    • We use Have I Been Pwned to securely check your password, without sending us your actual password to their servers. See here for more information.

Step 2: Create a Ticket with Viewpoint Support Requesting Permissions

If you are using a hosted (cloud) version of Viewpoint Vista, you will need to open a case with Viewpoint Customer Support to add Agave's static IP addresses to your Vista TLS Database Endpoint IP whitelist:

  1. Go to https://support.viewpoint.com/s/

  2. Log in to your Customer Support account.

  3. Select My Resources, then Submit a Case.

Company Tools

  1. Select Support, then Systems/IT.

Company Tools

  1. Under Which product are you using?, input the following and select Search Knowledge Base:
  • Product: select "Vista".
  • Version: select the version of your Vista instance (e.g. 2022 R2).
  • Module: select "Vista Server and IT Related".
  • Brief Summary: input "TLS Database Endpoint IP Whitelist".

Company Tools

  1. Scroll to the bottom of the page and press Continue to Case Creation.

  2. Under Case Create, select a Priority. Under Description, add the following:

Hi - we are looking to whitelist our IPs for TLS Database Endpoint connectivity with our Vista instance. Here are our static IPs:

  1. 13.58.14.240
  2. 18.219.160.98
  3. 3.143.37.24

Could you also let us know what the database name and port are for our instance?

We are also looking to add the following permissions for the "Agave-User" in our Vista instance. Would it be possible to confirm that the following permissions have been added for the "Agave-User" to the Viewpoint and VPAttachments databases (see below screenshot from Microsoft SQL Server Management Studio)?

  1. db_datareader
  2. db_datawriter
  3. public
  4. VCSUsers

Company Tools

  1. Press Submit.

  2. After submitting a case, you should receive a response from Viewpoint Support within 24-48 hours confirming the connection the IP addresses have been whitelisted, the name of the database name and port, and that the permissions have been applied. Make a note of the hostname (e.g. {hostname}-sql.viewpointdata.cloud) and port number since you will need to use these to make the connection.

Step 3: Notify Agave to Make the Connection

Noting your Agave Account Manager that you are ready to connect Vista to your PM System!

Migrating from Vista On-Premise to Vista Cloud

If you are migrating from Vista on-premise to Vista Cloud on a live instance that is already connected to Agave Sync, the migration process is as follows:

  1. We will disable all automatic syncs.
  2. We will connect the new Vista Cloud account separately.
  3. We will swap the Vista Cloud account to your existing configurations.
  4. We will re-enable your automatic syncs.
info

Please reach out to your Agave Account Manager to coordinate the migration. We will handle the entire process to ensure a seamless transition with no data loss.

Frequently Asked Questions

1. How does Agave handle multi-company Vista environments?

Our logic defaults to the Vista Company selected in our Agave Link component during the account-linking process (see example below). Some Vista Companies share files for certain data objects (e.g. Vendors, Customers, etc), so if the Vista instance is set up correctly then those should be shared across all of their Companies.

2. What Viewpoint Vista environments are supported?

The following Viewpoint Vista environments are supported:

EnvironmentSupported?
On Premise
Trimble Construction One (TC1)
Viewpoint One (VP1)
Vista On-premise
Vista SaaS
Viewpoint Enterprise Cloud (VEC - RDP)
Viewpoint For Cloud (VFC)✅*

* If your customer is on Viewpoint for Cloud, we need to perform a manual setup before they can connect their database. Please contact us for more information.