An integration with an ERP / accounting system that is locally hosted (either on a server that is situated at your premises or on a cloud-based server) will require our software to be installed.
Before we can communicate with your on-premise ERP / Accounting system, you need to install our S2S agent on the server where your ERP / Accounting system is hosted. Below are the steps to get started with downloading and installing the S2S agent:
The below must be taken into consideration to ensure we can manage information on a continual basis:
Stock2Shop Agent is a lightweight client designed to facilitate the synchronization of modified data for integration purposes, encompassing functions such as polling, auditing, and ensuring secure data transmission. While the optimal scenario involves installation on the server housing the database, we recognize that organizational policies may necessitate alternative approaches to uphold security standards.
The S2S agent can be installed on an application server within the same network as the SQL server. This configuration enables seamless communication with the database while mitigating performance concerns by running the client on a distinct machine. Our agent requires Read Only access to the database.
Regardless of the deployment location, SQL user access can be tailored to adhere to specific security requirements. By confining access to designated databases or tables, and enforcing read-only permissions with SELECT operations exclusively. Additionally the agent can be restricted to specific sql views or tables.
Establishing a duplicate database(Replica) offers an alternative solution, providing a cloned environment for integration with the S2S agent which can then be off premise.