Open Automation Software
Liberate your Industry 4.0 data with Open Automation Software IIoT platform for Windows and Linux. OAS is truly an unlimited IoT Gateway for Windows, Linux, Raspberry Pi 4, Windows IoT Core, and Docker deployments.
Create HMI visualization for web, WPF, and WinForm C# and VB .NET applications.
Log data and alarms to SQL Server, Oracle, MS Access, MySQL, Azure SQL, PostgreSQL, Cassandra, MongoDB, MariaDB, SQLite, InfluxDB, and CSV files.
MQTT Broker and Client interface along with cloud connectivity to Azure IoT and AWS IoT Gateway.
Read and write data from remote Excel Workbooks.
Alarm notification to email, SMS text, and voice messaging.
.NET and REST API programmatic access.
Allen Bradley ControlLogix, CompactLogix, GuardLogix, Micro800, MicroLogix, SLC 500, and PLC-5.
Siemens S7-200, S7-300, S7-400, S7-1200, and S7-1500.
Modbus TCP, Modbus RTU, and Modbus ASCII for Master and Slave communications.
OPTO-22, MTConnect, and OPC UA, OPC DA.
Learn more
Luna Modeler
Luna Modeler is an easy-to-use data modeling tool for your favorite databases.
Design and visualize database structures, generate SQL scripts, and create interactive documentation.
Perfect for both pros and beginners, Luna Modeler makes data modeling simple!
Supported platforms:
- Oracle Database
- SQL Server
- PostgreSQL
- Supabase
- NeonDB
- MySQL
- MariaDB
- SQLite
Key features:
- Database modeling and design
- Reverse engineering from Oracle, SQL Server, PostgreSQL, MySQL, MariaDB
- Import from SQLite files
- Support for SSH/SSL/TLS connections
- Generation of interactive HTML reports
- Generation of SQL scripts
- Project update
- Generation of alter scripts for selected database platforms
- Various themes and styles for reports
- Multiple display modes
- Support for sub-diagrams
- Headless CLI
- Folder based format for team collaboration
- Navigator for easy schema exploration
Learn more
Sequelize
Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite SQL Server, and more. Features solid transaction support, relations, eager and lazy loading, read replication, and more. Define your models with ease and make optional use of automatic database synchronization. Define associations between models and let Sequelize handle the heavy lifting. Mark data as deleted instead of removing it once and for all from the database. Transactions, migrations, strong typing, JSON querying, lifecycle events (hooks), and more. Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite, Microsoft SQL Server, Oracle Database, Amazon Redshift, and Snowflake’s Data Cloud. It features solid transaction support, relations, eager and lazy loading, read replication, and more. To connect to the database, you must create a Sequelize instance.
Learn more
HeidiSQL
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide. Free for everyone, OpenSource. Connect to multiple servers in one window. Supported database systems: MariaDB, MySQL, MS SQL, PostgreSQL and SQLite. Connect to servers via commandline. Connect via SSH tunnel, or pass SSL settings. Create and edit tables, views, stored routines, triggers and scheduled events. Generate nice SQL-exports, compress these afterwards, or put them on the clipboard. Export from one server/database directly to another server/database. Manage user-privileges, import text-files, export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array. Browse and edit table-data using a comfortable grid.
Learn more