In our partner network, we also realize your application. Please contact us!
We will find the right solution for your project with you!
Easy integration with SQL databases
Server application for secure, worldwide and direct connection of Pro Series controllers to SQL databases
Home » Soft-& Middleware » SQL Connector
The SQL Connector allows our Pro Series controllers to communicate directly with SQL databases (MS SQL Server, MySQL, Postgres). Arbitrary data can be securely written to SQL databases via mobile networks and further processed from there. An information query from SQL databases (query), e.g. to query configuration data, is supported as well as the complete range of the language.
The SQL Connector allows the controllers of Pro Series to communicate directly with databases, just like normal applications or users. The entire SQL language range is available, of course only within the scope of the rights granted. For the company IT this means that the data of the controllers is stored in the proven and well controllable environment of corporate IT. The costly detour via IoT portals (clouds) or special application software for communication can be avoided.
The access rights of the Pro Controllers to the databases are regulated, as for any other application, with the proven mechanisms of the databases and are therefore very finely adjustable. The management of the access rights of the Pro Controllers is thus seamlessly integrated into the proven approaches in the company. Communication is always encrypted (AES) and with further authentication at the SQL Connector (or Communication Hub).
The SQL Connector uses proven IT methods and tools. Its “slim” design enables high transaction rates, assuming appropriate database performance. The SQL Connector is scalable via databases and users.
The SQL Connector is the “direct” way into your company IT. Other ways, e.g. via cloud services (IoT platforms) are usually billed via data points and per date transmitted. Especially when scaling an application, astonishing costs can arise which endanger the economic efficiency. The SQL-Connector is available at a low price per lifetime license. You can also use the SQL Connector “out of the box”, only a basic configuration (databases) is required. Costly special programming is not necessary.
If you need further information: Have a look at the manual offered in the downloads or simply contact us.
Figure 1: Network diagram SQL Connector (preferred variant)
Pictograms: OSA / CC By SA 3.0
Figure 2: Network diagram SQL Connector (for small installations)
Tempowerkring 19 D-21079 Hamburg
Thank you very much
Thank you for taking the time to read this page to the end. If you’ve made it this far, you might like the way we work: We develop our products with great attention to detail and provide support throughout their entire life cycle. If you like, talk to us. We look forward to hearing from you!
© Infranet Technologies GmbH