Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

Groups: Group::Drop
353 Total Articles
6 This Month
11 Last Month
0 Followers

Articles by Ked

  1. deleteValues

  2. Industrial Ethernet Connector Concepts

  3. setValues

  4. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  5. ISAM for C Operational Models

  6. getValues

  7. getKeysFromHierarchy

  8. deleteTags

  9. createTag

  10. FairCom DB SQL Operations and Utilities Guide

  11. HTTP status codes

  12. describeTags

  13. Developing ADO.NET Applications with FairCom DB SQL

  14. Transaction Processing (FC API for C)

  15. getRecordIdsLinkedToLabel

  16. getValuesFromHierarchy

  17. alterThing

  18. deleteThings

  19. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

  20. listThings

  21. listActions

  22. status (connectors)

  23. thingName

  24. Concepts

  25. unlinkLabelsFromRecords

  26. JSON API

  27. createIndex

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

  28. Set up FairCom's package repository on Linux

  29. thingId

  30. Utilities - Low Level

  31. deleteInput

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

  32. Modbus Data types

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

  33. createInput

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

  34. createThing

  35. Java Stored Procedures, Triggers, and UDFs

  36. describeThings

  37. Siemens S7 connector concepts

  38. alterMqSession

    Alter session settings without disrupting the client

  39. ADO.NET Driver Overview

  40. Advanced Encryption Master Key Custom Storage Retrieval

  41. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  42. FairCom DB JSON APIs

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

  43. SQL Analytic Functions

  44. Unicode

  45. alterInput

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

  46. I/O Control

  47. renameKeys

  48. tagId

  49. FairCom DB FAQs

  50. alterTag

  51. MQ APIs

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

  52. Supported field bus connectors

  53. describeValuesFromHierarchy

  54. Client-Side Operation

  55. OPC UA connector concepts

  56. Modbus connector concepts

  57. Function Name Cross Reference

  58. MTConnect connector concepts

  59. Backward Compatibility

  60. File Mirroring

  61. describeValues

  62. Tag action FAQs

  63. Diagnostics

  64. Administrative Utilities - Client

  65. Tutorials

  66. .NET Support

  67. Replication

  68. validateMqttPayload

  69. listTags

  70. ADO.NET QuickStart

  71. Siemens S7 connector tutorials

  72. describeInputs

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

  73. FairCom DB API for Java Tutorials

  74. Partitioned Files

  75. ISAM API Callbacks

  76. FairCom Callbacks Overview

  77. NAV c-treeDB API Callbacks

  78. Replication API Callbacks

  79. FairCom DB Utility Programs

  80. FairCom DB SQL ADO.NET Data Provider

  81. ISAM for C Database Technology

  82. Utilities for Stored Procedures, User-Defined Functions & Triggers

  83. FairCom Direct SQL for C and C++ Overview

  84. Command-Line Administration Utilities

  85. Utilities - Client

  86. Compiling

  87. Client Communication

  88. Advanced Configuration

  89. jsonAction response

    List of properties in JSON Action response messages

  90. FairCom DB Direct SQL Function Reference Guide

  91. FairCom ISAM API for C - Developers Guide Overview

  92. Direct SQL for C and C++ Tutorials

  93. Multi-User Concepts

  94. redist Folder

  95. Sample Programs

  96. DSQL field types and transaction isolation levels

  97. jsonAction request

    List of properties in JSON Action request messages

  98. ISAM for C Data Management

  99. Administrative Utilities - Standalone

  100. FairCom DB API for VB.Net Overview

  101. Tag action concepts

  102. FairCom DB API for Java Overview

  103. FairCom DB API Java Persistence API (JPA) Quick Start Guide

  104. Data and Index Files

  105. Driver Setup

  106. FairCom DB Database Engine

  107. subscribeToMq

    Add or remove a client's subscriptions

  108. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  109. Query the mqtt_stats table

  110. Database Backup

  111. FairCom Java and .NET Stored Procedures, Triggers, and User Defined Functions

  112. Thing API concepts

    Manage the things that FairCom Edge integrates with, such as sensors, devices, equipment, servers, and software applications

  113. Thing API FAQs

  114. Key-Value concepts

  115. Subsystem

  116. Basic Configuration

  117. Transaction Processing

  118. Glossary

  119. Startup and Shutdown

  120. Recovery

  121. Cache and Memory

  122. File Management

  123. Locking

  124. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  125. Data Change Stream concepts

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

  126. FairCom DB Expression Parser and Grammar

  127. manageService

    Configure settings for a FairCom Edge service

  128. deleteRecords

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

  129. describeCodePackageHistory

    Return historical information about the specified code packages

  130. Utilities - Standalone

  131. FairCom Typographical Conventions

  132. Predefined Functions

  133. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  134. DB overview for admins

  135. FairCom JSON Conventions

  136. SQL Data Load Utility: dbload

  137. commitTransaction

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

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

  139. Data Unload Utility: dbdump

  140. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  141. significantMagnitude

  142. listSessions

    Return a list of active sessions

  143. Glossary

  144. onError

  145. mtconnectCategoryPropertyPath

  146. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  147. Integration tables concepts

    Concepts for the Integration Tables API

  148. createSession

    Log into the FairCom server

  149. mtconnectDataNamePropertyPath

  150. alterSession

    Alter the settings of a session

  151. Using the Low-Level API

  152. createTransactionSavePoint

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

  153. alterAccount

    Alter an existing account

  154. createCodePackage

    Store JavaScript code in the server

  155. optimizeLabelLinks

  156. describeBrokerConnections

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

  157. listLabels

    Retrieve a filtered list of label names

  158. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  159. Grant rights to an integration table

  160. deleteTables

    JSON DB "deleteTables" action deletes tables

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

  162. Session and Services Concepts

    Concepts for creating and managing sessions and services

  163. JSON to fields tutorial

  164. createStreamingConnection

    Create a streaming connection

  165. Installing on Your Operating System

  166. primaryKeys

  167. normalUpperLimit

  168. listAccounts

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

  169. createIntegrationTable

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

  170. Using JavaScript to perform JSON actions

  171. listCodePackageHistory

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

  172. Configuring FairCom DB

  173. onChangeScope

  174. createTable

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

  175. Performance Optimization

  176. listIndexes

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

  177. createAccount

    Create an account to log into a server

  178. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  179. resumeStreamingConnection

    Activate paused streaming connections

  180. createLabel

    Create a new label

  181. Conditional Expressions Overview

    Overview of the conditional expressions data filters and conditional indexes

  182. listDatabases

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

  183. Fields to JSON tutorial

  184. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  185. publishMessagesToMq

    Publish messages to a topic from the specified client

  186. Example property paths that group related properties

  187. deleteStreamingConnection

    Delete specified streaming connections

  188. listMqSessions

    View a list of sessions that match the "partialClientName"

  189. listOutputs

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

  190. listStreamingConnections

    Return a list of streaming connections that match all specified filters

  191. FairCom ISQL

  192. License Authorization File

  193. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  194. getLabelsLinkedToRecordIds

  195. Conditional Data Persistence Tutorial

  196. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  197. Capacity Planning Considerations

  198. tagName

  199. getRecordsByIds

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

  200. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  201. Logging and Monitoring

  202. getRecordsFromCursor

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

  203. Custom Application Expressions

  204. Backups and Data Integrity

  205. API reference

    Modbus connector programming specifications for FairCom Edge

  206. Master Encryption Key Management

  207. Code packages concepts

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

  208. FairCom DB Configuration Options

  209. assignRolesToAccounts

    Add and remove roles from accounts

  210. createOutput

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

  211. User's Control of Security Options

  212. numberFormat

  213. Create a user account

  214. cloneCodePackage

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

  215. pauseStreamingConnection

    Pause specified streaming connections

  216. variantFormat

  217. sourcePayloadBinaryFormat

  218. Conditional Expression Callback Function

  219. dropAccounts

    Mark an account as dropped from the server

  220. Server-Side Queues

  221. FairCom DB Server Basic Operations

  222. listDataChangeStreams

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

  223. getRecordsStartingAtKey

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

  224. listCodePackages

    Return a list of code packages that match all specified filters

  225. alterLabel

    Modify an existing label

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

  227. closeCursor

    JSON DB "closeCursor" action closes a previously opened cursor

  228. updateRecords

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

  229. ISQL Statements Overview

  230. cloneAccount

    Clone an existing account and its roles

  231. testIntegrationTableTransformSteps

    Test new transform steps before running them

  232. mtconnectDeviceUuidPropertyPath

  233. Monitoring FairCom DB

  234. Record Schemas and DODA Resources

  235. sourcePayloadTimeFormat

  236. Security

  237. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  238. EtherNet/IP connector concepts

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

  239. padValue

  240. alterCodePackage

    Update the code in the server

  241. Hot Alter Table

  242. primaryKey

  243. deleteOutput

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

  244. describeCodePackages

    Return information about specified code packages

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

  246. JSONPath

    Use JSONPath to query for JSON values

  247. Conditional Expression Function Reference

    This section lists the functions that are provided for manipulating conditional expressions.

  248. Basic Connection String Attributes and Defaults

  249. pingSession

    Identify if there are errors in a FairCom server instance

  250. Unicode for Standalone

  251. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  252. deleteIntegrationTables

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

  253. FairCom DB Error Codes

  254. describeOutputs

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

  255. Tutorials

    Modbus tutorials for FairCom Edge

  256. runSqlStatements

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

  257. describeAccounts

    Describe roles that the account is authorized to see

  258. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  259. mtconnectDeviceNamePropertyPath

  260. "responseOptions"

  261. listLabelGroups

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

  262. "recordPath"

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

  263. Conditional Data Collection

  264. JSON to different table tutorial

  265. listInputs

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

  266. getRecordsUsingSQL

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

  267. Label API FAQs

    Frequently Asked Questions about the Label API

  268. createDatabase

    JSON DB "createDatabase" action creates a database

  269. partialKey

  270. Accounts concepts

    Concepts to manage accounts with the accounts API

  271. retentionPeriod

  272. onChangeTrigger

  273. Performance Monitoring

  274. alterIntegrationTable

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

  275. createMqApiSession

    Create a new MQ session

  276. mtconnectDataItemId

  277. mtconnectSequencePropertyPath

  278. onChangeTriggerTags

  279. onChangeScopeTags

  280. describeIntegrationTables

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

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

  282. sourcePayloadDateFormat

  283. revertCodePackage

    Revert the code package to the specified historical version

  284. listBrokerConnections

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

  285. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  286. Data Compression

  287. describeTables

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

  288. getRecordsInKeyRange

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

  289. Using JSON in SQL

  290. File Notification

  291. Grant access privileges

    Tutorial for granting access privileges to accounts

  292. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  293. listIntegrationTables

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

  294. mtconnectDataTypePropertyPath

  295. mtconnectComponentNamePropertyPath

  296. listTopics

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

  297. alterStreamingConnection

    Update a streaming connection

  298. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  299. Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  300. rebuildIndexes

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

  301. describeDataChangeStreams

    View information about specified data change streams

  302. FairCom DB Access Configuration

  303. New user from ADMIN group

  304. truncateRecords

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

  305. mtconnectTimestampPropertyPath

  306. MTConnect tutorials

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

  307. Memory Files

  308. listTables

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

  309. deleteBrokerConnection

    Delete connections to external brokers

  310. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  311. API Reference

    Allen-Bradley connector programming specifications

  312. Standalone Multi-User

  313. Database Backup Guide

  314. Data File Snapshots

  315. createservercert.py

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

  316. Schema Export Utility: dbschema

  317. changeLabels

    Modify sets of labels in bulk

  318. testTransformScope

  319. deleteMqSession

    Disconnect a client's MQ session

  320. Linux Caching Considerations

  321. permanentSession

  322. FairCom DB Server Configuration Recommendations

  323. configureTopic

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

  324. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  325. timeFormat

  326. Data Caching Best Practices

  327. sessionHealth

  328. listTransactions

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

  329. linkLabelsToRecords

  330. Tuning Index Page Size

  331. Label concepts

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

  332. alterTable

    JSON DB "alterTable" action modifies an existing table

  333. deleteDataChangeStreams

    Delete specified data change streams

  334. configureBrokerConnection

    Connect a FairCom Server to an external broker

  335. primaryKeyFields

  336. Sessions and Services API FAQs

    Frequently Asked Questions for the Sessions & services API

  337. transformStepMethod

  338. getRecordsByPartialKeyRange

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

  339. listServices

    Return information about the specified services

  340. mtconnectDataItemIdPropertyPath

  341. createAndStartDataChangeStreams

    Initialize one or more data change streams

  342. Server Best Practices

  343. "propertyPath"

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

  344. path

  345. rollbackTransaction

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

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

  347. deleteSession

    Disconnect a client from Remote Procedure Call service

  348. mtconnectDeviceUuid

  349. Siemens S7 API reference

    Siemens S7 connector programming specifications

  350. describeSessions

    Return a list of session objects

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

  352. revertTransactionToSavepoint

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

  353. describeMqSessions

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