MSSQL is the protocol used to connect to Microsoft’s SQL Server.
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications, which may run either on the same computer or on another computer across a network.
The Connectware MSSQL protocol enables reading from or writing to a database on the database server. With the Connectware MSSQL protocol, it is possible to establish connections to all network reachable databases – no matter whether they are in the cloud or on-premises.
Data can be read with the help of predefined queries. The queries are highly flexible to use when combined with variables that act as placeholders and are replaced at runtime. By displaying the requested data in JSON format, the data can be conveniently processed and easily transferred to other systems.
While read accesses take place at defined points in time or in a certain interval, write accesses are carried out immediately. As with reading access, writing to a database is performed by specifying a query which will then be enriched with payload at runtime.
Almost every use case relies on the ability to store and retrieve data – using the Connectware MSSQL protocol implementation, this can seamlessly be achieved without having to modify the database at all.
- Energy Monitoring
- Predictive Maintenance
- Read more about the MSSQL protocol implementation in Cybus Documentation
About Cybus Connectware
Cybus Connectware is the IIoT Edge Application platform made in Germany.
Cybus Connectware provides smart factories with universal connectivity to edge devices, sensors and machines, with on-premises pre-processing and effective data governance.
IT departments use Cybus Connectware as a layer of security and orchestration to selectively provide IIoT services and applications, local or cloud, with just the data that is required. Under the hood, Connectware serves the OT as unified on-premises hub to connect any type of machine, device or sensor. It buffers, converts and pre-processes data locally. A transparent expert system that offers industry best practices and DevOps for quality assurance, workflows and automation, are easy to adopt and limitless to extend.
With Cybus Connectware, the data producer stays in control and can securely leverage IIoT use cases of any scope and size, single or many in parallel. It means agility and versatility to win the IIoT era.