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. ISAM for C Operational Models

  5. getValues

  6. getKeysFromHierarchy

  7. deleteTags

  8. FairCom DB SQL Operations and Utilities Guide

  9. HTTP status codes

  10. describeTags

  11. Developing ADO.NET Applications with FairCom DB SQL

  12. Transaction Processing (FC API for C)

  13. createInput

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

  14. getRecordIdsLinkedToLabel

  15. getValuesFromHierarchy

  16. alterThing

  17. deleteThings

  18. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

  19. listThings

  20. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

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

  34. Java Stored Procedures, Triggers, and UDFs

  35. describeThings

  36. Siemens S7 connector concepts

  37. resumeStreamingConnection

    Activate paused streaming connections

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

  45. Unicode

  46. alterInput

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

  47. I/O Control

  48. renameKeys

  49. tagId

  50. FairCom DB FAQs

  51. alterTag

  52. MQ APIs

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

  53. Supported field bus connectors

  54. describeValuesFromHierarchy

  55. Client-Side Operation

  56. OPC UA connector concepts

  57. Modbus connector concepts

  58. Function Name Cross Reference

  59. MTConnect connector concepts

  60. Backward Compatibility

  61. File Mirroring

  62. describeValues

  63. Tag action FAQs

  64. Diagnostics

  65. Administrative Utilities - Client

  66. Tutorials

  67. .NET Support

  68. Replication

  69. validateMqttPayload

  70. listTags

  71. ADO.NET QuickStart

  72. Siemens S7 connector tutorials

  73. describeInputs

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

  74. FairCom DB API for Java Tutorials

  75. Partitioned Files

  76. ISAM API Callbacks

  77. FairCom Callbacks Overview

  78. NAV c-treeDB API Callbacks

  79. Replication API Callbacks

  80. FairCom DB Utility Programs

  81. FairCom DB SQL ADO.NET Data Provider

  82. ISAM for C Database Technology

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

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

  85. Command-Line Administration Utilities

  86. Utilities - Client

  87. Compiling

  88. Client Communication

  89. Advanced Configuration

  90. jsonAction response

    List of properties in JSON Action response messages

  91. FairCom DB Direct SQL Function Reference Guide

  92. FairCom ISAM API for C - Developers Guide Overview

  93. Direct SQL for C and C++ Tutorials

  94. Multi-User Concepts

  95. redist Folder

  96. Sample Programs

  97. DSQL field types and transaction isolation levels

  98. jsonAction request

    List of properties in JSON Action request messages

  99. ISAM for C Data Management

  100. Administrative Utilities - Standalone

  101. FairCom DB API for VB.Net Overview

  102. Tag action concepts

  103. FairCom DB API for Java Overview

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

  105. Data and Index Files

  106. Driver Setup

  107. FairCom DB Database Engine

  108. subscribeToMq

    Add or remove a client's subscriptions

  109. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  110. Query the mqtt_stats table

  111. Database Backup

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

  113. Thing API concepts

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

  114. Thing API FAQs

  115. Key-Value concepts

  116. Subsystem

  117. Basic Configuration

  118. Transaction Processing

  119. Glossary

  120. Startup and Shutdown

  121. Recovery

  122. Cache and Memory

  123. File Management

  124. Locking

  125. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  126. Data Change Stream concepts

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

  127. FairCom DB Expression Parser and Grammar

  128. manageService

    Configure settings for a FairCom Edge service

  129. deleteRecords

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

  130. describeCodePackageHistory

    Return historical information about the specified code packages

  131. Utilities - Standalone

  132. FairCom Typographical Conventions

  133. Predefined Functions

  134. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  135. DB overview for admins

  136. FairCom JSON Conventions

  137. SQL Data Load Utility: dbload

  138. commitTransaction

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

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

  140. Data Unload Utility: dbdump

  141. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  142. significantMagnitude

  143. listSessions

    Return a list of active sessions

  144. Glossary

  145. onError

  146. mtconnectCategoryPropertyPath

  147. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  148. Integration tables concepts

    Concepts for the Integration Tables API

  149. createSession

    Log into the FairCom server

  150. mtconnectDataNamePropertyPath

  151. alterSession

    Alter the settings of a session

  152. Using the Low-Level API

  153. createTransactionSavePoint

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

  154. alterAccount

    Alter an existing account

  155. createCodePackage

    Store JavaScript code in the server

  156. optimizeLabelLinks

  157. describeBrokerConnections

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

  158. listLabels

    Retrieve a filtered list of label names

  159. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  160. Grant rights to an integration table

  161. deleteTables

    JSON DB "deleteTables" action deletes tables

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

  163. Session and Services Concepts

    Concepts for creating and managing sessions and services

  164. JSON to fields tutorial

  165. createStreamingConnection

    Create a streaming connection

  166. Installing on Your Operating System

  167. primaryKeys

  168. normalUpperLimit

  169. listAccounts

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

  170. createIntegrationTable

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

  171. Using JavaScript to perform JSON actions

  172. listCodePackageHistory

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

  173. Configuring FairCom DB

  174. onChangeScope

  175. createTable

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

  176. Performance Optimization

  177. listIndexes

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

  178. createAccount

    Create an account to log into a server

  179. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  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