The DataSuite supported databases are essential for storing and analyzing machine and process data efficiently. With proper database connectivity, you can integrate production data into existing systems for reporting, analytics, or ERP/MES applications. In this article, you’ll learn which databases are supported by DataSuite and why using a database is important.
Which DataSuite Supported Databases Are Available? #
The DataSuite supported databases include:
- Microsoft SQL Server (MSSQL)
Supported from version 2012 or higher - MySQL
Supported from version 5 - MariaDB
Supported from version 10.2 - PostgreSQL
Supported from version 9.6
These database systems provide the foundation for reliable and structured data storage when using DataSuite.
Important Notes on Database Connectivity in DataSuite #
- DataSuite connects only to existing databases.
- It is not possible to create new databases, tables, or views within DataSuite.
- Proper read and write permissions are required for access.
- Ensure correct network and firewall settings for a stable and secure connection.
Why Not Just Use Excel? Advantages of DataSuite Supported Databases #
DataSuite also allows writing data to Excel files, which can be sufficient for small-scale use cases.
However, as data grows, Excel has clear limitations:
- Files become very large and difficult to handle
- Performance drops significantly when opening or editing
- No central management or multi-user access
A relational database, on the other hand, offers:
- Long-term storage for large volumes of data
- Fast queries for reporting and analysis
- Integration with ERP and MES systems
Best Practice Tip #
If no database is currently installed, we recommend setting up a central SQL database, such as Microsoft SQL Server Express for smaller scenarios.
Need assistance with setup?
Our team can handle the installation and configuration of your database as a service. Contact us for details.
