IT-Community Sync Agent

Download

Installer (recommended)

IT-Community-Sync-Agent-Setup.exe — installs agent, service and watchdog

Portable zip

SyncAgent-<version>.zip in every release — also used by remote updates

Product site

it-community.online · Panel: mapeo.it-systems.es

What it is

A Windows Server agent that syncs on-premises SQL Server databases (IESA / Gesfincas ERP and similar) to cloud MySQL portals — securely and without opening a single inbound port on the client's server.

Local SQL Server
      │  (read-only · optional controlled write)
      ▼
IT-Community Sync Agent   ← headless Windows service (SYSTEM)
      │  Secure WebSocket (WSS · verified TLS · token)
      ▼
Relay sync-point.es       ← authenticated (X-Relay-Key)
      │
      ▼
Web portal / Mapeo        → MySQL destination · control panel

Features

Zero inbound ports — the agent only opens outbound connections; the client's firewall is untouched.

True incremental — Change Tracking / rowversion, per-table delta checkpoints; nothing unchanged is re-copied.

Genuinely headless — runs as a Scheduled Task under SYSTEM, no user session or open RDP; self-restarting watchdog included.

Cloud-managed — panel at mapeo.it-systems.es with live status, remote configuration, log viewer and write on/off.

Signed auto-update — SHA-256-verified download with automatic rollback if the new version fails to start.

Monitoring — online/offline badges and email alerts before scheduled syncs.

How to use it

1Download IT-Community-Sync-Agent-Setup-<version>.exe from the latest release.
2Run it as administrator — it installs the agent, creates the Scheduled Task (SYSTEM) and the watchdog automatically.
3When done, open agent.exe once to register credentials.
4Manual alternative: unzip to C:\Sincronizador\agent, run agent.exe to register credentials, then instalar_servicio.bat as administrator.
5From the Mapeo panel, monitor status, edit configuration and toggle remote writes.

Requirements

Windows Server (or Windows 10/11) · Access to the source SQL Server instance · Outbound HTTPS/WSS connectivity only — no inbound ports.

What's in this repository

IT-Community-Sync-Agent-Setup-<version>.exe — full installer (agent + service + watchdog)
SyncAgent-<version>.zip — portable package, also used for remote updates from the panel
SyncAgent-<version>.sha256 — checksum for verification

FAQ

Do we need to open ports or NAT on the client's firewall?

No. The agent only makes outbound WSS/TLS connections to the relay — it works behind any standard corporate firewall.

What happens if the server reboots or the agent dies?

The Scheduled Task starts it at boot and the watchdog relaunches it if it crashes; the panel flags the agent offline if it stops responding.

Can it write back to the ERP?

Writing is optional and controlled — toggled from the Mapeo panel.

Support

Product: it-community.online
Management panel: mapeo.it-systems.es