The Riva On-Premise server supports data synchronization with SuiteCRM On-Premise. This article describes how to prepare a SuiteCRM server and the Riva server, to support a Riva impersonation connection to SuiteCRM.
To prepare SuiteCRM for Riva:
The Riva server can be installed on any Windows system that meets the system requirements; 32-bit Windows is preferred.
Note: Installing Riva on the Windows server that hosts the SuiteCRM server is not recommended.
Confirm that you can log in to the SuiteCRM application through a web browser by using an administrator-level account.
The Riva On-Premise server supports the latest release of SuiteCRM On-Premise.
Up to three preparations and performance-tuning improvements may be required for on-premise and independent SuiteCRM service providers:
Riva requires user impersonation access through an administrator-level account to access the target user CRM accounts. By default, SuiteCRM Community Edition does not install this support. See How to configure "user impersonation" support for Sugar Community Edition and SuiteCRM.
When Riva server attempts to sync multiple target users concurrently, it can create many Apache instances on the SuiteCRM host server that use most of the available memory. For six tips that can greatly reduce the impact of memory usage, see Performance Tuning: Sugar ... SuiteCRM.
Another best practice on host Apache servers is to adjust the maximum number of worker processes to match the amount of memory available on the server. For more information, see Recommendations for performance tuning and resource planning for CRM hosted on LAMP/WAMP.
The Riva connection to the target CRM must be configured to use the credentials of an administrator-level account. For SuiteCRM, choose one of the following options:
The administrator account provides the privileges necessary to impersonate each target user and make the necessary changes to records in the CRM for each target user.
Two configurations must be confirmed to enable the target users:
4.1: Configure the correct primary email address value
The Riva server attempts to match the primary SMTP email address of each target user's email account to the primary email address value of the corresponding target user in SuiteCRM. Ensure that for each user, the email address values from the email system and SuiteCRM are identical.
4:2: Enable sufficient access permissions
The Riva connection to SuiteCRM uses the Enterprise Impersonation Model: When Riva creates new items in the CRM, it assigns ownership to the "target user". Since Riva is now acting on behalf of the target user, all audit fields in the CRM record the target user as the user that created and modified the item. Riva uses the permissions of the CRM target user to create and modify items and data in the CRM.
If the access permissions defined for the target user are not sufficient, the Riva server displays Access denied errors for each data change it tries to synchronize. Ensure that for each target user, permissions are assigned to create, modify, delete, import, and export datatypes that Riva will attempt to sync for that user. For more information, see Sugar Access Denied errors explained.
For SuiteCRM, Riva uses a Sugar connection. Gather the following information:
That information will be required when you create the Riva connection to the target SuiteCRM system.