How to Setup Your Viewpoint Vista SQL User for the RyvitAgent

If you're in the process of establishing connectivity between Viewpoint and Ryvit, this will come in handy.

Please note: If the Ryvit 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 RyvitServiceUser will require access to both databases.

Creating a Ryvit 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 ‘RyvitServiceUser’
    • 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

      Screen Shot 2021-05-04 at 2.48.16 PM
  3. Navigate to the User Mapping page to grant the RyvitServiceUser with database Read/Write permissions for your Viewpoint database
    • Select your Viewpoint database
    • Grant the user the following permissions:
      • db_datareader
      • db_datawriter
      • public
      • VCSUsers

        Screen Shot 2021-05-04 at 2.49.28 PM
  4. Click OK.

Authorizing the new ‘RyvitServiceUser’ SQL User for the Vista Attachments database.

  1. Confirm whether or not your setup leverages a separate Vista Attachments database
    • Open Vista Application DM Attachment Options

      Screen Shot 2021-05-04 at 2.51.59 PM
    • If the 'File System' option is selected, then you do not have a separate Vista Attachments database. You can skip to Configuring the Vista Application User.
    • If the 'Database' option is selected and the name of your database is your standard Vista database (usually Viewpoint), then you do not have a separate Vista Attachments database. You can skip to Configuring the Vista Application User.
    • If the 'Database' option is selected and the name of the database is NOT your standard Vista database name, then you do have a separate Vista Attachments database. Please complete Step 2 - Setting up 'RyvitServiceUser' for your Attachments Database.
  2. Setting up ‘RyvitServiceUser’ User for your Attachments Database
    1. Execute the following SQL script in SQL Server Management Studio

      USE VPAttachments  ⬅️   Change this to your Vista Attachments Database name
      GO
      CREATE USER [RyvitServiceUser] FOR LOGIN [RyvitServiceUser]
      GO
      ALTER ROLE [db_datareader] ADD MEMBER [RyvitServiceUser]
      GO
      ALTER ROLE [db_datawriter] ADD MEMBER [RyvitServiceUser]
      GO
      GRANT EXECUTE TO RyvitServiceUser
      GO

 

Configuring the Vista Application User

Vista system access is performed through the Viewpoint Vista views and stored procedures. This aligns Ryvit's 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 = RyvitServiceUser
    • Tab out and then change the User Type to 'User Application'
      • Note: most of the form items will become disabled.
    • Full Name = Ryvit Service User
    • Save.
      Screen Shot 2021-05-04 at 3.08.54 PM
    • 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 'RyvitServiceUser'.
      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 'RyvitServiceUser'.
    • 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 RyvitAgent needs. Select the needed Data Type Security groups.
      • Note: Ryvit's filtering ensures we only pull the companies you have specified. We will not touch companies that should not be integrated.
    • Screen Shot 2021-05-04 at 3.29.25 PMClick 'OK' to add 'All Data'
    • Click the 'Save' icon on the VA User Profile form.

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

 

  • Server name
  • Database name
  • PW for the RyvitServiceUser

 

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


If you need help, please contact support@ryvit.com.