Shopify Plugin

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

For example, you might build a custom order management system in AppSynergy that reads the latest order data directly from Shopify, and updates inventory and shipping data in Shopify as a result of your warehouse operations.

Features

Live Data. The plugin enables the reading and writing of live data. An update to a federated table connected to Shopify means the data in Shopify is changed immediately. Thorny syncing issues are therefore largely eliminated.
Transforms APIs into Database Tables. The plugin translates MariaDB SQL to the appropriate underlying API calls to the remote system. This means you can work with SQL rather than worry about API implementation details.
Role Based Security. Even if the remote system has limited security features you can apply more granular security over-the-top using AppSynergy's 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.
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.