Easton Harvey
easton.harvey@faircom.com
Articles by Easton
-
-
Administration
FairCom MQ admin home page with links to server admi tasks
26 views Updated February 5th, 2026 -
Common Functionality
15 views Updated December 23rd, 2025 -
FairCom DB API .NET Error and Return Values
15 views Updated January 13th, 2026 -
Working With Databases
14 views Updated December 24th, 2025 -
Working with Resources
11 views Updated January 27th, 2026 -
CTTable Class
14 views Updated January 14th, 2026 -
CTNumber Class
10 views Updated January 14th, 2026 -
Working with Tables
11 views Updated January 15th, 2026 -
Error codes 17800 - 17899
FairCom SQL error codes 17800 - 17899
15 views Updated January 16th, 2026 -
Error codes 15000 - 15999
FairCom Flatfile error codes 15000 - 15999
16 views Updated January 16th, 2026 -
FairCom ISAM
FairCom ISAM documentation home
16 views Updated October 15th, 2025 -
"group"
The replication "group" object manages availability groups
15 views Updated February 11th, 2026 -
Concepts
21 views Updated February 10th, 2026 -
JSON API connector
Connect FairCom Edge to JSON API
18 views Updated January 28th, 2026 -
Fields to JSON tutorial
Tutorial to transform fields to JSON in the same table
20 views Updated October 12th, 2025 -
REST startup configuration
Enable the connection between REST and FairCom Edge
20 views Updated October 10th, 2025 -
JSON DB API tutorial
Use the FairCom Java driver for the JSON DB API to process data in the FairCom database engine
40 views Updated February 2nd, 2026 -
API Explorer
API Explorer UI tutorials
44 views Updated February 11th, 2026 -
Tutorial: MQTT client for C
Use the C MQTT client with FairCom's MQTT broker engine
37 views Updated February 5th, 2026 -
Working With Sessions
14 views Updated December 24th, 2025 -
JSON DB Python tutorial
JSON DB API quick start tutorial for Python programmers
31 views Updated February 2nd, 2026 -
Security terms
Explanations of Transport Layer Security (TLS) terminology and concepts
46 views Updated February 11th, 2026 -
Startup configuration
Configure the FairCom OPC UA service plugin
24 views Updated January 14th, 2026 -
Transform method concepts
FairCom Edge data transformation concepts that make factory data more useful
23 views Updated October 11th, 2025 -
Tutorial: Forward to and from HiveMQ
Configure FairCom's MQTT broker to forward and subscribe to messages from a HiveMQ broker
22 views Updated February 5th, 2026 -
Initialization
76 views Updated December 23rd, 2025 -
MTConnect Tutorials
FairCom Edge tutorials for Windows detailing ways to interact with an MTConnect simulator
20 views Updated October 10th, 2025 -
CTSegment Class
10 views Updated January 14th, 2026 -
Tutorial: Secure FairCom's MQTT broker with client certificates
Configure FairCom servers to use secure MQTT connections with CA, server, and client certificates
23 views Updated February 5th, 2026 -
FairCom RTG COBOL User Guide
35 views Updated February 26th, 2026 -
Data aggregation tutorials
Tutorials for automatic data aggregation
20 views Updated February 2nd, 2026 -
Callback
23 views Updated December 22nd, 2025 -
ISAM C tutorial
ISAM quick start tutorial for C programmers
39 views Updated February 9th, 2026 -
c-treeDB C API Definitions
29 views Updated December 23rd, 2025 -
CTString Class
11 views Updated January 14th, 2026 -
Error codes 10000 - 50999
FairCom other error codes 10000 - 50999
23 views Updated January 16th, 2026 -
CTDB C tutorial
CTDB quick start tutorial for C programmers
36 views Updated February 9th, 2026 -
JSON to fields API reference
API reference for the JSON to fields transform method
19 views Updated March 11th, 2026 -
FairCom Edge Node-RED concepts
Connect FairCom Edge to Node-RED to deliver data to protocols not supported by Node-RED
24 views Updated October 10th, 2025 -
Client authentication in a CLI tool
Use client authentication in a FairCom CLI tool
19 views Updated February 10th, 2026 -
Data change message in FairCom DB Notify
JSON format of data change messages
21 views Updated February 11th, 2026 -
FairCom Edge concepts
FairCom Edge's architecture and internals described for engineers
31 views Updated October 10th, 2025 -
REST API Support for Auto-Purge
27 views Updated January 14th, 2026 -
Fields to JSON API reference
API reference for the fields/table to JSON transform method
19 views Updated March 11th, 2026 -
API quick start tutorials
Tutorials to help developers quickly start using FairCom APIs
31 views Updated February 9th, 2026 -
Startup configuration
Enable the FairCom Allen-Bradley connector service (plugin)
29 views Updated March 4th, 2026 -
Connect client software to FairCom's JSON and MQTT APIs
Use TLS to connect client software to FairCom's JSON and MQTT APIs
20 views Updated February 10th, 2026 -
Modbus Tutorials
Modbus tutorials for FairCom Edge
22 views Updated January 8th, 2026 -
Advanced Configuration
19 views Updated February 20th, 2026 -
Error codes 17900 - 17999
FairCom SQL error codes 17900 - 17999
16 views Updated January 16th, 2026 -
repadm
Replication Agent administrator utility
18 views Updated February 11th, 2026 -
Data Explorer SQL tutorials
SQL tutorials for FairCom DB
20 views Updated January 14th, 2026 -
Error codes 17600 - 17699
FairCom SQL error codes 17600 - 17699
15 views Updated January 16th, 2026 -
Error codes 600 - 799
FairCom DB error codes 600 - 799
17 views Updated February 9th, 2026 -
Selectively return fields
Selectively return fields in the JSON DB
21 views Updated October 13th, 2025 -
JSON types
JSON types for FairCom DB
29 views Updated February 4th, 2026 -
JavaScript transform concepts
Concepts for the JavaScript transform method
17 views Updated January 14th, 2026 -
AWS IoT Core bridge tutorials
Connect FairCom Edge to AWS IoT Core bridge
19 views Updated January 28th, 2026 -
createcacert.py
Create a Certificate Authority certificate using the createcacert.py script in FairCom Certificate Manager
24 views Updated February 10th, 2026 -
C API to customize replication
C API to extend the FairCom replication agent to detect conflicts, transform replicated data, filter replicated data, and deliver data to other systems
16 views Updated February 11th, 2026 -
SDKs
List of FairCom DB software development kits organized by programming language, including tutorials, guides, client libraries, and drivers
46 views Updated February 4th, 2026 -
Error codes 10000 - 11999
FairCom SQL error codes 10000 - 11999
22 views Updated January 16th, 2026 -
Common Functionality
10 views Updated January 14th, 2026 -
Data Structures
30 views Updated December 22nd, 2025 -
Class CTBigint
10 views Updated January 14th, 2026 -
Configuration
ThingWorx configuration for FairCom Edge
26 views Updated January 28th, 2026 -
JSON to fields tutorial
Tutorial to transform JSON to fields in the same table
19 views Updated October 12th, 2025 -
CTSession Class
10 views Updated January 14th, 2026 -
Concepts
Concepts about the FairCom database engine
102 views Updated January 30th, 2026 -
RTG and ISAM errors
FairCom RTG and ISAM error codes
19 views Updated November 17th, 2025 -
JSON API connector concepts
27 views Updated January 28th, 2026 -
Linux Pacemaker replication tutorial
Build a Highly Available Cluster on Linux for FairCom DB
40 views Updated February 11th, 2026 -
Use cases
Use cases for the JSON to fields transform method
16 views Updated October 12th, 2025 -
C support for partitions and auto-purge
21 views Updated January 14th, 2026 -
Full-Text Search / Full-Text Indexing
26 views Updated December 22nd, 2025 -
Startup configuration
Enable the FairCom Siemens S7 connector service (plugin)
24 views Updated October 10th, 2025 -
certinfo.py
Display information in a certificate file using the certinfo.py script in FairCom Certificate Manager
21 views Updated February 10th, 2026 -
Node-RED tutorials
Node-RED tutorials for FairCom DB
22 views Updated February 2nd, 2026 -
Installation
49 views Updated February 23rd, 2026 -
Configuring data aggregation
Configure data to aggregate automatically
17 views Updated October 15th, 2025 -
CTDatabase Class
11 views Updated January 14th, 2026 -
Using automatic timestamps
Track timestamps automatically using Automatic System Time
21 views Updated January 14th, 2026 -
Modbus startup configuration
16 views Updated January 13th, 2026 -
CTDateTime Class
11 views Updated January 14th, 2026 -
Error codes 12000 - 12999
FairCom SQL error codes 12000 - 12999
16 views Updated January 16th, 2026 -
CTMoney Class
10 views Updated January 14th, 2026 -
Configure TLS for ISAM and SQL APIs
Configure a FairCom server to use TLS for ISAM and SQL APIs
22 views Updated February 10th, 2026 -
Athlete tutorial
Explore the JSON DB API using the Data Explorer and API Explorer web apps
33 views Updated February 2nd, 2026 -
Binary types
Binary types
18 views Updated February 4th, 2026 -
createclientcert.py
Create a client certificate using the createclientcert.py script in FairCom Certificate Manager
26 views Updated February 10th, 2026 -
Modbus emulator
The Modbus Emulator software simulates running a machine communicating over the Modbus protocol
19 views Updated October 9th, 2025 -
AWS IoT Core Concepts
44 views Updated January 7th, 2026 -
CTCurrency Class
10 views Updated January 14th, 2026 -
Configure the replication agent
Use ctreplagent.cfg to configure FairCom's replication agent
25 views Updated December 15th, 2025 -
CTResource
10 views Updated January 14th, 2026 -
Count and paginate records
JSON DB API: Count and paginate records
23 views Updated February 2nd, 2026 -
Error codes 17100 - 17199
FairCom SQL error codes 17100 - 17199
14 views Updated January 16th, 2026 -
PORTER English stemming tokenizer
Example SQL full-text searches using PORTER English stemming tokenizer
19 views Updated January 14th, 2026 -
CTField Class
10 views Updated January 14th, 2026 -
CTTime Class
10 views Updated January 14th, 2026 -
FairCom DB Error Code Reference
13 views Updated January 13th, 2026 -
CTFullTextIndexDictionary Class
11 views Updated January 14th, 2026 -
FairCom DB API for C Overview
36 views Updated December 5th, 2025 -
CTFullTextIndex Class
11 views Updated January 14th, 2026 -
CTIndex Class
10 views Updated January 14th, 2026 -
Differentiating features
FairCom MQ features that differentiate it from other MQTT brokers
15 views Updated October 12th, 2025 -
Event streaming concepts
Concepts for event streaming and messaging with the MQ API
24 views Updated January 14th, 2026 -
Transform methods
FairCom Edge transform method documentation for developers to transform, enrich, and reshape incoming data before FairCom Edge delivers it to devices and software
21 views Updated January 14th, 2026 -
Object owner
20 views Updated October 13th, 2025 -
Error codes 25000 - 25999
FairCom SQL error codes 25000 - 25999
14 views Updated January 16th, 2026 -
Error codes 18000 - 18999
FairCom SQL error codes 18000 - 18999
15 views Updated January 16th, 2026 -
Error codes 13000 - 13999
FairCom SQL error codes 13000 - 13999
15 views Updated January 16th, 2026 -
Error codes 17001 - 17099
FairCom SQL error codes 17001 - 17099
18 views Updated January 16th, 2026 -
FairCom RTG overview
FairCom RTG documentation home
18 views Updated January 15th, 2026 -
Most effective ways to return data from the JSON DB API
How best to return query results one page at a time or all at once
51 views Updated February 4th, 2026 -
Error codes 20000 - 20399
FairCom SQL error codes 20000 - 20399
15 views Updated January 16th, 2026 -
Error codes 22000 - 23999
FairCom SQL error codes 22000 - 23999
15 views Updated January 16th, 2026 -
Node-RED connector
FairCom Edge Node-RED connector
19 views Updated January 28th, 2026 -
Error codes 26000 - 50999
FairCom SQL error codes 26000 - 50999
16 views Updated January 16th, 2026 -
SQL connector
FairCom Edge SQL connector for databases, software, and ETL tools
18 views Updated January 28th, 2026 -
TLS in Python for MQTT
Use TLS in Python for MQTT
22 views Updated February 10th, 2026 -
Overview
26 views Updated January 13th, 2026 -
Quick tutorial for replication agent
Quickly install, configure, and test your replication installation
24 views Updated February 11th, 2026 -
MQTT system topics
FairCom MQ automatically publishes system messages to three topics
28 views Updated October 12th, 2025 -
Compatibility
13 views Updated December 23rd, 2025 -
Overview
FairCom DB documentation overview
134 views Updated February 11th, 2026 -
Sort results
Sort results in the JSON DB
20 views Updated February 4th, 2026 -
Selectively return JSON properties
Selectively return JSON properties in the JSON DB
19 views Updated February 4th, 2026 -
ThingWorx Concepts
27 views Updated January 28th, 2026 -
FairCom MQ overview
FairCom MQ documentation home
24 views Updated February 5th, 2026 -
FairCom Edge Overview
FairCom Edge documentation home
39 views Updated January 28th, 2026 -
importcert.py
Register a CA certificate with an operating system using the importcert.py script in FairCom Certificate Manager
29 views Updated February 10th, 2026 -
Implementation
Implement the FairCom Edge API actions for REST connectors
16 views Updated January 28th, 2026 -
Tutorials
Siemens S7 connector tutorials
58 views Updated October 10th, 2025 -
FairCom DB API .NET Definitions
12 views Updated January 13th, 2026 -
Set maximum active partitions for auto-purge
22 views Updated February 2nd, 2026 -
Import a certificate into Windows
Import a CA certificate into the certificate keystore of a Windows machine
20 views Updated February 10th, 2026 -
Overview
10 views Updated January 14th, 2026 -
renewcerts.py
Renew certificates that are about to expire using the renewcerts.py script in FairCom Certificate Manager
18 views Updated February 10th, 2026 -
Import a CA certificate into MacOS
Import a CA certificate into the MacOS KeyChain Access application
20 views Updated February 10th, 2026 -
FairCom DB API, ISAM, and Low-Level Integration
17 views Updated December 18th, 2025 -
"publication"
The publication object is used to create, delete, and list publications
15 views Updated February 11th, 2026 -
SQL Python tutorial
SQL quick start tutorial for Python programmers
38 views Updated February 9th, 2026 -
Tutorial: Forward to and from Mosquitto
Configure FairCom's MQTT broker to forward and subscribe to messages from a Mosquitto broker
23 views Updated February 5th, 2026 -
Import a CA certificate into OS
Import CA certificates into an OS keystore
25 views Updated January 20th, 2026 -
Query techniques
Concepts for the JSON DB get data actions
38 views Updated October 13th, 2025 -
Simple Replication Agent tutorial
Simple tutorial to replicate data between two FairCom servers running on the same computer
17 views Updated February 11th, 2026 -
Record lock error
Retries and diagnostics for record lock error
19 views Updated February 11th, 2026 -
Use transactions
Use transactions in JSON DB
27 views Updated October 13th, 2025 -
SIMPLE tokenizer
Example SQL full-text searches using SIMPLE tokenizer
16 views Updated January 14th, 2026 -
ThingWorx connector
Connect FairCom Edge to ThingWorx for codeless querying
19 views Updated January 28th, 2026 -
REST connector
Connect FairCom Edge to enterprise APIs by posting JSON to REST services.
15 views Updated January 28th, 2026 -
SQL for PHP PDO tutorial
SQL quick start tutorial for PHP programmers with the PDO extension
39 views Updated February 9th, 2026 -
REST API for Automatic System Time
22 views Updated October 15th, 2025 -
Siemens S7 connector
Connect FairCom Edge to Siemens PLCs and devices using the Siemens S7 protocol
19 views Updated October 10th, 2025 -
Use client authentication in client software
Use client authentication in client software
20 views Updated February 10th, 2026 -
Working with Callbacks
13 views Updated December 18th, 2025 -
JavaScript transform use cases
Use cases for the JavaScript transform method
21 views Updated January 14th, 2026 -
Tutorial: MQTT client for Java
Use the Java MQTT client with FairCom's MQTT broker engine
32 views Updated February 5th, 2026 -
TLS with ISQL
Use TLS with ISQL
20 views Updated January 20th, 2026 -
Use TLS with FairCom's ISAM, CTDB, and SQL client drivers
FairCom client driver settings to connect securely to FairCom's ISAM, CTDB, and SQL APIs
22 views Updated February 10th, 2026 -
Tutorial: MQTT client for Node.js
Use the Node.js MQTT client with FairCom's MQTT broker engine
29 views Updated February 5th, 2026 -
Working With Resources
14 views Updated December 23rd, 2025 -
Working With Records
12 views Updated January 14th, 2026 -
Variant data type tutorials
Use the following tutorials to use the variant data type effectively
17 views Updated October 13th, 2025 -
Error codes 500 - 599
FairCom DB error codes 500 - 599
19 views Updated February 9th, 2026 -
Working with Sessions
12 views Updated January 15th, 2026 -
ODBC tutorial
ODBC quick start tutorial for C programmers
46 views Updated February 9th, 2026 -
Data Types
25 views Updated February 26th, 2026 -
Data Integrity
13 views Updated December 19th, 2025 -
Working with Resources
14 views Updated December 17th, 2025 -
c-treeDB C API Functions
38 views Updated December 23rd, 2025 -
Working with Unicode
13 views Updated December 18th, 2025 -
Error codes 1000 - 1299
FairCom DB error codes 1000 - 1299
19 views Updated January 16th, 2026 -
Programmer's Reference Overview
33 views Updated December 9th, 2025 -
Working with Tables
24 views Updated December 17th, 2025 -
Modbus connector
Connect FairCom Edge to Modbus devices
24 views Updated October 9th, 2025 -
OPC UA tutorials
FairCom Edge tutorials detailing ways to interact with an OPC UA simulator
25 views Updated October 10th, 2025 -
Working with Records
11 views Updated January 21st, 2026 -
ISQL tutorial
FairCom Interactive SQL - quick start tutorial
40 views Updated February 9th, 2026 -
Concepts (Fields to JSON transform)
Concepts for the table to JSON transform method
20 views Updated March 13th, 2026 -
Concepts (JSON to fields transform)
Concepts for the JSON to fields transform method
20 views Updated March 13th, 2026 -
Administration
FairCom Edge administration home page contains links to server administration tasks
61 views Updated January 28th, 2026 -
TLS
Use Transport Layer Security (TLS) in FairCom products
24 views Updated February 11th, 2026 -
Use cases
Use cases for the table to JSON transform method
17 views Updated October 12th, 2025 -
OPC UA connector
Connect FairCom Edge to OPC UA devices
18 views Updated October 10th, 2025 -
Manage data using Node.js
Manage data using Node.js and the JSON DB API tutorial
26 views Updated February 2nd, 2026 -
Configure TLS ciphers
Configure a FairCom server to use specific Transport Layer Security ciphers
18 views Updated January 20th, 2026 -
Use table filters
Use the table filters with JSON DB
23 views Updated October 13th, 2025 -
Replication agent
Manually configure data replication between FairCom servers using Replication Agent
31 views Updated February 13th, 2026 -
Import a certificate into Linux
Import a CA certificate into the certificate keystore of a Linux machine
20 views Updated February 10th, 2026 -
FairCom ISAM User Guide
19 views Updated October 15th, 2025 -
SQL APIs
List of FairCom SQL APIs and guides for developers, programming languages, and environments
38 views Updated February 4th, 2026 -
TLS Concepts
Overview of TLS concepts and how they apply to FairCom products
19 views Updated February 11th, 2026 -
Data Integrity
13 views Updated January 14th, 2026 -
Chrome certificate peculiarities
22 views Updated February 10th, 2026 -
"engine"
The engine object contains actions that can be used to interact with the database engines managed by the specified replication instance
17 views Updated February 11th, 2026 -
"manager"
The manager property contains operations that can be used to interact with the replication manager options and information
16 views Updated February 11th, 2026 -
TLS for JSON APIs, MQTT, and browser-based apps
Configure a FairCom server to use TLS for JSON APIs, MQTT, and browser-based apps
21 views Updated February 10th, 2026 -
CLI utilities
Use TLS with FairCom's CLI utilities
20 views Updated January 20th, 2026 -
TLS in Python for JSON DB API
Use TLS in Python for JSON DB API
28 views Updated February 10th, 2026 -
Determine TLS connections
Determine TLS connections in FairCom's CLI utilities and Monitor App
19 views Updated January 20th, 2026 -
Client certificate authentication on ISAM API
Use client certificate authentication with FairCom's ISAM API
20 views Updated January 20th, 2026 -
Enable client certificate authentication
Enable client certificate authentication on a FairCom server
20 views Updated February 10th, 2026 -
TLS in Browser-based apps running in Google Chrome
Use TLS with FairCom's browser-based apps running in Google Chrome
19 views Updated February 10th, 2026 -
Enable server-side TLS logging
Enable server-side TLS logging for the FairCom wire protocols
19 views Updated January 20th, 2026 -
Error codes 16000 - 16999
FairCom SQL error codes 16000 - 16999
15 views Updated November 16th, 2025 -
Enable client-side TLS logging
Enable client-side TLS logging for applications using mtclient
19 views Updated January 20th, 2026 -
Data Types
11 views Updated February 26th, 2026 -
HA, DR, and Scalability use cases
Data replication delivers data to multiple servers for high availability, read scalability, and disaster recovery
20 views Updated January 16th, 2026 -
Troubleshoot the replication agent
Fix common issues with the data replication agent
19 views Updated February 11th, 2026 -
cttctx
Performance test utility
17 views Updated February 11th, 2026 -
HA, DR, and Scalability Tutorials
Tutorials for High Availability, Disaster Recovery, and Scalability
17 views Updated October 17th, 2025 -
ctrepd
Replication transaction log utility
16 views Updated February 11th, 2026 -
Working with Multiple Files (FILESET)
19 views Updated December 18th, 2025 -
TLS in Java for MQTT
Use TLS in Java for MQTT
21 views Updated January 20th, 2026 -
"plan"
The plan object specifies actions performed within replication plans
15 views Updated February 11th, 2026 -
Create a server certificate
Create a server key and server certificate
25 views Updated January 20th, 2026 -
Data types
Field types for FairCom DB
56 views Updated February 4th, 2026 -
"options"
This options property applies to a specific target
16 views Updated February 11th, 2026 -
Use cases (JSON to table transform)
Use cases for the JSON to different table transform method
14 views Updated March 13th, 2026 -
Concepts (JSON to table transform)
Concepts for using the JSON to different table transform method
18 views Updated March 13th, 2026 -
Node-RED tutorials
Node-RED tutorials for FairCom Edge
27 views Updated January 28th, 2026 -
Error codes 800 - 999
FairCom DB error codes 800 - 999
17 views Updated February 9th, 2026 -
MTConnect connector
Connect FairCom Edge to MTConnect agents
18 views Updated October 9th, 2025 -
Upgrade notes for administrators
24 views Updated February 6th, 2026 -
Steps to upgrade FairCom server
24 views Updated February 6th, 2026 -
Configure tables for FairCom DB Notify
Configure tables to track data changes
27 views Updated February 11th, 2026 -
Configure connection
Configure the connection from FairCom DB Notify to FairCom MQ using the /config/dbnotifyconnections.json file.
21 views Updated February 11th, 2026 -
Error codes 17700 - 17799
FairCom SQL error codes 17700 - 17799
14 views Updated January 16th, 2026 -
Replication C++ tutorial
Replication quick start tutorial for C++ programmers
29 views Updated February 9th, 2026 -
Working With Tables
14 views Updated January 14th, 2026 -
DSQL C tutorial
Direct SQL quick start tutorial for C programmers
25 views Updated February 9th, 2026 -
Replication agent extension tutorial
Tutorial for extending the replication agent to log replication events
15 views Updated February 11th, 2026 -
FairCom DB Notify tutorial
FairCom DB Notify and FairCom MQ non-secure and secure communications - tutorial
29 views Updated February 11th, 2026 -
JDBC tutorial
JDBC quick start tutorial for Java programmers
58 views Updated February 9th, 2026 -
SQLAlchemy Python tutorial
SQLAlchemy quick start tutorial for Python programmers
37 views Updated February 9th, 2026 -
Negative error codes
FairCom DB negative error codes
21 views Updated January 16th, 2026 -
FairCom DB Notify Concepts
FairCom DB Notify Concepts
25 views Updated February 11th, 2026 -
Upgrade notes for developers
28 views Updated February 6th, 2026 -
Orphaned Replication Agent
Correctly terminate orphaned Replication Agent source and target server connections
15 views Updated February 11th, 2026 -
Indexing
25 views Updated December 22nd, 2025 -
Transaction processing functions
28 views Updated February 17th, 2026 -
Filters
23 views Updated December 22nd, 2025 -
ACE APIs
FairCom's ACE APIs provide low-level control over all aspects of data processing in order to build solutions that are unrivaled in capability and performance.
46 views Updated February 26th, 2026 -
Data Manipulation
40 views Updated December 23rd, 2025 -
Connectors
The FairCom Edge connector documentation for software developers to collect tags from devices and send data to devices and software.
52 views Updated February 4th, 2026 -
Partitions
24 views Updated December 22nd, 2025 -
Resources
26 views Updated December 22nd, 2025 -
Data Types
24 views Updated December 22nd, 2025 -
Utility
32 views Updated December 22nd, 2025 -
Let existing ISAM applications co-exist with SQL
29 views Updated February 6th, 2026 -
Working with Records
16 views Updated December 17th, 2025 -
TLS in Java for JSON DB API
Use TLS in Java for JSON DB API
32 views Updated February 10th, 2026 -
Error codes 7000 - 7499
FairCom DB error codes 7000 - 7499
20 views Updated January 16th, 2026 -
Replication network recommendations
Network and port standards for data replication
16 views Updated February 11th, 2026 -
TLS in Node-RED for MQTT
Use TLS in Node-RED for MQTT
17 views Updated February 10th, 2026 -
Data Explorer
Data Explorer UI tutorials
26 views Updated February 11th, 2026 -
Monitor
FairCom's Monitor UI can be used to view configurations, performance statistics, and monitor live data.
32 views Updated February 11th, 2026 -
Fields to JSON transform method
The FairCom Edge transform method for converting fields into JSON stored in the same table
18 views Updated October 12th, 2025 -
Edge Explorer
Use Edge Explorer to visually navigate your Edge information
30 views Updated February 11th, 2026 -
MQ Explorer
MQ Explorer UI tutorials
29 views Updated February 11th, 2026 -
Data Definition
28 views Updated December 23rd, 2025 -
Variant concepts
Concepts about the variant data type and object
29 views Updated March 3rd, 2026 -
Result Sets
26 views Updated December 22nd, 2025 -
JSON to different table API reference
API reference for the JSON to different table transform method
27 views Updated March 11th, 2026 -
Certificate Manager
FairCom Certificate Manager is a scripting solution that manages a company's internal certificates
32 views Updated February 10th, 2026 -
Compatibility with other c-tree API Technologies
13 views Updated December 18th, 2025 -
SQL connector concepts
SQL connector concepts for FairCom Edge
22 views Updated January 14th, 2026 -
FairCom Edge tutorials
Tutorials for FairCom Edge
35 views Updated October 6th, 2025 -
Using Auto-Purge
Purge data automatically to avoid storage issues
20 views Updated February 2nd, 2026 -
JSON to table tutorial
Tutorial to transform JSON to fields in a different table
30 views Updated January 14th, 2026 -
"options" (instance)
The options property can change the behavior of the current replutil run
16 views Updated February 11th, 2026 -
Concepts
Concepts for certificate management
26 views Updated February 10th, 2026 -
Error codes 0 - 199
FairCom DB error codes 0 - 199
29 views Updated February 9th, 2026 -
Batch Operations
26 views Updated December 22nd, 2025 -
Connection and startup issues
Troubleshoot common problems with data replication connection and startup
16 views Updated February 11th, 2026 -
MQTT concepts
MQTT concepts for developers and administrators
37 views Updated February 5th, 2026 -
MQTT connector
Use FairCom Edge as an MQTT connector to deliver device data to MQTT clients, other MQTT brokers, and other messaging systems, such as AMQP brokers, Kafka, IBM MQ, etc.
42 views Updated January 28th, 2026 -
Error codes 400 - 499
FairCom DB error codes 400 - 499
18 views Updated February 9th, 2026 -
Broker forwarding
Forward MQTT messages from FairCom MQ to another messaging system, such as MQTT Brokers, AMQP Brokers, Kafka, AWS IoT Core, Microsoft Azure IoT Hub, and IBM MQ
25 views Updated February 5th, 2026 -
ThingWorx tutorials
ThingWorx connector tutorials for FairCom Edge
32 views Updated January 28th, 2026 -
Security administration utility
Use sa_admin to manage users, groups, and file permissions
19 views Updated December 3rd, 2025 -
JavaScript transform tutorials
Tutorials for the JavaScript transform method
24 views Updated March 10th, 2026 -
Data Integrity
10 views Updated January 27th, 2026 -
SQL Tutorials
SQL for databases and ETL tools tutorials
23 views Updated January 28th, 2026 -
CTBase Class
10 views Updated January 14th, 2026 -
Working with Multi-Record Virtual Tables
16 views Updated December 18th, 2025 -
Data Types
6 views Updated February 26th, 2026 -
Tutorial: MQTT client for Python
Use the Python MQTT client with FairCom's MQTT broker engine
41 views Updated February 5th, 2026 -
CTBlob Class
11 views Updated January 14th, 2026 -
Error codes 17500 - 17599
FairCom SQL error codes 17500 - 17599
13 views Updated January 16th, 2026 -
Variant type
46 views Updated February 18th, 2026 -
CTDate Class
10 views Updated January 14th, 2026 -
PAGE_SIZE conversions
30 views Updated February 6th, 2026 -
String types
String types
20 views Updated February 4th, 2026 -
Allen-Bradley connector
Connect FairCom Edge to Allen-Bradley devices using EtherNet/IP and PCCC over DF1 protocols
20 views Updated October 9th, 2025 -
Boolean type
Boolean type
19 views Updated February 4th, 2026 -
More information about upgrading
22 views Updated February 6th, 2026 -
JSON DB concepts
Using the JSON DB API in applications, web services, and automation scripts
38 views Updated February 4th, 2026 -
Troubleshoot FairCom DB Notify
Use CTSTATUS.FCS to troubleshoot FairCom DB Notify
21 views Updated October 17th, 2025 -
Administration
FairCom DB administration home page contains links to server administration tasks
31 views Updated February 4th, 2026 -
Converting DB V4.1F-V4.3C applications
22 views Updated February 6th, 2026 -
JSON DB API tutorials
Tutorials for the JSON DB API using the athlete table in the API Explorer user interface
20 views Updated February 2nd, 2026 -
Certificate best practices for FairCom customers
18 views Updated January 20th, 2026 -
FairCom MQ Tutorials
FairCom MQ tutorials for software developers
25 views Updated February 5th, 2026 -
setuptls.py
Use setuptls.py to complete all setup steps to active TLS secure communications
18 views Updated December 3rd, 2025 -
JSON to fields transform method
The FairCom Edge transform method for converting JSON properties to fields in the current integration table
16 views Updated October 12th, 2025 -
Error codes 4000 - 4199
FairCom DB error codes 4000 - 4199
22 views Updated January 16th, 2026 -
CTTime Class
10 views Updated January 28th, 2026 -
DIAGNOSTICS REPLICATE
Use DIAGNOSTICS REPLICATE to identify replication failures
16 views Updated February 11th, 2026 -
CTRecord Class
12 views Updated January 14th, 2026 -
JSON DB API tutorial
FairCom's JSON DB API can be used to query MQTT data captured from IoT devices
40 views Updated January 28th, 2026 -
JavaScript Transform tutorial
FairCom's JavaScript Transform can be used to process MQTT messages sent to a topic
37 views Updated October 10th, 2025 -
Releases & upgrades
Explore FairCom Edge releases, featuring enhancements and new capabilities.
11 views Updated March 12th, 2026 -
Working with Databases
18 views Updated January 15th, 2026 -
Manage certificate warnings in Google Chrome
Manage certificate security warnings in Google Chrome
35 views Updated February 10th, 2026 -
TLS Tutorials
27 views Updated February 10th, 2026 -
Low Level Development Concepts
25 views Updated December 9th, 2025 -
Date & Time types
JSON DB date and time types use ISO 8601 and ISO 8604 format while FairCom's other APIs use other conventions
18 views Updated February 4th, 2026 -
Number types
Number types
19 views Updated February 4th, 2026 -
Error codes 14000 - 14999
FairCom Plugin error codes 14000 - 14999
17 views Updated January 16th, 2026 -
Error codes 21000 - 21999
FairCom SQL error codes 21000 - 21999
15 views Updated January 16th, 2026 -
Replication Agent loses connection
How to recover Replication Agent connection to FairCom DB servers
17 views Updated February 11th, 2026 -
Configure TLS for a server
Configure a FairCom server to use a TLS server certificate
39 views Updated February 10th, 2026 -
HA, DR, and Scalability concepts
Remain available during system outages using High Availability, Disaster Recovery, and Scalability
31 views Updated January 16th, 2026 -
Working with Sessions
62 views Updated December 5th, 2025 -
Error codes 17300 - 17499
FairCom SQL error codes 17300 - 17499
13 views Updated January 16th, 2026 -
Working with Databases
28 views Updated December 16th, 2025 -
Security
Use security features with FairCom products
29 views Updated February 11th, 2026 -
Error codes 200 - 399: internal errors
FairCom DB error codes 200 - 399: internal errors
20 views Updated January 16th, 2026 -
Errors
List of FairCom error codes for all FairCom products
69 views Updated February 9th, 2026 -
Replication Agent errors
Troubleshoot Replication Agent exceptions and errors
22 views Updated February 11th, 2026 -
"getRecordsTransform" code package
Transform data as it is read from the database
27 views Updated February 2nd, 2026