Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

Groups: Group::Drop
355 Total Articles
0 This Month
24 Last Month
0 Followers

Articles by Ked

  1. Concepts for querying data

  2. describeValues

  3. describeTags

  4. testOutput

  5. unlinkLabelsFromRecords

  6. FairCom DB API for Java Overview

  7. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  8. alterTag

  9. validateMqttPayload

  10. status (connectors)

  11. Modbus Data types

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

  12. manageService

    Configure settings for a FairCom Edge service

  13. alterMqSession

    Alter session settings without disrupting the client

  14. listAccounts

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

  15. resumeStreamingConnection

    Activate paused streaming connections

  16. Developing ADO.NET Applications with FairCom DB SQL

  17. alterThing

  18. alterInput

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

  19. Advanced Encryption Master Key Custom Storage Retrieval

  20. Industrial Ethernet Connector Concepts

  21. describeThings

  22. tagId

  23. renameKeys

  24. File Mirroring

  25. Diagnostics

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

  27. Client-Side Operation

  28. getRecordsStartingAtKey

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

  29. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  30. createTag

  31. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  32. FairCom DB SQL Operations and Utilities Guide

  33. Modbus connector concepts

  34. testInput

  35. Backward Compatibility

  36. getValues

  37. describeValuesFromHierarchy

  38. Command-Line Administration Utilities

  39. deleteValues

  40. listTags

  41. Administrative Utilities - Client

  42. Function Name Cross Reference

  43. thingName

  44. setValues

  45. Utilities - Low Level

  46. ADO.NET Driver Overview

  47. VB.Net Tutorials

  48. getValuesFromHierarchy

  49. Siemens S7 connector tutorials

  50. OPC UA connector concepts

  51. alterSession

    Alter the settings of a session

  52. SQL Analytic Functions

  53. FairCom DB API for Java Tutorials

  54. Partitioned Files

  55. getKeysFromHierarchy

  56. ISAM API Callbacks

  57. deleteInput

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

  58. FairCom Callbacks Overview

  59. Java Stored Procedures, Triggers, and UDFs

  60. NAV c-treeDB API Callbacks

  61. Replication API Callbacks

  62. Tag action FAQs

  63. deleteThings

  64. HTTP status codes

  65. .NET Support

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

  67. Standalone SQL driver setup

  68. Compiling

  69. FairCom DB FAQs

  70. Client Communication

  71. Advanced Configuration

  72. FairCom DB Direct SQL Function Reference Guide

  73. FairCom ISAM API for C - Developers Guide Overview

  74. listActions

  75. Direct SQL for C and C++ Tutorials

  76. jsonAction response

    List of properties in JSON Action response messages

  77. Multi-User Concepts

  78. redist Folder

  79. Sample Programs

  80. Supported field bus connectors

  81. MQ APIs

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

  82. deleteIntegrationTables

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

  83. Unicode

  84. I/O Control

  85. createIndex

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

  86. ISAM for C Operational Models

  87. Transaction Processing (FC API for C)

  88. DSQL field types and transaction isolation levels

  89. Replication

  90. thingId

  91. deleteTags

  92. createThing

  93. describeInputs

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

  94. listThings

  95. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

  96. jsonAction request

    List of properties in JSON Action request messages

  97. Siemens S7 connector concepts

  98. getRecordIdsLinkedToLabel

  99. MTConnect connector concepts

  100. ISAM for C Data Management

  101. Security

  102. Administrative Utilities - Standalone

  103. Set up FairCom's package repository on Linux

  104. FairCom DB API for VB.Net Overview

  105. Tag action concepts

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

  107. FairCom DB Database Engine

  108. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  109. Query the mqtt_stats table

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

  111. ADO.NET QuickStart

  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. Java and .NET glossary

  119. Startup and Shutdown

  120. Recovery

  121. Cache and Memory

  122. File Management

  123. FairCom DB JSON APIs

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

  124. getRecordsFromCursor

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

  125. ISAM for C Database Technology

  126. FairCom DB Utility Programs

  127. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  128. Data Change Stream concepts

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

  129. FairCom DB Expression Parser and Grammar

  130. Utilities - Client

  131. Data and Index Files

  132. deleteRecords

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

  133. describeCodePackageHistory

    Return historical information about the specified code packages

  134. Utilities - Standalone

  135. FairCom Typographical Conventions

  136. Predefined Functions

  137. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  138. DB overview for admins

  139. FairCom JSON Conventions

  140. SQL Data Load Utility: dbload

  141. commitTransaction

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

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

  143. Data Unload Utility: dbdump

  144. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  145. significantMagnitude

  146. listSessions

    Return a list of active sessions

  147. Glossary

  148. onError

  149. mtconnectCategoryPropertyPath

  150. Integration tables concepts

    Concepts for the Integration Tables API

  151. mtconnectDataNamePropertyPath

  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. Grant rights to an integration table

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

  160. Sessions and services concepts

    Concepts for creating and managing sessions and services

  161. JSON to fields tutorial

  162. createStreamingConnection

    Create a streaming connection

  163. Installing on Your Operating System

  164. primaryKeys

  165. normalUpperLimit

  166. createIntegrationTable

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

  167. Using JavaScript to perform JSON actions

  168. listCodePackageHistory

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

  169. Configuring FairCom DB

  170. onChangeScope

  171. listIndexes

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

  172. createAccount

    Create an account to log into a server

  173. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  174. createLabel

    Create a new label

  175. Conditional Expressions Overview

    Overview of the conditional expressions data filters and conditional indexes

  176. listDatabases

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

  177. Fields to JSON tutorial

  178. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  179. publishMessagesToMq

    Publish messages to a topic from the specified client

  180. Example property paths that group related properties

  181. deleteStreamingConnection

    Delete specified streaming connections

  182. listMqSessions

    View a list of sessions that match the "partialClientName"

  183. listOutputs

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

  184. listStreamingConnections

    Return a list of streaming connections that match all specified filters

  185. FairCom ISQL

  186. License Authorization File

  187. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  188. getLabelsLinkedToRecordIds

  189. Conditional Data Persistence Tutorial

  190. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  191. Capacity Planning Considerations

  192. tagName

  193. getRecordsByIds

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

  194. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  195. Logging and Monitoring

  196. Custom Application Expressions

  197. Backups and Data Integrity

  198. Modbus API reference

    Modbus connector programming specifications for FairCom Edge

  199. Master Encryption Key Management

  200. Code packages concepts

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

  201. FairCom DB Configuration Options

  202. assignRolesToAccounts

    Add and remove roles from accounts

  203. createOutput

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

  204. User's Control of Security Options

  205. numberFormat

  206. Create a user account

  207. cloneCodePackage

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

  208. pauseStreamingConnection

    Pause specified streaming connections

  209. variantFormat

  210. sourcePayloadBinaryFormat

  211. Conditional Expression Callback Function

  212. dropAccounts

    Mark an account as dropped from the server

  213. Server-Side Queues

  214. FairCom DB Server Basic Operations

  215. listDataChangeStreams

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

  216. listCodePackages

    Return a list of code packages that match all specified filters

  217. alterLabel

    Modify an existing label

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

  219. closeCursor

    JSON DB "closeCursor" action closes a previously opened cursor

  220. updateRecords

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

  221. ISQL Statements Overview

  222. cloneAccount

    Clone an existing account and its roles

  223. testIntegrationTableTransformSteps

    Test new transform steps before running them

  224. mtconnectDeviceUuidPropertyPath

  225. Monitoring FairCom DB

  226. Record Schemas and DODA Resources

  227. sourcePayloadTimeFormat

  228. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  229. EtherNet/IP connector concepts

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

  230. padValue

  231. alterCodePackage

    Update the code in the server

  232. Hot Alter Table

  233. primaryKey

  234. describeCodePackages

    Return information about specified code packages

  235. deleteOutput

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

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

  237. JSONPath

    Use JSONPath to query for JSON values

  238. Conditional Expression Function Reference

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

  239. Basic Connection String Attributes and Defaults

  240. pingSession

    Identify if there are errors in a FairCom server instance

  241. Unicode for Standalone

  242. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  243. FairCom DB Error Codes

  244. describeOutputs

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

  245. runSqlStatements

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

  246. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  247. describeAccounts

    Describe roles that the account is authorized to see

  248. mtconnectDeviceNamePropertyPath

  249. listLabelGroups

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

  250. "recordPath"

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

  251. Conditional Data Collection

  252. JSON to different table tutorial

  253. listInputs

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

  254. getRecordsUsingSQL

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

  255. Label API FAQs

    Frequently Asked Questions about the Label API

  256. createDatabase

    JSON DB "createDatabase" action creates a database

  257. partialKey

  258. Accounts concepts

    Concepts to manage accounts with the accounts API

  259. retentionPeriod

  260. onChangeTrigger

  261. Performance Monitoring

  262. alterIntegrationTable

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

  263. createMqApiSession

    Create a new MQ session

  264. mtconnectDataItemId

  265. mtconnectSequencePropertyPath

  266. onChangeTriggerTags

  267. onChangeScopeTags

  268. describeIntegrationTables

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

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

  270. revertCodePackage

    Revert the code package to the specified historical version

  271. listBrokerConnections

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

  272. Data Compression

  273. describeTables

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

  274. getRecordsInKeyRange

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

  275. Using JSON in SQL

  276. File Notification

  277. Grant access privileges

    Tutorial for granting access privileges to accounts

  278. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  279. listIntegrationTables

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

  280. mtconnectDataTypePropertyPath

  281. mtconnectComponentNamePropertyPath

  282. listTopics

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

  283. alterStreamingConnection

    Update a streaming connection

  284. rebuildIndexes

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

  285. describeDataChangeStreams

    View information about specified data change streams

  286. FairCom DB Access Configuration

  287. New user from ADMIN group

  288. truncateRecords

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

  289. mtconnectTimestampPropertyPath

  290. MTConnect tutorials

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

  291. Memory Files

  292. listTables

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

  293. deleteBrokerConnection

    Delete connections to external brokers

  294. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  295. EtherNet/IP API Reference

    Allen-Bradley connector programming specifications

  296. Standalone Multi-User

  297. Database Backup Guide

  298. Data File Snapshots

  299. createservercert.py

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

  300. Schema Export Utility: dbschema

  301. changeLabels

    Modify sets of labels in bulk

  302. testTransformScope

  303. deleteMqSession

    Disconnect a client's MQ session

  304. Linux Caching Considerations

  305. permanentSession

  306. FairCom DB Server Configuration Recommendations

  307. configureTopic

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

  308. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  309. sessionHealth

  310. listTransactions

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

  311. linkLabelsToRecords

  312. Tuning Index Page Size

  313. Label concepts

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

  314. alterTable

    JSON DB "alterTable" action modifies an existing table

  315. deleteDataChangeStreams

    Delete specified data change streams

  316. FairCom DB SQL ADO.NET Data Provider

  317. createInput

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

  318. createSession

    Log into the FairCom server

  319. "responseOptions"

  320. Performance Optimization

  321. configureBrokerConnection

    Connect a FairCom Server to an external broker

  322. Data Caching Best Practices

  323. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  324. Locking

  325. Database Backup

  326. Using the Low-Level API

  327. timeFormat

  328. sourcePayloadDateFormat

  329. createTable

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

  330. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  331. primaryKeyFields

  332. deleteTables

    JSON DB "deleteTables" action deletes tables

  333. subscribeToMq

    Add or remove a client's subscriptions

  334. Sessions and Services API FAQs

    Frequently Asked Questions for the Sessions & services API

  335. License files

    License files for FairCom products

  336. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  337. Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  338. Modbus tutorials

    Modbus tutorials for FairCom Edge

  339. transformStepMethod

  340. getRecordsByPartialKeyRange

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

  341. listServices

    Return information about the specified services

  342. mtconnectDataItemIdPropertyPath

  343. createAndStartDataChangeStreams

    Initialize one or more data change streams

  344. Server Best Practices

  345. "propertyPath"

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

  346. path

  347. rollbackTransaction

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

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

  349. deleteSession

    Disconnect a client from Remote Procedure Call service

  350. mtconnectDeviceUuid

  351. Siemens S7 API reference

    Siemens S7 connector programming specifications

  352. describeSessions

    Return a list of session objects

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

  354. revertTransactionToSavepoint

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

  355. describeMqSessions

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