Microsoft SQL Server Database Query
Microsoft SQL SmartConnector
Create EWS Objects from specific SQL Queries allowing data to be displayed in EBO.
Part Number: ISCINT00200
Product Features
Features and Benefits
Enables a user to configure one or more queries against an SQL Server Instance.
The results of the query are automatically arranged into value items which can be consumed to represent values of the SQL Server in an EWS Client.
The Interface supports multiple queries which are summarised in container items at a configured query refresh interval.
• EWS Integration
• Microsoft SQL Integration
• Supports multiple T-SQL Queries
• Supports Stored Procedure Execution
• Group results into EWS containers
• Automatic detection of data types for EWS
System Requirements
Supported Operating Systems
The following is a list of Operating Systems which the SmartConnector framework has been tested against. Non-listed operating systems capable of running .NET 4.5 should also work but their compatibility has not been verified.
• Windows 10 64 bit.
• Windows Server 2012 64 bit.
• Windows Server 2016 64 bit.
• Windows Server 2019 64 bit.
• Windows Server 2022 64 bit.
Supported Database Servers
The following is a list of Microsoft SQL Servers which SmartConnector has been tested against. Non-listed servers compliant with Microsoft SQL Server may also work but their compatibility is not guaranteed.
• Local DB.
• Microsoft SQL Server 2012 Express or greater.
• Microsoft SQL Server 2012 or greater.