Microsoft SQL Server Connecteur
Connect Microsoft SQL Server databases to OnPremiseAgent for natural-language querying, automated report generation, and real-time monitoring. Full support for Windows Authentication, Azure SQL, and SQL Server on Linux. Agents understand T-SQL syntax, stored procedures, and views to generate accurate queries.
Service AccountToken
Authentification
Service Account, Token
Catégorie
Données et stockage
Compatibilité
SQL Server 2016+, Azure SQL, SQL Server on Linux
Niveau
Disponible
Des capacités conçues sur mesure
Tout ce dont vous avez besoin pour intégrer Microsoft SQL Server à vos workflows d'agents on-premise.
T-SQL Generation
Agents generate optimized T-SQL queries from natural language, respecting SQL Server-specific syntax and features.
Windows Authentication
Support for Windows Integrated Authentication and Active Directory authentication for seamless enterprise integration.
Stored Procedure Access
Agents can discover and execute stored procedures, passing parameters based on natural language instructions.
Real-Time Monitoring
Monitor query performance, blocking, and resource utilization with AI-powered anomaly detection.
01
Create Login
Create a SQL Server login with db_datareader role on the databases your agents need to query.
01
Avantages clés
Pourquoi les entreprises choisissent ce connecteur
- Native Windows Authentication support for enterprise environments
- T-SQL-optimized query generation
- Support for SQL Server 2016+ and Azure SQL Database
- Cross-database querying for complex enterprise schemas
- Compatible with Always Encrypted and TDE
01
Financial Reporting
Generate financial reports from SQL Server data warehouses with natural language, meeting SOX compliance requirements.
02
Legacy System Access
Give modern AI capabilities to legacy applications backed by SQL Server without modifying existing systems.
03
Cross-Database Analytics
Query across multiple SQL Server databases in a single natural-language request for comprehensive analysis.
Questions fréquentes
Does this support Azure SQL Database?
Yes. Both Azure SQL Database and Azure SQL Managed Instance are fully supported with AAD authentication.
Can agents call stored procedures?
Yes. Agents can discover stored procedures, understand their parameters, and execute them based on natural language instructions — with explicit permission controls.
Fonctionne parfaitement avec
Associez Microsoft SQL Server à ces connecteurs pour une stack d'intégration complète.
Prêt à connecter Microsoft SQL Server?
Déployez sur votre propre infrastructure avec une souveraineté totale des données. Lancez-vous en quelques minutes.