Ask your SQL Server database about sales, stock and customers.
Adea will read the tables you allow with a login that can only read, and answer in plain words with the query shown next to each answer.
Microsoft SQL Server can't be connected yet
What Adea reads from Microsoft SQL Server
- Tables and views in the databases you allow
- Orders, invoices and customers as your system stores them
- Counts and totals, read with plain SELECT queries
- A read replica or reporting copy, where you have one
When it works
We're not ready to read from Microsoft SQL Server yet. Tell us you need it and we'll write to you the day it works.
Tell us you need itWhat you can ask
What was gross margin by product group last quarter?
Overall 41.2 percent. Accessories led at 58 percent on €96,400 in sales, while bikes sat at 33 percent on €412,000.
How many open orders are older than 14 days?
87 open orders, worth €31,950. 23 of them wait for the same supplier.
Questions about Microsoft SQL Server
What does Adea need to connect?
A SQL Server login with read rights only, on the databases you choose.
Can Adea write to my system?
No. It only reads, and it never changes data or structure.
Who sees customer details?
Only the people in your Adea workspace you give access to. What is shown follows the access you set.
