How to Setup a User so Ryvit can Access your Sage 300 CRE Database

Once you've installed the RyvitAgent, you'll need to follow these steps to grant Ryvit access to your Sage 300CRE database.

Installation Prerequisites

  • Microsoft .NET Version 4.6.2 must be installed on the system to host the connect service
  • The Timberline ODBC driver must be installed on the system to host the RyvitAgent
  • Local system administrative permissions will be needed to complete the setup
  • Sage Version 18+

Setting up Your Sage 300 User for Ryvit

  1. In Sage, navigate to Options > Security Administration

    Sage > Options > Security Administration
  2. Select “User Setup”

    Security Administration > User Setup
  3. Select “Add” to create a new user
    1. Create a user called “RyvitServiceUser
    2. Under Settings > Set initial password.
      Please do not include special characters in the password – limit to numbers and letters
    3. Uncheck “User must change password at next logon” 
    4. Check “Password never expires"

      User Setup
  4. Note the username and password, take a screenshot of the page, and send it to Ryvit.
  5. Under Roles >  Verify the user selected is the same one created in step #1.
    • Check the “ODBC Service User” option to apply this role to the user.

      User Setup > Roles > ODBC Service User
  6. Under Companies > Check the appropriate box to ensure the user has access to your company data file.

    Companies > Grant Access to Appropriate Companies

    If your company has enabled Security Permissions at the Company, File, or Record level, please ensure that the RyvitServiceUser is granted access to all necessary Roles or Security IDs. Without adequate security permissions, Ryvit will be unable to access some data.

    That's it! If you have any questions or encounter any issues, please don't hesitate to reach out to for assistance.

      Appendix: Connector App FAQs

      How does Ryvit connect to an on-prem application hosted internally behind a firewall?

      • Ryvit’s Connector App is a lightweight Windows service that gets installed in your environment 
      • Installation steps are intuitive and quick 
      • The app communicates via the HTTPS protocol to ensure that all traffic is secure, encrypted, and authorized 
      • Network access to the target system/database installation

      How does the Connector App work? 

      • It leverages Ryvit’s internal API that enables a secure and private authorization mechanism for an added security layer 
      • Simply acts as a broker between the target system and the Ryvit cloud platform, packaging data into secure packets that are unpacked and processed within the cloud system
      • Monitoring, auto-update and management features built in for to reduce impact, maintenance and support burden on your team
      • Continuously maintains the integrity of both systems you are looking to integrate