Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

Groups: Group::Drop
329 Total Articles
4 This Month
11 Last Month
0 Followers

Articles by Ked

  1. Diagnostics

  2. describeInputs

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

  3. thingName

  4. Backward Compatibility

  5. Unicode

  6. status (connectors)

  7. FairCom DB FAQs

  8. File Mirroring

  9. FairCom DB Database Engine

  10. Function Name Cross Reference

  11. deleteInput

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

  12. I/O Control

  13. Client-Side Operation

  14. Concepts

  15. Siemens S7 connector tutorials

  16. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  17. OPC UA connector concepts

  18. Supported field bus connectors

  19. tagId

  20. FairCom DB SQL ADO.NET Data Provider

  21. .NET Support

  22. validateMqttPayload

  23. thingId

  24. Response properties

  25. ISAM for C Operational Models

  26. Developing ADO.NET Applications with FairCom DB SQL

  27. Modbus connector concepts

  28. Industrial Ethernet Connector Concepts

  29. MTConnect connector concepts

  30. Siemens S7 connector concepts

  31. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  32. listActions

  33. Tutorials

  34. Java Stored Procedures, Triggers, and UDFs

  35. Replication

  36. Transaction Processing (FC API for C)

  37. SQL Analytic Functions

  38. Utilities - Low Level

  39. ADO.NET Driver Overview

  40. ADO.NET QuickStart

  41. FairCom DB SQL Operations and Utilities Guide

  42. FairCom DB API for Java Tutorials

  43. Partitioned Files

  44. Advanced Encryption Master Key Custom Storage Retrieval

  45. ISAM API Callbacks

  46. FairCom Callbacks Overview

  47. NAV c-treeDB API Callbacks

  48. Replication API Callbacks

  49. FairCom DB Utility Programs

  50. ISAM for C Database Technology

  51. unlinkLabelsFromRecords

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

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

  54. Command-Line Administration Utilities

  55. Utilities - Client

  56. Compiling

  57. Client Communication

  58. Advanced Configuration

  59. jsonAction response

    List of properties in JSON Action response messages

  60. FairCom DB Direct SQL Function Reference Guide

  61. FairCom ISAM API for C - Developers Guide Overview

  62. Direct SQL for C and C++ Tutorials

  63. Multi-User Concepts

  64. createIndex

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

  65. redist Folder

  66. Sample Programs

  67. DSQL field types and transaction isolation levels

  68. jsonAction request

    List of properties in JSON Action request messages

  69. Administrative Utilities - Client

  70. ISAM for C Data Management

  71. Administrative Utilities - Standalone

  72. Driver Setup

  73. FairCom DB API for VB.Net Overview

  74. FairCom DB API for Java Overview

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

  76. Data and Index Files

  77. subscribeToMq

    Add or remove a client's subscriptions

  78. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  79. Query the mqtt_stats table

  80. Database Backup

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

  82. Subsystem

  83. Basic Configuration

  84. Transaction Processing

  85. Glossary

  86. Startup and Shutdown

  87. Recovery

  88. Cache and Memory

  89. File Management

  90. Locking

  91. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  92. Data Change Stream concepts

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

  93. FairCom DB Expression Parser and Grammar

  94. manageService

    Configure settings for a FairCom Edge service

  95. deleteRecords

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

  96. describeCodePackageHistory

    Return historical information about the specified code packages

  97. Utilities - Standalone

  98. FairCom Typographical Conventions

  99. Predefined Functions

  100. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  101. alterInput

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

  102. Overview

  103. FairCom JSON Conventions

  104. SQL Data Load Utility: dbload

  105. commitTransaction

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

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

  107. Data Unload Utility: dbdump

  108. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  109. significantMagnitude

  110. listSessions

    Return a list of active sessions

  111. Modbus Data types

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

  112. Glossary

  113. onError

  114. mtconnectCategoryPropertyPath

  115. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  116. Integration tables concepts

    Concepts for the Integration Tables API

  117. createSession

    Log into the FairCom server

  118. mtconnectDataNamePropertyPath

  119. alterSession

    Alter the settings of a session

  120. Using the Low-Level API

  121. createTransactionSavePoint

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

  122. Request properties

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

  123. alterAccount

    Alter an existing account

  124. FairCom DB JSON APIs

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

  125. createCodePackage

    Store JavaScript code in the server

  126. optimizeLabelLinks

  127. describeBrokerConnections

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

  128. listLabels

    Retrieve a filtered list of label names

  129. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  130. Grant rights to an integration table

  131. deleteTables

    JSON DB "deleteTables" action deletes tables

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

  133. Session and Services Concepts

    Concepts for creating and managing sessions and services

  134. JSON to fields tutorial

  135. createStreamingConnection

    Create a streaming connection

  136. Installing on Your Operating System

  137. primaryKeys

  138. normalUpperLimit

  139. listAccounts

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

  140. createIntegrationTable

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

  141. Using JavaScript to perform JSON actions

  142. listCodePackageHistory

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

  143. Configuring FairCom DB

  144. onChangeScope

  145. createTable

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

  146. Performance Optimization

  147. listIndexes

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

  148. FairCom MQ APIs

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

  149. createAccount

    Create an account to log into a server

  150. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  151. resumeStreamingConnection

    Activate paused streaming connections

  152. createLabel

    Create a new label

  153. Conditional Expressions Overview

    Overview of the conditional expressions data filters and conditional indexes

  154. listDatabases

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

  155. Fields to JSON tutorial

  156. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  157. getRecordIdsLinkedToLabel

  158. publishMessagesToMq

    Publish messages to a topic from the specified client

  159. Example property paths that group related properties

  160. deleteStreamingConnection

    Delete specified streaming connections

  161. listMqSessions

    View a list of sessions that match the "partialClientName"

  162. listOutputs

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

  163. listStreamingConnections

    Return a list of streaming connections that match all specified filters

  164. FairCom ISQL

  165. License Authorization File

  166. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  167. getLabelsLinkedToRecordIds

  168. Conditional Data Persistence Tutorial

  169. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  170. Capacity Planning Considerations

  171. tagName

  172. getRecordsByIds

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

  173. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  174. Logging and Monitoring

  175. getRecordsFromCursor

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

  176. Custom Application Expressions

  177. Backups and Data Integrity

  178. createInput

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

  179. API reference

    Modbus connector programming specifications for FairCom Edge

  180. Master Encryption Key Management

  181. Code packages concepts

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

  182. FairCom DB Configuration Options

  183. assignRolesToAccounts

    Add and remove roles from accounts

  184. createOutput

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

  185. User's Control of Security Options

  186. numberFormat

  187. Create a user account

  188. cloneCodePackage

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

  189. pauseStreamingConnection

    Pause specified streaming connections

  190. variantFormat

  191. sourcePayloadBinaryFormat

  192. Conditional Expression Callback Function

  193. dropAccounts

    Mark an account as dropped from the server

  194. Server-Side Queues

  195. FairCom DB Server Basic Operations

  196. listDataChangeStreams

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

  197. getRecordsStartingAtKey

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

  198. listCodePackages

    Return a list of code packages that match all specified filters

  199. alterLabel

    Modify an existing label

  200. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

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

  202. closeCursor

    JSON DB "closeCursor" action closes a previously opened cursor

  203. updateRecords

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

  204. ISQL Statements Overview

  205. cloneAccount

    Clone an existing account and its roles

  206. testIntegrationTableTransformSteps

    Test new transform steps before running them

  207. mtconnectDeviceUuidPropertyPath

  208. Monitoring FairCom DB

  209. Record Schemas and DODA Resources

  210. sourcePayloadTimeFormat

  211. Security

  212. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  213. EtherNet/IP connector concepts

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

  214. padValue

  215. alterCodePackage

    Update the code in the server

  216. Hot Alter Table

  217. primaryKey

  218. deleteOutput

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

  219. describeCodePackages

    Return information about specified code packages

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

  221. alterMqSession

    Alter session settings without disrupting the client

  222. JSONPath

    Use JSONPath to query for JSON values

  223. Conditional Expression Function Reference

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

  224. Basic Connection String Attributes and Defaults

  225. pingSession

    Identify if there are errors in a FairCom server instance

  226. Unicode for Standalone

  227. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  228. deleteIntegrationTables

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

  229. FairCom DB Error Codes

  230. describeOutputs

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

  231. Tutorials

    Modbus tutorials for FairCom Edge

  232. runSqlStatements

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

  233. describeAccounts

    Describe roles that the account is authorized to see

  234. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  235. mtconnectDeviceNamePropertyPath

  236. "responseOptions"

  237. listLabelGroups

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

  238. "recordPath"

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

  239. Conditional Data Collection

  240. JSON to different table tutorial

  241. listInputs

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

  242. getRecordsUsingSQL

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

  243. Label API FAQs

    Frequently Asked Questions about the Label API

  244. createDatabase

    JSON DB "createDatabase" action creates a database

  245. partialKey

  246. Accounts concepts

    Concepts to manage accounts with the accounts API

  247. retentionPeriod

  248. onChangeTrigger

  249. Performance Monitoring

  250. alterIntegrationTable

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

  251. createMqApiSession

    Create a new MQ session

  252. mtconnectDataItemId

  253. mtconnectSequencePropertyPath

  254. onChangeTriggerTags

  255. onChangeScopeTags

  256. describeIntegrationTables

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

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

  258. sourcePayloadDateFormat

  259. revertCodePackage

    Revert the code package to the specified historical version

  260. listBrokerConnections

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

  261. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  262. Data Compression

  263. describeTables

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

  264. getRecordsInKeyRange

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

  265. Using JSON in SQL

  266. File Notification

  267. Grant access privileges

    Tutorial for granting access privileges to accounts

  268. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  269. listIntegrationTables

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

  270. mtconnectDataTypePropertyPath

  271. mtconnectComponentNamePropertyPath

  272. listTopics

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

  273. alterStreamingConnection

    Update a streaming connection

  274. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  275. FairCom Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  276. rebuildIndexes

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

  277. describeDataChangeStreams

    View information about specified data change streams

  278. FairCom DB Access Configuration

  279. New user from ADMIN group

  280. truncateRecords

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

  281. mtconnectTimestampPropertyPath

  282. MTConnect tutorials

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

  283. Memory Files

  284. listTables

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

  285. deleteBrokerConnection

    Delete connections to external brokers

  286. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  287. API Reference

    Allen-Bradley connector programming specifications

  288. Standalone Multi-User

  289. Database Backup Guide

  290. Data File Snapshots

  291. createservercert.py

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

  292. Schema Export Utility: dbschema

  293. changeLabels

    Modify sets of labels in bulk

  294. testTransformScope

  295. deleteMqSession

    Disconnect a client's MQ session

  296. Linux Caching Considerations

  297. permanentSession

  298. FairCom DB Server Configuration Recommendations

  299. configureTopic

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

  300. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  301. timeFormat

  302. Data Caching Best Practices

  303. sessionHealth

  304. listTransactions

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

  305. linkLabelsToRecords

  306. Tuning Index Page Size

  307. Label concepts

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

  308. alterTable

    JSON DB "alterTable" action modifies an existing table

  309. deleteDataChangeStreams

    Delete specified data change streams

  310. configureBrokerConnection

    Connect a FairCom Server to an external broker

  311. primaryKeyFields

  312. Sessions and Services API FAQs

    Frequently Asked Questions for the Sessions & services API

  313. transformStepMethod

  314. getRecordsByPartialKeyRange

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

  315. listServices

    Return information about the specified services

  316. mtconnectDataItemIdPropertyPath

  317. createAndStartDataChangeStreams

    Initialize one or more data change streams

  318. Server Best Practices

  319. "propertyPath"

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

  320. path

  321. rollbackTransaction

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

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

  323. deleteSession

    Disconnect a client from Remote Procedure Call service

  324. mtconnectDeviceUuid

  325. Siemens S7 API reference

    Siemens S7 connector programming specifications

  326. describeSessions

    Return a list of session objects

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

  328. revertTransactionToSavepoint

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

  329. describeMqSessions

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