CONNECTIVITY PORTFOLIO | SQL

SQL

What is SQL?

SQL (Structured Query Language) is the protocol used to connect and interact with relational databases like MySQL, MariaDB, PostgreSQL and so on. Relational databases are very popular and most often used to handle structured data with predefined relationships between them. The data is organized in tables and can be accessed using queries with different levels of complexity. 

What is SQL used for?

Using the Connectware SQL protocol, it is possible to establish connections to all network reachable databases, no matter if they are in the cloud or on premise. Data can be read using 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.

SQL implementation with Cybus

Almost every use case relies on the ability to store and retrieve data – using the Connectware SQL protocol implementation, this can seamlessly be achieved without having to modify the database at all.

Application examples

Use Cases with SQL

  • Traceability
  • Energy Monitoring
  • Predictive Maintenance
Learn more about industry protocols

Learn More

About the protocol

CYBUS CONNECTWARE

Scalable data infrastructure for the Smart Factory

Holistic factory connectivity with one single platform

The leading Manufacturing Data Platform Connectware is suitable for the first steps of digitization up to the Smart Factory transformation. In addition to universal shopfloor connectivity, Connectware creates a scalable data infrastructure for digital projects without limits. One single platform for all IIoT projects, independent of applications and vendors.

Connect and implement your whole shop floor

Your direct contact

Would you like to discover what you can achieve with Cybus
Connectware in your factory? We are happy to discuss how you will realize your digital projects efficiently and quickly.

sales manager

Lukas Theilacker

Book an appointment

Klicken Sie auf den unteren Button, um den Inhalt von lukastheilacker-cybus.zohobookings.eu zu laden.

Inhalt laden

Ihr Browser unterstützt diese Webseite nicht.

Liebe Besucher:innen, Sie versuchen unsere Website über den Internet Explorer zu besuchen. Der Support für diesen Browser wurde durch den Hersteller eingestellt, weshalb er moderne Webseiten nicht mehr richtig darstellen kann.
Um die Inhalte dieser Website korrekt anzeigen zu können, benötigen Sie einen modernen Browser.

Unter folgenden Links finden Sie Browser, für die unsere Webseite optimiert wurde:

Google Chrome Browser herunterladen Mozilla Firefox Browser herunterladen

Sie können diese Website trotzdem anzeigen lassen, müssen aber mit erheblichen Einschränkungen rechnen.

Diese Website trotzdem anzeigen.