Microsoft SQL

Cloud + On-Premise Driver

Connect IOTA to a variety of SQL databases (Microsoft SQL Server, Oracle, PostgreSQL, MySQL, Databricks) to efficiently query and manipulate both time-series and relational data. Advanced query customization enables precise data filtration and transformation, complemented by the ability to visualize complex asset hierarchies and write back to databases, ensuring data integrity and flexibility.

The generic SQL Driver provides connectivity between IOTA and SQL servers. The driver is stateless, meaning it doesn't maintain source connections or data caches. A single generic SQL Driver service can support multiple connections to different SQL servers. The driver supports the following object types:

IOTA Type Supported? Source Type
Tag 🟢 Data table
Asset 🟢 Data table
Visit site