API and Interfaces (Cloud)

Sync Agent

The Sync Agent (SA) is a Windows Service which can be deployed on the client infrastructure.

The role of the SA is to realize the interface between the Client Infrastructure and the Cloud environment. The SA is part of the MOM Architecture.

• For the upload side

The SA monitors a set of directories. When a new file is created inside a monitored directory, the SA build a message based on the file extension and the configuration and posts this message and the file in a corresponding queue of the Cloud environment.

• For the download side

The SA monitors a set of configured queues of the Cloud Environment. When a message is available in a monitored queue, the SA consumes the message and download the corresponding file in a local directory depending of the message and the configuration.

Sage FRP reporting API

Sage FRP Reporting is a companion Application which is designed over Microsoft Excel. As a data oriented Application it needs to access to the production database.

Because opening the database to external accesses is not an option, a SQL proxy service has been implemented inside the the Sage FRP 1000 Service.

This SQL Proxy service authenticates both the client Application (here Sage FRP Reporting) and the client user :

• The client Application is authenticate using a SAS (Shared access signature) mechanism, similar to the SAS used on Azure services.
• The client user is authenticate as a regular Sage FRP 1000 user.

The SQL proxy implements queries parsing to limit the Client Application access, it also inject the TID filtering terms in case of a multi tenancy database.