Databases
SQL Server integration
Connect Microsoft SQL Server and turn your enterprise data into dashboards built without writing T-SQL.
Flitch is an AI BI tool that connects to SQL Server and turns your tables into shareable dashboards. Flitch connects to SQL Server read-only over a standard connection string and works with your existing tables and views. Ask for sales, customer or operations dashboards in plain language, or bring your own T-SQL for the complex reports, and schedule a refresh to keep them live.
- Connect with read-only credentials
- Use any table or write custom SQL
- Schedule background refresh
How do you connect SQL Server to Flitch?
Connect securely with your database credentials. Flitch only needs read access.
Generate a dashboard
Pick a prompt to get started.
SQL Server integration FAQ
How do I connect SQL Server to Flitch?
Add SQL Server with a connection string and pick the tables you want to import. Flitch connects read-only and never writes back to your database.
Can I build SQL Server dashboards without writing queries?
Yes. Describe the dashboard in plain language and Flitch generates the charts and KPIs. Custom SQL is supported when you need it.
Does Flitch modify my SQL Server database?
No. The connection is read-only, so Flitch reads only the tables you choose and leaves your data untouched.
Which SQL Server tables can I use?
Pick any tables or provide a query. Flitch imports them as datasets and lets you build dashboards across them.
How often does the data update?
Set a scheduled background refresh and Flitch re-reads your tables so dashboards stay current.
Does Flitch copy my SQL Server data?
No. Flitch queries SQL Server where it sits and pushes the aggregation down as SQL, so it reads back totals rather than holding a copy of your tables. Nothing to keep in step, nothing extra to secure, and a large table stays your database's problem rather than something Flitch has to store. The queries are generated against your data model, so a figure means the same thing on every dashboard built from it.
More in Databases
Not the source you're after?