+
+

Related Products

  • HiveMQ
    92 Ratings
    Visit Website
  • Files.com
    338 Ratings
    Visit Website
  • DbVisualizer
    593 Ratings
    Visit Website
  • OptiSigns
    8,462 Ratings
    Visit Website
  • Thinfinity Workspace
    16 Ratings
    Visit Website
  • SuperOps
    295 Ratings
    Visit Website
  • pCloud Business
    189 Ratings
    Visit Website
  • MicroStation
    593 Ratings
    Visit Website
  • ManageEngine Endpoint Central
    3,347 Ratings
    Visit Website
  • 3CX
    1,237 Ratings
    Visit Website

About

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.

About

A simple and lightweight SQL client desktop/terminal with cross-database and platform support. A desktop application with a simple interface. Sign and notarize builds for macOS. Supports PostgreSQL and MySQL. Sqlectronhas also has a GUI interface called sqlectron-gui. Most of the time you should not worry about files, because Sqlectron will manage the configuration for you. The paging is not done in SQL query, instead, it is done during the results rendering. Supports PostgreSQL, Redshift, MySQL, MariaDB, Microsoft SQL Server, Cassandra, and SQLite.Although it is possible to change files manually, it is usually better to just use the UI since it allows you to change any of the settings from there.

Platforms Supported

Windows Supported
Mac Not Supported
Linux Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Supported
iPad Supported
Android Supported
Chromebook Not Supported

Platforms Supported

Windows Supported
Mac Supported
Linux Supported
Cloud Not Supported
On-Premises Not Supported
iPhone Not Supported
iPad Not Supported
Android Not Supported
Chromebook Not Supported

Audience

Industrial experts looking for a computing platform for automated systems to customers worldwide

Audience

Anyone interested in a tool to manage servers, list databases, list tables, and execute query

Support

Phone Support Supported
24/7 Live Support Supported
Online Supported

Support

Phone Support Not Supported
24/7 Live Support Not Supported
Online Supported

API

Offers API Supported

API

Offers API Not Supported

Screenshots and Videos

Screenshots and Videos

Pricing

$495 one-time payment
Perpetual license with unlimited clients per licensed server.
Free Version Not Supported
Free Trial Supported

Pricing

Free
Free Version Supported
Free Trial Not Supported

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.5 / 5
support 5.0 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Pros & Cons from Real Users

Pros

  • Open architecture. Maximum flexibility for customization. Support is the absolute best. Flexible deployment solutions.
  • Open automation has the best customer service by far over their competition. They have an excellent product. From real time data to data logging, data retrieval and writing to PLC's. Alarms, Alarm notification, report generation and email capabilities. With the tags and tag properties the options to construct anything with the data is as unlimited as the users abilities and imagination.

Cons

  • I don't really have any cons. The product works exactly how I need it to.
  • I have been using this product suite for 15+ years. The software is well maintained. There are continual enhancements and upgrades. The configurations have always been backward compatible when upgrading. Not really a con but staying up to date is good to do.

Training

Documentation Supported
Webinars Not Supported
Live Online Supported
In Person Not Supported

Training

Documentation Supported
Webinars Not Supported
Live Online Not Supported
In Person Not Supported

Company Information

Open Automation Software
Founded: 1993
United States
openautomationsoftware.com

Company Information

Sqlectron
sqlectron.github.io

Alternatives

QuickHMI

QuickHMI

Indi.An GmbH

Alternatives

TablePlus

TablePlus

TablePlus InC
Winlog

Winlog

Sielco Sistemi srl
ControlLogix SIL 2

ControlLogix SIL 2

Rockwell Automation
DBeaver Community

DBeaver Community

DBeaver Corp.
Fernhill SCADA

Fernhill SCADA

Fernhill Software
FactoryTalk Logix Echo

FactoryTalk Logix Echo

Rockwell Automation
SQLGate

SQLGate

CHEQUER

Categories

Data Visualization Supported
ERP Supported
IoT Supported
Message Queue Supported
MQTT Brokers Supported
SCADA Supported

Categories

Data Visualization Features

Analytics Supported
Content Management Supported
Dashboard Creation Supported
Filtered Views Supported
OLAP Supported
Relational Display Supported
Simulation Models Supported
Visual Discovery Supported

ERP Features

Accounting Integration Not Supported
Accounting Management Not Supported
CRM Not Supported
Dashboard Supported
Distribution Management Not Supported
Enterprise Asset Management Supported
Financial Management Not Supported
HR Management Not Supported
Inventory Management Supported
Order Management Not Supported
Project Management Not Supported
Purchase Order Management Not Supported
Purchasing Not Supported
Reporting/Analytics Not Supported
Sales Management Not Supported
Supply Chain Management Supported
Warehouse Management Supported

IoT Features

Application Development Supported
Big Data Analytics Supported
Configuration Management Supported
Connectivity Management Supported
Data Collection Supported
Data Management Supported
Device Management Not Supported
Performance Management Supported
Prototyping Supported
Visualization Supported

SCADA Features

Alarm Management Supported
Archiving & Retention Supported
Dashboard Designer Supported
Data Aggregation Supported
Data Visualization Supported
Hardware Integration Not Supported
HMI Integration Supported
Real-time Monitoring Supported

Integrations

MariaDB Supported
MySQL Supported
PostgreSQL Supported
SQL Server Supported
SQLite Supported
Amazon Redshift Not Supported
Apache Cassandra Not Supported
Azure SQL Database Supported
NoSQL Not Supported
Oracle Database Supported
Visual Studio Supported

Integrations

MariaDB Supported
MySQL Supported
PostgreSQL Supported
SQL Server Supported
SQLite Supported
Amazon Redshift Supported
Apache Cassandra Supported
Azure SQL Database Not Supported
NoSQL Supported
Oracle Database Not Supported
Visual Studio Not Supported
Claim Open Automation Software and update features and information
Claim Open Automation Software and update features and information
Claim Sqlectron and update features and information
Claim Sqlectron and update features and information