Skip to main content

SQL connector

FairCom Edge SQL connector for databases, software, and ETL tools

Abstract

FairCom Edge provides industry-standard ODBC and JDBC SQL drivers for connecting it to databases, software, and ETL tools. All data collected by FairCom Edge is stored in its integration tables and can immediately be queried by SQL. FairCom Edge automatically takes data inserted by SQL, transforms it, and delivers to configured outputs, such as sending data to devices, sending messages to MQTT subscribers, pushing data to REST endpoints, pushing data to the cloud, etc. In other words, simply inserting a record into FairCom Edge automatically transforms and sends it to any number of integrated devices, software, and services.

FairCom Edge provides industry-standard ODBC and JDBC SQL drivers for connecting it to databases, software, and ETL tools. All data collected by FairCom Edge is stored in its integration tables and can immediately be queried by SQL. FairCom Edge automatically takes data inserted by SQL, transforms it, and delivers to configured outputs, such as sending data to devices, sending messages to MQTT subscribers, pushing data to REST endpoints, pushing data to the cloud, etc. In other words, simply inserting a record into FairCom Edge automatically transforms and sends it to any number of integrated devices, software, and services.

Section

Description

Concepts

Tutorials

The tutorials in this section are for using ODBC and JDBC.