« API and Interfaces (Cloud) » : différence entre les versions
Aucun résumé des modifications |
|||
| Ligne 2 : | Ligne 2 : | ||
==Overview== | ==Overview== | ||
==Import Queues== | |||
==Export Queues== | |||
==Sync Agent== | |||
The Sync agent is Windows Service which can be deploy on client infrastructure. | The Sync agent is Windows Service which can be deploy on client infrastructure. | ||
==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. | 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. | ||
| Ligne 19 : | Ligne 19 : | ||
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. | 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. | ||
==REST API== | |||
[[Category:Cloud]] | [[Category:Cloud]] | ||
[[Category:Architecture]] | [[Category:Architecture]] | ||
Version du 27 février 2017 à 10:27
Overview
Import Queues
Export Queues
Sync Agent
The Sync agent is Windows Service which can be deploy on client infrastructure.
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.