What you can do with Microsoft SQL Server in Sylus
Sylus gives teams on the Microsoft data stack an AI data analyst for SQL Server. Ask "What were sales by branch last quarter?" or "Which suppliers had the most late deliveries?" and get answers, charts, and dashboards, with the SQL shown for review.
How the Microsoft SQL Server integration works
Sylus connects with a SQL Server connection string and a login that has read-only access, such as membership of the db_datareader role. It works with on-premises SQL Server, Azure SQL Database, and Azure SQL Managed Instance, and queries only the databases and objects you select.
How to connect Microsoft SQL Server to Sylus
You need a SQL Server login that can create logins, or a DBA who can create one for you.
Create a login and database user for Sylus, then add it to the
db_datareaderrole on the databases you want to analyze.In Sylus, add Microsoft SQL Server as a data source, paste the connection string, and test the connection.
Select the databases, schemas, tables, and views to include.
Connection string format: Server=host,1433;Database=dbname;User Id=user;Password=password;
