Accounting data for an AI agent and reports
A services company with its own data analytics team.
What we did
- We created separate views with only the data needed: accounting entries and reference lists, no employee data.
- We set up a read-only account that can see only those views.
- We launched an automatic transfer: a full load every night and on demand every few minutes, notifying the agent's system after every run.
Security
Connection encrypted with an SSH tunnel and TLS with server certificate verification. A separate service account on the server, a key with no shell access, the database port not reachable from the internet, and the machine covered by backups.

