SQL Server
SQL Server
Reads the local back-office database directly — used with Verifone and
Sapient systems.Needs the server address and read access to the back-office database.
Usually the most complete and the least fuss once configured.
CSV export folder
CSV export folder
Watches a folder for the nightly export files your POS already writes.Needs the folder path, and that the POS is actually configured to write its
export every night. Good when direct database access is not available.
Local web service (REST)
Local web service (REST)
Calls a web service your POS exposes on the store network.Needs the endpoint addresses. Used where the POS offers an API rather than a
database or file drop.
What comes across
Sales transactions, and — where you sell fuel — tank readings from the automatic tank gauge, which feed the fuel reconciliation.Checking it works
After setup, wait for the first nightly sync, then:1
Check the agent shows online
On the Dashboard, under Backoffice Agent Status.
2
Check sales arrived
Sales Imports should show a run for the store.
3
Check the numbers look like a real day
A run that processed far fewer lines than you expect usually means the
connector is reading a partial export.