Skip to main content

Advanced transforms

Section

Description

Concepts

This section describes what transforms are and the different types that FairCom provides.

Siemens UDT to JSON transform

FairCom Edge has a Siemens UDT service that can convert that binary serialized UDT data to JSON, using a schema that describes the format of the original user-defined type.

JSON to table transform

This section details use cases, concepts, tutorials, and the API reference for a JSON-to-table transformation.

Table to JSON transform

This section details use cases, concepts, tutorials, and the API reference for a table-to-JSON transformation.

Message Queueing Telemetry Transport (MQTT) is the Internet standard protocol for publishing and subscribing to messages that are sent to topics on an MQTT broker (see MQTT.org for more information).

Open Platform Communications Unified Architecture (OPC UA) is a machine-to-machine communication protocol for industrial automation. OPC UA is the latest, easiest, and most robust protocol from the OPC Foundation.

The FairCom Edgeprovides a connector to OPC UA to bridge data from OPC UA devices to other protocols, including MQTT, JSON, and SQL.

Modbus is a binary server/client communication protocol developed and published by Modicon for transmitting data to and from electronic devices over a serial bus or TCP/IP network.

Structured Query Language (SQL) is a standardized programming language that is used to manage relational databases and perform various operations on the data in them.

FairCom's SQL engine is ANSI compliant and has almost all SQL features up through the SQL:2003 standard.

The JSON DB API uses JSON over HTTP to manage databases, tables, indexes, records, queries, cursors, and transactions. It is available in all FairCom products.

This API is part of FairCom's family of JSON APIs.

The Internet is a global network of networks that allows computers to communicate with each other. This is possible because it defines a standard set of communication protocols.

reformattingreshapingenriching

Programmable Logic Controller (PLC) is an industrial computer with electrical inputs and outputs that has been ruggedized and adapted for the control of manufacturing processes, such as assembly lines, machines, robotic devices, or any activity that requires high reliability, ease of programming, and process fault diagnosis.

User Defined Type (UDT) is a user-defined data structure in a programming language, such as C, C++, Java, etc.

FairCom Edge provides an advanced transform that can take native binary user-defined types in a Siemens PLC and convert them into JSON.

ETL stands for Extract, Transform, and Load. This technique is widely used in data engineering and business intelligence to extract data from a database, transform that data, and load it into another database (typically a SQL data warehouse or a data lake). A variation of ETL is ELT where data is extracted from one database, loaded into another database, and transformed in the target database. There are many mature ETL software tools that perform this operation with little-to-no code.

All major ETL and ELT tools are compatible with FairCom DB through its built-in ODBC and JDBC drivers. FairCom DB can be the source or target of ETL and ELT operations.