Ked Peregoy
kedryn.peregoy@faircom.com
Articles by Ked
-
-
Capacity Planning Considerations
7 views Updated February 3rd, 2026 -
FairCom DB Database Engine
13 views Updated February 19th, 2026 -
Allen-Bradley concepts
Connect FairCom Edge to Allen-Bradley devices using EtherNet/IP and PCCC over DF1 protocols
18 views Updated March 4th, 2026 -
Server-Side Queues
9 views Updated February 19th, 2026 -
listDatabases
JSON DB "listDatabases" action retrieves all databases on the server
12 views Updated March 4th, 2026 -
Using JSON in SQL
10 views Updated February 2nd, 2026 -
Backups and Data Integrity
16 views Updated February 2nd, 2026 -
listBrokerConnections
JSON MQ and Hub "listBrokerConnections" action returns and filters a list of broker connections
20 views Updated March 4th, 2026 -
File Notification
10 views Updated February 19th, 2026 -
getRecordIdsLinkedToLabel
9 views Updated March 4th, 2026 -
runSqlStatements
JSON DB "runSqlStatements" action runs SQL statements as a batch operation
26 views Updated March 4th, 2026 -
deleteTables
JSON DB "deleteTables" action deletes tables
29 views Updated March 4th, 2026 -
alterCodePackage
Update the code in the server
15 views Updated March 4th, 2026 -
FairCom JSON Conventions
10 views Updated March 4th, 2026 -
jsonAction response
List of properties in JSON Action response messages
18 views Updated March 4th, 2026 -
describeCodePackages
Return information about specified code packages
14 views Updated March 4th, 2026 -
createCodePackage
Store JavaScript code in the server
13 views Updated March 4th, 2026 -
jsonAction request
List of properties in JSON Action request messages
21 views Updated March 4th, 2026 -
Allen-Bradley tutorials
FairCom Edge Allen-Bradley connector service tutorials
14 views Updated March 4th, 2026 -
Code packages concepts
Concepts for creating code packages that provide custom features for FairCom servers
16 views Updated March 4th, 2026 -
Transform data as it is read from the database
Use "getRecordsTransform" in the code package API
7 views Updated March 4th, 2026 -
Transform data as it comes into the database
Use the "integrationTableTransform" in the code package API
8 views Updated March 4th, 2026 -
Create a permanent session
Use the "permanentSession" property to create permanent sessions
12 views Updated March 4th, 2026 -
Sessions and Services API FAQs
Frequently Asked Questions for the Sessions & services API
10 views Updated March 4th, 2026 -
listCodePackages
Return a list of code packages that match all specified filters
12 views Updated March 4th, 2026 -
Log messages
OPC Server status codes logged to CTSTATUS.FCS
10 views Updated March 4th, 2026 -
Using the solution in SQL, JSON DB, and CTDB.
10 views Updated March 4th, 2026 -
updateRecords
JSON DB "updateRecords" action updates records in a database table
17 views Updated March 4th, 2026 -
How to install and configure the data change streaming feature
7 views Updated March 4th, 2026 -
listIntegrationTables
JSON hub "listIntegrationTable action lists all existing tables for a given database
17 views Updated March 4th, 2026 -
alterTable
JSON DB "alterTable" action modifies an existing table
18 views Updated March 4th, 2026 -
Data Change Stream concepts
Concepts for capturing data change events in FairCom DB and RTG servers and delivering them to FairCom MQ
19 views Updated March 4th, 2026 -
OPC UA connector tutorials
FairCom Edge tutorials detailing ways to interact with an OPC UA simulator
10 views Updated March 4th, 2026 -
commitTransaction
JSON DB "commitTransaction" action commits a transaction and, when successful, ensures all actions attached to the transaction have been completed successfully and durably
19 views Updated March 4th, 2026 -
listLabels
Retrieve a filtered list of label names
9 views Updated March 4th, 2026 -
linkLabelsToRecords
11 views Updated March 4th, 2026 -
rebuildIndexes
JSON DB "rebuildIndexes" action rebuilds all indexes or specified indexes
13 views Updated March 4th, 2026 -
manageService
Configure settings for a FairCom Edge service
19 views Updated March 4th, 2026 -
deleteDatabase
JSON DB "deleteDatabase" action deletes a database
89 views Updated March 4th, 2026 -
listTransactions
JSON DB "listTransactions" action returns a list of all active transactions in your current session
17 views Updated March 4th, 2026 -
createTransactionSavePoint
JSON DB "createTransactionSavePoint" action creates a transaction savepoint and returns a unique identifier for the savepoint in the "transactionSavepointId" property
18 views Updated March 4th, 2026 -
getRecordsInKeyRange
JSON DB "getRecordsInKeyRange" action returns records within a range of values
20 views Updated March 4th, 2026 -
getRecordsFromCursor
JSON DB "getRecordsFromCursor" action retrieves records from a cursor created by a "getRecords..." action
30 views Updated March 4th, 2026 -
getRecordsStartingAtKey
JSON DB "getRecordsStartingAtKey" action positions the current record in the index at the key that most closely matches the comparison criteria
19 views Updated March 4th, 2026 -
deleteOutput
JSON hub "deleteOutput" action removes a previously created FairCom Edge integration
14 views Updated March 4th, 2026 -
listInputs
JSON hub "listInputs" action obtains a list of names of previously created FairCom Edge inputs
17 views Updated March 4th, 2026 -
alterOutput
JSON hub "alterOutput" action modifies a FairCom Edge output
17 views Updated March 4th, 2026 -
describeOutputs
JSON hub "describeOutputs" action returns all available information about each specified FairCom Edge output
16 views Updated March 4th, 2026 -
Siemens S7 API reference
Siemens S7 connector programming specifications
11 views Updated March 11th, 2026 -
OPC UA API reference
OPC UA connector programming specifications for FairCom Edge
10 views Updated March 11th, 2026 -
testIntegrationTableTransformSteps
Test new transform steps before running them
12 views Updated March 4th, 2026 -
createIntegrationTable
JSON hub "createIntegrationTable action creates a new integration table in FairCom Edge
28 views Updated March 4th, 2026 -
describeIntegrationTables
JSON hub "describeIntegrationTable action returns all available information about each specified integration table in FairCom Edge
20 views Updated March 4th, 2026 -
describeBrokerConnections
JSON MQ and Hub "describeBrokerConnections" action returns info about broker connections
14 views Updated March 4th, 2026 -
alterStreamingConnection
Update a streaming connection
22 views Updated March 4th, 2026 -
deleteStreamingConnection
Delete specified streaming connections
16 views Updated March 4th, 2026 -
describeDataChangeStreams
View information about specified data change streams
22 views Updated March 4th, 2026 -
pauseStreamingConnection
Pause specified streaming connections
23 views Updated March 4th, 2026 -
listDataChangeStreams
Return a list of data change streams that match all specified filters
21 views Updated March 4th, 2026 -
listStreamingConnectionProblems
View a streaming connection's errors and warnings
26 views Updated March 4th, 2026 -
getMessagesFromMqTopic
Retrieve messages published on a specific topic
14 views Updated March 4th, 2026 -
getRecordsByIndex
JSON DB "getRecordsByIndex" action can return a cursor to retrieve a large number of records efficiently or to navigate and retrieve records in any desired way
22 views Updated March 4th, 2026 -
listTopics
JSON MQ "listTopics" action returns and filters a list of MQTT topics
17 views Updated March 4th, 2026 -
publishMessagesToMq
Publish messages to a topic from the specified client
11 views Updated March 12th, 2026 -
revertTransactionToSavepoint
JSON DB "revertTransactionToSavepoint" action undoes a transaction to a previously created savepoint
16 views Updated March 4th, 2026 -
pingSession
Identify if there are errors in a FairCom server instance
23 views Updated March 4th, 2026 -
createMqApiSession
Create a new MQ session
16 views Updated March 12th, 2026 -
alterMqSession
Alter session settings without disrupting the client
12 views Updated March 12th, 2026 -
API reference
Modbus connector programming specifications for FairCom Edge
9 views Updated March 11th, 2026 -
subscribeToMq
Add or remove a client's subscriptions
14 views Updated March 4th, 2026 -
createAndStartDataChangeStreams
Initialize one or more data change streams
28 views Updated March 4th, 2026 -
Glossary
13 views Updated February 2nd, 2026 -
Modbus Data types
FairCom Edge's "modbusDataType" property defines how to convert binary data types into JSON types
20 views Updated March 4th, 2026 -
createTransaction
JSON DB "createTransaction" action creates a transaction and returns a transaction ID value that can be added to other actions to put them under transaction control
18 views Updated March 4th, 2026 -
deleteRecords
JSON DB "deleteRecords" action deletes records from a table using its primary key
20 views Updated March 4th, 2026 -
deleteBrokerConnection
Delete connections to external brokers
15 views Updated March 4th, 2026 -
alterInput
JSON hub "alterInput" action modifies an existing FairCom Edge input
22 views Updated March 4th, 2026 -
listAccounts
List all accounts that the logged-in account is authorized to see
12 views Updated March 4th, 2026 -
JSONPath
Use JSONPath to query for JSON values
36 views Updated March 4th, 2026 -
Sample Programs
5 views Updated February 19th, 2026 -
listIndexes
JSON DB "listIndexes" action returns indexes that the logged-in user is allowed to see
14 views Updated March 4th, 2026 -
ISAM for C Database Technology
6 views Updated February 19th, 2026 -
ISAM for C Data Management
11 views Updated February 19th, 2026 -
listLabelGroups
Retrieve a list of all the groups used by the existing labels
7 views Updated March 4th, 2026 -
Linux Caching Considerations
8 views Updated February 3rd, 2026 -
License Authorization File
19 views Updated February 2nd, 2026 -
describeAccounts
Describe roles that the account is authorized to see
17 views Updated March 4th, 2026 -
createservercert.py
Create a server certificate using the createservercert.py script in FairCom Certificate Manager
16 views Updated February 10th, 2026 -
Tutorials
Modbus tutorials for FairCom Edge
9 views Updated March 4th, 2026 -
cloneCodePackage
Create a new code package with a new name and copy an existing code package into it
15 views Updated March 4th, 2026 -
Grant access privileges
Tutorial for granting access privileges to accounts
20 views Updated March 4th, 2026 -
Data Caching Best Practices
17 views Updated February 3rd, 2026 -
FairCom MQ APIs
FairCom MQ's API documentation for software developers, equipment manufacturers, and automation engineers
21 views Updated February 5th, 2026 -
Hot Alter Table
9 views Updated February 19th, 2026 -
Transaction Processing
5 views Updated February 19th, 2026 -
Event streaming concepts
Concepts for event streaming and messaging with the MQ API
11 views Updated March 4th, 2026 -
getRecordsUsingSQL
JSON DB "getRecordsUsingSQL" action runs a SQL query and returns the resulting records
29 views Updated March 4th, 2026 -
truncateRecords
JSON DB "truncateRecords" action deletes all records from a database table very quickly by deleting and recreating the data file
16 views Updated March 4th, 2026 -
New user from ADMIN group
7 views Updated February 5th, 2026 -
getLabelsLinkedToRecordIds
9 views Updated March 4th, 2026 -
FairCom DB Server Basic Operations
10 views Updated February 3rd, 2026 -
MTConnect tutorials
FairCom Edge tutorials for Windows detailing ways to interact with an MTConnect simulator
15 views Updated March 4th, 2026 -
Configuring FairCom DB
18 views Updated February 3rd, 2026 -
getMessagesFromMqApiSession
Retrieve undelivered messages from an MQ API client-subscribed topic
13 views Updated March 4th, 2026 -
alterSession
Alter the settings of a session
30 views Updated March 4th, 2026 -
unlinkLabelsFromRecords
10 views Updated March 4th, 2026 -
How to upgrade a replication server environment from v11.5 to v13 (RTG v5)
22 views Updated February 18th, 2026 -
Integration tables concepts
Concepts for the Integration Tables API
10 views Updated March 4th, 2026 -
"propertyPath"
Specifies the location in a JSON document where the server reads or writes a value
26 views Updated March 4th, 2026 -
"recordPath"
Specifies the location in a record where the server reads or writes a JSON value
19 views Updated March 4th, 2026 -
Standalone Multi-User
4 views Updated February 19th, 2026 -
Transport Layer Security Secures Data in Transit between Network FairCom DB Clients and Servers
13 views Updated February 3rd, 2026 -
FairCom DB Function Descriptions D-K
23 views Updated February 24th, 2026 -
Data File Snapshots
6 views Updated February 19th, 2026 -
Data and Index Files
12 views Updated February 19th, 2026 -
Using JavaScript to perform JSON actions
22 views Updated March 4th, 2026 -
Installing on Your Operating System
16 views Updated February 2nd, 2026 -
"responseOptions"
10 views Updated March 4th, 2026 -
listOutputs
JSON hub "listOutputs" action returns a list of the names of previously created FairCom Edge outputs
19 views Updated March 4th, 2026 -
Request properties
A comprehensive, universal list of all request (params) properties
9 views Updated March 11th, 2026 -
Accounts concepts
Concepts to manage accounts with the accounts API
10 views Updated March 4th, 2026 -
createLabel
Create a new label
8 views Updated March 4th, 2026 -
Session and Services Concepts
Concepts for creating and managing sessions and services
10 views Updated March 4th, 2026 -
deleteTopic
JSON MQ "deleteTopic" action deletes an MQTT topic
16 views Updated March 4th, 2026 -
insertRecords
JSON DB "insertRecords" action inserts records into a table
18 views Updated March 4th, 2026 -
deleteIndexes
JSON DB "deleteIndexes" action deletes indexes
14 views Updated March 4th, 2026 -
listMqSessions
View a list of sessions that match the "partialClientName"
14 views Updated March 4th, 2026 -
rerunIntegrationTableTransformSteps
Rerun transform steps after updating them
16 views Updated March 4th, 2026 -
optimizeLabelLinks
9 views Updated March 4th, 2026 -
listStreamingConnections
Return a list of streaming connections that match all specified filters
22 views Updated March 4th, 2026 -
deleteDataChangeStreams
Delete specified data change streams
22 views Updated March 4th, 2026 -
Response properties
5 views Updated March 10th, 2026 -
resumeStreamingConnection
Activate paused streaming connections
22 views Updated March 4th, 2026 -
FairCom DB APIs
Master list of JSON DB API actions for managing FairCom databases, tables, indexes, records, cursors, SQL, and transactions
46 views Updated February 2nd, 2026 -
Performance Monitoring
5 views Updated February 19th, 2026 -
Memory Files
9 views Updated February 19th, 2026 -
FairCom DB Utility Programs
10 views Updated February 19th, 2026 -
Client-Side Operation
10 views Updated February 19th, 2026 -
Using the Low-Level API
12 views Updated February 19th, 2026 -
File Recycle Bin
4 views Updated February 19th, 2026 -
Unicode
4 views Updated February 19th, 2026 -
ISAM for C Operational Models
9 views Updated February 19th, 2026 -
Multi-User Concepts
9 views Updated February 19th, 2026 -
Function Name Cross Reference
8 views Updated February 19th, 2026 -
FairCom DB Function Descriptions A-C
16 views Updated February 19th, 2026 -
Accounts API FAQs
Frequently Asked Questions about the Accounts API
9 views Updated March 4th, 2026 -
alterAccount
Alter an existing account
31 views Updated March 4th, 2026 -
Siemens S7 connector tutorials
9 views Updated March 4th, 2026 -
changeLabels
Modify sets of labels in bulk
7 views Updated March 4th, 2026 -
createSession
Log into the FairCom server
21 views Updated March 4th, 2026 -
MTConnect API reference
MTConnect connector specifications for FairCom Edge
64 views Updated March 11th, 2026 -
deleteSession
Disconnect a client from Remote Procedure Call service
20 views Updated March 4th, 2026 -
describeMqSessions
View information about a client's MQTT or MQ API session
8 views Updated March 4th, 2026 -
FairCom Edge Concepts
FairCom Edge's architecture and internals described for engineers
31 views Updated January 28th, 2026 -
Label concepts
Use the Label API's actions to manage labels, lookup lists, and tag sets
11 views Updated March 4th, 2026 -
Label API FAQs
Frequently Asked Questions about the Label API
9 views Updated March 4th, 2026 -
listSessions
Return a list of active sessions
21 views Updated March 4th, 2026 -
describeSessions
Return a list of session objects
24 views Updated March 4th, 2026 -
describeTopics
JSON MQ "describeTopics" action returns info about MQTT topics
23 views Updated March 4th, 2026 -
revertCodePackage
Revert the code package to the specified historical version
10 views Updated March 4th, 2026 -
createOutput
JSON hub "createOutput" action creates a new FairCom Edge integration
21 views Updated March 4th, 2026 -
copyIntegrationTableTransformSteps
Replace a target table's transform steps
22 views Updated March 4th, 2026 -
cloneAccount
Clone an existing account and its roles
12 views Updated March 4th, 2026 -
describeCodePackageHistory
Return historical information about the specified code packages
13 views Updated March 4th, 2026 -
listCodePackageHistory
Return a list of historical code packages that match all specified filters
14 views Updated March 4th, 2026 -
createIndex
JSON DB "createIndex" action creates an index on fields in a table
19 views Updated March 4th, 2026 -
dropAccounts
Mark an account as dropped from the server
14 views Updated March 4th, 2026 -
getRecordsByPartialKeyRange
JSON DB "getRecordsByPartialKeyRange" action retrieves zero or more records from a database table using the specified key range
25 views Updated March 4th, 2026 -
createTable
JSON DB "createTable" action creates a new table in a FairCom database
25 views Updated March 4th, 2026 -
listServices
Return information about the specified services
23 views Updated March 4th, 2026 -
describeInputs
JSON hub "describeInputs" action returns all available information about each specified FairCom Edge input
15 views Updated March 4th, 2026 -
FairCom ISAM API for C - Developers Guide Overview
15 views Updated February 19th, 2026 -
API Reference
Allen-Bradley connector programming specifications
18 views Updated March 11th, 2026 -
assignRolesToAccounts
Add and remove roles from accounts
21 views Updated March 4th, 2026 -
describeTables
JSON DB "describeTables" action returns a complete set of metadata about one or more specified tables
30 views Updated March 4th, 2026 -
listTables
JSON DB "listTables" action lists tables in the specified database that the logged-in user is allowed to see
17 views Updated March 4th, 2026 -
configureBrokerConnection
Connect a FairCom Server to an external broker
22 views Updated March 4th, 2026 -
createStreamingConnection
Create a streaming connection
37 views Updated March 4th, 2026 -
FairCom DB Expression Parser and Grammar
11 views Updated January 21st, 2026 -
alterLabel
Modify an existing label
16 views Updated March 4th, 2026 -
Create a user account
9 views Updated February 5th, 2026 -
Grant rights to an integration table
7 views Updated February 5th, 2026 -
User's Control of Security Options
8 views Updated February 3rd, 2026 -
Command-Line Administration Utilities
15 views Updated February 3rd, 2026 -
Monitoring FairCom DB
11 views Updated February 3rd, 2026 -
Master Encryption Key Management
9 views Updated February 3rd, 2026 -
Performance Optimization
14 views Updated February 3rd, 2026 -
deleteMqSession
Disconnect a client's MQ session
16 views Updated March 4th, 2026 -
createInput
JSON hub "createInput" action creates a new FairCom Edge input
27 views Updated March 4th, 2026 -
Logging and Monitoring
13 views Updated February 10th, 2026 -
getRecordsByTable
JSON DB "getRecordsByTable" action retrieves records from a database table in table order and performs a full scan of all records in a table
25 views Updated March 4th, 2026 -
alterIntegrationTable
JSON hub "alterIntegrationTable" action modifies settings for existing tables that are safe to modify
26 views Updated March 4th, 2026 -
createDatabase
JSON DB "createDatabase" action creates a database
31 views Updated March 4th, 2026 -
deleteInput
JSON hub "deleteInput" action deletes an input in FairCom Edge
24 views Updated March 4th, 2026 -
Example property paths that group related properties
11 views Updated March 4th, 2026 -
Record Schemas and DODA Resources
5 views Updated February 25th, 2026 -
deleteIntegrationTables
JSON hub "deleteIntegrationTable action deletes an existing FairCom Edge integration table as long as there are no dependencies on it
17 views Updated March 4th, 2026 -
rollbackTransaction
JSON DB "rollbackTransaction" action rolls back a transaction and, when successful, ensures all actions attached to the transaction are completely undone
19 views Updated March 4th, 2026 -
Database Rollback and Roll Forward Guide
12 views Updated February 27th, 2026 -
rebuildTables
JSON DB "rebuildTables" action rebuilds specified tables
27 views Updated March 4th, 2026 -
FairCom DB Access Configuration
23 views Updated February 3rd, 2026 -
configureTopic
JSON MQ "configureTopic" action configures an MQTT topic in FairCom MQ and FairCom Edge
32 views Updated March 4th, 2026 -
Advanced Configuration
5 views Updated February 18th, 2026 -
FairCom DB Configuration Options
45 views Updated February 2nd, 2026 -
closeCursor
JSON DB "closeCursor" action closes a previously opened cursor
17 views Updated March 4th, 2026 -
FairCom DB Function Descriptions K-Z
20 views Updated February 19th, 2026 -
getRecordsByIds
JSON DB "getRecordsByIds" action retrieves records from a database table using their IDs
28 views Updated March 4th, 2026 -
createAccount
Create an account to log into a server
27 views Updated March 4th, 2026 -
Code Packages FAQs
Frequently Asked Questions about the Code Package API
8 views Updated March 4th, 2026 -
FairCom DB Server Configuration Recommendations
8 views Updated February 2nd, 2026 -
Data Compression
9 views Updated February 3rd, 2026 -
Overview
18 views Updated February 2nd, 2026 -
Tuning Index Page Size
7 views Updated February 3rd, 2026 -
Server Best Practices
7 views Updated February 3rd, 2026 -
Basic Connection String Attributes and Defaults
6 views Updated February 3rd, 2026