Microsoft SQL Server
With a read-only account and the system views.
- How it connects
- Lindero connects from your server. Keys and relationships come from the system views (sys.*), not from guesses. Reads run in a separate process, and there is an optional native reader written in Rust.
- What it reads
- Tables, views, keys, relationships and procedures. When rows need counting, the database counts them itself and returns only the number.
- Which account it needs
- A SQL Server user with SELECT permission. If you want it to read stored procedures, EXECUTE as well: without it, SQL Server hides them and none appear, with no error.
- Can it write?
- No. Lindero never writes to a program's database.
More Databases connectors
All connectors
Shall we connect it in your company?
We tell you what your case needs and leave it running on your server.