Salesforce Plugin

The Salesforce plugin allows AppSynergy to easily read and write data in Salesforce.

This means you can use AppSynergy to build custom business systems that easily pull key data from Salesforce for integration purposes. Importantly, changes to that data can easily be pushed back to Salesforce in real time.

Typical use cases include using AppSynergy to build integration apps that automate business process that span sales, support, project management, invoicing, collection, and other activities without needing to rekey data into multiple systems. All in single, easy to use application so that your team is more productive and not wasting their time copying and pasting data between multiple applications.

Features

• Live Data. The plugin enables the reading and writing of live data. An update to a federated table connected to Salesforce means the data in Salesforce is changed immediately. Difficult syncing issues are therefore largely eliminated at the source.
• SQL Interface. The plugin translates MariaDB SQL to the appropriate underlying API calls to the remote system. This means you can work (and think) in SQL without worrying about as many of the implementation details.
• Caching. You can enable query caching to improve the performance of a slow remote system. The cache can be built and refreshed automatically at periodic intervals. In addition you can refresh select portions of the cache manually with a single line of PL/SQL code.
• Over-The-Top Role Based Security. If the remote system has limited security features you can apply more granular security over-the-top using AppSynergy Security Roles. Our Security Roles enable control of select/insert/update/delete right down to the table/column/record level. This enables different users assigned to different roles to have differing access permissions even if the remote system doesn't provide such capability.

Specifications

• Full read/write capability limited only by the capabilities and/or permissions of the remote system.
• Full-featured and consistent SQL access to all supported data end points.
• Codeless integration for reporting and dashboards.
• Codeless integration for building applications that update Salesforce data.
• Full support for Salesforce metadata discovery and automatic datatype mapping.
• Includes enterprise-class security features such as TLS/SSL data encryption for all client-server communications.