Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

Groups: Group::Drop
216 Total Articles
16 This Month
30 Last Month
0 Followers

Articles by Ked

  1. FairCom DB Error Codes

  2. Capacity Planning Considerations

  3. FairCom DB Database Engine

  4. Allen-Bradley concepts

    Connect FairCom Edge to Allen-Bradley devices using EtherNet/IP and PCCC over DF1 protocols

  5. Server-Side Queues

  6. listDatabases

    JSON DB "listDatabases" action retrieves all databases on the server

  7. Using JSON in SQL

  8. Backups and Data Integrity

  9. listBrokerConnections

    JSON MQ and Hub "listBrokerConnections" action returns and filters a list of broker connections

  10. File Notification

  11. getRecordIdsLinkedToLabel

  12. runSqlStatements

    JSON DB "runSqlStatements" action runs SQL statements as a batch operation

  13. deleteTables

    JSON DB "deleteTables" action deletes tables

  14. alterCodePackage

    Update the code in the server

  15. FairCom JSON Conventions

  16. jsonAction response

    List of properties in JSON Action response messages

  17. describeCodePackages

    Return information about specified code packages

  18. createCodePackage

    Store JavaScript code in the server

  19. jsonAction request

    List of properties in JSON Action request messages

  20. Allen-Bradley tutorials

    FairCom Edge Allen-Bradley connector service tutorials

  21. Code packages concepts

    Concepts for creating code packages that provide custom features for FairCom servers

  22. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  23. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  24. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  25. Sessions and Services API FAQs

    Frequently Asked Questions for the Sessions & services API

  26. listCodePackages

    Return a list of code packages that match all specified filters

  27. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  28. Using the solution in SQL, JSON DB, and CTDB.

  29. updateRecords

    JSON DB "updateRecords" action updates records in a database table

  30. How to install and configure the data change streaming feature

  31. listIntegrationTables

    JSON hub "listIntegrationTable action lists all existing tables for a given database

  32. alterTable

    JSON DB "alterTable" action modifies an existing table

  33. Data Change Stream concepts

    Concepts for capturing data change events in FairCom DB and RTG servers and delivering them to FairCom MQ

  34. OPC UA connector tutorials

    FairCom Edge tutorials detailing ways to interact with an OPC UA simulator

  35. commitTransaction

    JSON DB "commitTransaction" action commits a transaction and, when successful, ensures all actions attached to the transaction have been completed successfully and durably

  36. listLabels

    Retrieve a filtered list of label names

  37. linkLabelsToRecords

  38. rebuildIndexes

    JSON DB "rebuildIndexes" action rebuilds all indexes or specified indexes

  39. manageService

    Configure settings for a FairCom Edge service

  40. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  41. listTransactions

    JSON DB "listTransactions" action returns a list of all active transactions in your current session

  42. createTransactionSavePoint

    JSON DB "createTransactionSavePoint" action creates a transaction savepoint and returns a unique identifier for the savepoint in the "transactionSavepointId" property

  43. getRecordsInKeyRange

    JSON DB "getRecordsInKeyRange" action returns records within a range of values

  44. getRecordsFromCursor

    JSON DB "getRecordsFromCursor" action retrieves records from a cursor created by a "getRecords..." action

  45. getRecordsStartingAtKey

    JSON DB "getRecordsStartingAtKey" action positions the current record in the index at the key that most closely matches the comparison criteria

  46. deleteOutput

    JSON hub "deleteOutput" action removes a previously created FairCom Edge integration

  47. listInputs

    JSON hub "listInputs" action obtains a list of names of previously created FairCom Edge inputs

  48. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  49. describeOutputs

    JSON hub "describeOutputs" action returns all available information about each specified FairCom Edge output

  50. Siemens S7 API reference

    Siemens S7 connector programming specifications

  51. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  52. testIntegrationTableTransformSteps

    Test new transform steps before running them

  53. createIntegrationTable

    JSON hub "createIntegrationTable action creates a new integration table in FairCom Edge

  54. describeIntegrationTables

    JSON hub "describeIntegrationTable action returns all available information about each specified integration table in FairCom Edge

  55. describeBrokerConnections

    JSON MQ and Hub "describeBrokerConnections" action returns info about broker connections

  56. alterStreamingConnection

    Update a streaming connection

  57. deleteStreamingConnection

    Delete specified streaming connections

  58. describeDataChangeStreams

    View information about specified data change streams

  59. pauseStreamingConnection

    Pause specified streaming connections

  60. listDataChangeStreams

    Return a list of data change streams that match all specified filters

  61. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  62. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  63. 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

  64. listTopics

    JSON MQ "listTopics" action returns and filters a list of MQTT topics

  65. publishMessagesToMq

    Publish messages to a topic from the specified client

  66. revertTransactionToSavepoint

    JSON DB "revertTransactionToSavepoint" action undoes a transaction to a previously created savepoint

  67. pingSession

    Identify if there are errors in a FairCom server instance

  68. createMqApiSession

    Create a new MQ session

  69. alterMqSession

    Alter session settings without disrupting the client

  70. API reference

    Modbus connector programming specifications for FairCom Edge

  71. subscribeToMq

    Add or remove a client's subscriptions

  72. createAndStartDataChangeStreams

    Initialize one or more data change streams

  73. Glossary

  74. Modbus Data types

    FairCom Edge's "modbusDataType" property defines how to convert binary data types into JSON types

  75. 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

  76. deleteRecords

    JSON DB "deleteRecords" action deletes records from a table using its primary key

  77. deleteBrokerConnection

    Delete connections to external brokers

  78. alterInput

    JSON hub "alterInput" action modifies an existing FairCom Edge input

  79. listAccounts

    List all accounts that the logged-in account is authorized to see

  80. JSONPath

    Use JSONPath to query for JSON values

  81. Sample Programs

  82. listIndexes

    JSON DB "listIndexes" action returns indexes that the logged-in user is allowed to see

  83. ISAM for C Database Technology

  84. ISAM for C Data Management

  85. listLabelGroups

    Retrieve a list of all the groups used by the existing labels

  86. Linux Caching Considerations

  87. License Authorization File

  88. describeAccounts

    Describe roles that the account is authorized to see

  89. createservercert.py

    Create a server certificate using the createservercert.py script in FairCom Certificate Manager

  90. Tutorials

    Modbus tutorials for FairCom Edge

  91. cloneCodePackage

    Create a new code package with a new name and copy an existing code package into it

  92. Grant access privileges

    Tutorial for granting access privileges to accounts

  93. Data Caching Best Practices

  94. FairCom MQ APIs

    FairCom MQ's API documentation for software developers, equipment manufacturers, and automation engineers

  95. Hot Alter Table

  96. Transaction Processing

  97. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  98. getRecordsUsingSQL

    JSON DB "getRecordsUsingSQL" action runs a SQL query and returns the resulting records

  99. truncateRecords

    JSON DB "truncateRecords" action deletes all records from a database table very quickly by deleting and recreating the data file

  100. New user from ADMIN group

  101. getLabelsLinkedToRecordIds

  102. FairCom DB Server Basic Operations

  103. MTConnect tutorials

    FairCom Edge tutorials for Windows detailing ways to interact with an MTConnect simulator

  104. Configuring FairCom DB

  105. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  106. alterSession

    Alter the settings of a session

  107. unlinkLabelsFromRecords

  108. How to upgrade a replication server environment from v11.5 to v13 (RTG v5)

  109. Integration tables concepts

    Concepts for the Integration Tables API

  110. "propertyPath"

    Specifies the location in a JSON document where the server reads or writes a value

  111. "recordPath"

    Specifies the location in a record where the server reads or writes a JSON value

  112. Standalone Multi-User

  113. Transport Layer Security Secures Data in Transit between Network FairCom DB Clients and Servers

  114. FairCom DB Function Descriptions D-K

  115. Data File Snapshots

  116. Data and Index Files

  117. Using JavaScript to perform JSON actions

  118. Installing on Your Operating System

  119. "responseOptions"

  120. listOutputs

    JSON hub "listOutputs" action returns a list of the names of previously created FairCom Edge outputs

  121. Request properties

    A comprehensive, universal list of all request (params) properties

  122. Accounts concepts

    Concepts to manage accounts with the accounts API

  123. createLabel

    Create a new label

  124. Session and Services Concepts

    Concepts for creating and managing sessions and services

  125. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  126. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  127. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  128. listMqSessions

    View a list of sessions that match the "partialClientName"

  129. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  130. optimizeLabelLinks

  131. listStreamingConnections

    Return a list of streaming connections that match all specified filters

  132. deleteDataChangeStreams

    Delete specified data change streams

  133. Response properties

  134. resumeStreamingConnection

    Activate paused streaming connections

  135. FairCom DB APIs

    Master list of JSON DB API actions for managing FairCom databases, tables, indexes, records, cursors, SQL, and transactions

  136. Performance Monitoring

  137. Memory Files

  138. FairCom DB Utility Programs

  139. Client-Side Operation

  140. Using the Low-Level API

  141. File Recycle Bin

  142. Unicode

  143. ISAM for C Operational Models

  144. Multi-User Concepts

  145. Function Name Cross Reference

  146. FairCom DB Function Descriptions A-C

  147. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  148. alterAccount

    Alter an existing account

  149. Siemens S7 connector tutorials

  150. changeLabels

    Modify sets of labels in bulk

  151. createSession

    Log into the FairCom server

  152. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  153. deleteSession

    Disconnect a client from Remote Procedure Call service

  154. describeMqSessions

    View information about a client's MQTT or MQ API session

  155. FairCom Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  156. Label concepts

    Use the Label API's actions to manage labels, lookup lists, and tag sets

  157. Label API FAQs

    Frequently Asked Questions about the Label API

  158. listSessions

    Return a list of active sessions

  159. describeSessions

    Return a list of session objects

  160. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  161. revertCodePackage

    Revert the code package to the specified historical version

  162. createOutput

    JSON hub "createOutput" action creates a new FairCom Edge integration

  163. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  164. cloneAccount

    Clone an existing account and its roles

  165. describeCodePackageHistory

    Return historical information about the specified code packages

  166. listCodePackageHistory

    Return a list of historical code packages that match all specified filters

  167. createIndex

    JSON DB "createIndex" action creates an index on fields in a table

  168. dropAccounts

    Mark an account as dropped from the server

  169. getRecordsByPartialKeyRange

    JSON DB "getRecordsByPartialKeyRange" action retrieves zero or more records from a database table using the specified key range

  170. createTable

    JSON DB "createTable" action creates a new table in a FairCom database

  171. listServices

    Return information about the specified services

  172. describeInputs

    JSON hub "describeInputs" action returns all available information about each specified FairCom Edge input

  173. FairCom ISAM API for C - Developers Guide Overview

  174. API Reference

    Allen-Bradley connector programming specifications

  175. assignRolesToAccounts

    Add and remove roles from accounts

  176. describeTables

    JSON DB "describeTables" action returns a complete set of metadata about one or more specified tables

  177. listTables

    JSON DB "listTables" action lists tables in the specified database that the logged-in user is allowed to see

  178. configureBrokerConnection

    Connect a FairCom Server to an external broker

  179. createStreamingConnection

    Create a streaming connection

  180. FairCom DB Expression Parser and Grammar

  181. alterLabel

    Modify an existing label

  182. Create a user account

  183. Grant rights to an integration table

  184. User's Control of Security Options

  185. Command-Line Administration Utilities

  186. Monitoring FairCom DB

  187. Master Encryption Key Management

  188. Performance Optimization

  189. deleteMqSession

    Disconnect a client's MQ session

  190. createInput

    JSON hub "createInput" action creates a new FairCom Edge input

  191. Logging and Monitoring

  192. 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

  193. alterIntegrationTable

    JSON hub "alterIntegrationTable" action modifies settings for existing tables that are safe to modify

  194. createDatabase

    JSON DB "createDatabase" action creates a database

  195. deleteInput

    JSON hub "deleteInput" action deletes an input in FairCom Edge

  196. Example property paths that group related properties

  197. Record Schemas and DODA Resources

  198. deleteIntegrationTables

    JSON hub "deleteIntegrationTable action deletes an existing FairCom Edge integration table as long as there are no dependencies on it

  199. rollbackTransaction

    JSON DB "rollbackTransaction" action rolls back a transaction and, when successful, ensures all actions attached to the transaction are completely undone

  200. Database Rollback and Roll Forward Guide

  201. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  202. FairCom DB Access Configuration

  203. configureTopic

    JSON MQ "configureTopic" action configures an MQTT topic in FairCom MQ and FairCom Edge

  204. Advanced Configuration

  205. FairCom DB Configuration Options

  206. closeCursor

    JSON DB "closeCursor" action closes a previously opened cursor

  207. FairCom DB Function Descriptions K-Z

  208. getRecordsByIds

    JSON DB "getRecordsByIds" action retrieves records from a database table using their IDs

  209. createAccount

    Create an account to log into a server

  210. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  211. FairCom DB Server Configuration Recommendations

  212. Data Compression

  213. Overview

  214. Tuning Index Page Size

  215. Server Best Practices

  216. Basic Connection String Attributes and Defaults