Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

Groups: Group::Drop
320 Total Articles
0 This Month
1 Last Month
0 Followers

Articles by Ked

  1. FairCom ISAM API for C - Developers Guide Overview

  2. Database Backup

  3. Advanced Encryption Master Key Custom Storage Retrieval

  4. Diagnostics

  5. Administrative Utilities - Client

  6. ISAM for C Data Management

  7. ISAM for C Operational Models

  8. Driver Setup

  9. FairCom DB SQL ADO.NET Data Provider

  10. Multi-User Concepts

  11. jsonAction request

    List of properties in JSON Action request messages

  12. Command-Line Administration Utilities

  13. .NET Support

  14. Query the mqtt_stats table

  15. FairCom DB API for Java Tutorials

  16. Function Name Cross Reference

  17. ISAM API Callbacks

  18. Administrative Utilities - Standalone

  19. Data and Index Files

  20. jsonAction response

    List of properties in JSON Action response messages

  21. Java Stored Procedures, Triggers, and UDFs

  22. SQL Analytic Functions

  23. Concepts

  24. Advanced Configuration

  25. Tutorials

  26. FairCom DB SQL Operations and Utilities Guide

  27. ISAM for C Database Technology

  28. Utilities - Client

  29. FairCom DB Utility Programs

  30. Transaction Processing (FC API for C)

  31. Custom Server SDK

  32. unlinkLabelsFromRecords

  33. Replication

  34. Unicode

  35. Utilities - Low Level

  36. Sample Programs

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

  38. ADO.NET Driver Overview

  39. ADO.NET QuickStart

  40. NAV c-treeDB API Callbacks

  41. Partitioned Files

  42. Server SDK Callbacks

  43. Developing ADO.NET Applications with FairCom DB SQL

  44. Replication API Callbacks

  45. File Mirroring

  46. Backward Compatibility

  47. FairCom Callbacks Overview

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

  49. Compiling

  50. DSQL field types and transaction isolation levels

  51. FairCom DB Direct SQL Function Reference Guide

  52. Direct SQL for C and C++ Tutorials

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

  54. redist Folder

  55. FairCom DB API for VB.Net Overview

  56. FairCom DB API for Java Overview

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

  58. subscribeToMq

    Add or remove a client's subscriptions

  59. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  60. Subsystem

  61. Basic Configuration

  62. Transaction Processing

  63. Glossary

  64. Startup and Shutdown

  65. Recovery

  66. Cache and Memory

  67. Locking

  68. I/O Control

  69. File Management

  70. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  71. Data Change Stream concepts

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

  72. FairCom DB Expression Parser and Grammar

  73. manageService

    Configure settings for a FairCom Edge service

  74. deleteRecords

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

  75. describeCodePackageHistory

    Return historical information about the specified code packages

  76. Utilities - Standalone

  77. FairCom Typographical Conventions

  78. Predefined Functions

  79. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  80. alterInput

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

  81. Overview

  82. FairCom JSON Conventions

  83. SQL Data Load Utility: dbload

  84. commitTransaction

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

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

  86. Data Unload Utility: dbdump

  87. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  88. significantMagnitude

  89. listSessions

    Return a list of active sessions

  90. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  91. Modbus Data types

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

  92. Glossary

  93. onError

  94. mtconnectCategoryPropertyPath

  95. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  96. Integration tables concepts

    Concepts for the Integration Tables API

  97. createSession

    Log into the FairCom server

  98. mtconnectDataNamePropertyPath

  99. alterSession

    Alter the settings of a session

  100. Using the Low-Level API

  101. createTransactionSavePoint

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

  102. Request properties

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

  103. alterAccount

    Alter an existing account

  104. FairCom DB JSON APIs

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

  105. createCodePackage

    Store JavaScript code in the server

  106. optimizeLabelLinks

  107. describeBrokerConnections

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

  108. listLabels

    Retrieve a filtered list of label names

  109. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  110. Grant rights to an integration table

  111. deleteTables

    JSON DB "deleteTables" action deletes tables

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

  113. Session and Services Concepts

    Concepts for creating and managing sessions and services

  114. JSON to fields tutorial

  115. createStreamingConnection

    Create a streaming connection

  116. Installing on Your Operating System

  117. primaryKeys

  118. normalUpperLimit

  119. listAccounts

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

  120. createIntegrationTable

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

  121. Using JavaScript to perform JSON actions

  122. listCodePackageHistory

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

  123. Configuring FairCom DB

  124. onChangeScope

  125. createTable

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

  126. Performance Optimization

  127. listIndexes

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

  128. OPC UA connector tutorials

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

  129. FairCom MQ APIs

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

  130. createAccount

    Create an account to log into a server

  131. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  132. resumeStreamingConnection

    Activate paused streaming connections

  133. createLabel

    Create a new label

  134. Conditional Expressions Overview

    Overview of the conditional expressions data filters and conditional indexes

  135. listDatabases

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

  136. Fields to JSON tutorial

  137. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  138. getRecordIdsLinkedToLabel

  139. publishMessagesToMq

    Publish messages to a topic from the specified client

  140. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  141. Example property paths that group related properties

  142. deleteStreamingConnection

    Delete specified streaming connections

  143. listMqSessions

    View a list of sessions that match the "partialClientName"

  144. listOutputs

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

  145. listStreamingConnections

    Return a list of streaming connections that match all specified filters

  146. FairCom ISQL

  147. License Authorization File

  148. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  149. getLabelsLinkedToRecordIds

  150. Conditional Data Persistence Tutorial

  151. Client Communication

  152. Siemens S7 connector tutorials

  153. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  154. Capacity Planning Considerations

  155. tagName

  156. getRecordsByIds

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

  157. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  158. Logging and Monitoring

  159. getRecordsFromCursor

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

  160. Custom Application Expressions

  161. Backups and Data Integrity

  162. createInput

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

  163. API reference

    Modbus connector programming specifications for FairCom Edge

  164. Master Encryption Key Management

  165. Code packages concepts

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

  166. FairCom DB Configuration Options

  167. assignRolesToAccounts

    Add and remove roles from accounts

  168. createOutput

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

  169. User's Control of Security Options

  170. numberFormat

  171. Create a user account

  172. cloneCodePackage

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

  173. pauseStreamingConnection

    Pause specified streaming connections

  174. variantFormat

  175. sourcePayloadBinaryFormat

  176. Conditional Expression Callback Function

  177. dropAccounts

    Mark an account as dropped from the server

  178. Server-Side Queues

  179. FairCom DB Server Basic Operations

  180. listDataChangeStreams

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

  181. getRecordsStartingAtKey

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

  182. listCodePackages

    Return a list of code packages that match all specified filters

  183. alterLabel

    Modify an existing label

  184. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

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

  186. closeCursor

    JSON DB "closeCursor" action closes a previously opened cursor

  187. updateRecords

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

  188. ISQL Statements Overview

  189. cloneAccount

    Clone an existing account and its roles

  190. testIntegrationTableTransformSteps

    Test new transform steps before running them

  191. mtconnectDeviceUuidPropertyPath

  192. Monitoring FairCom DB

  193. Record Schemas and DODA Resources

  194. sourcePayloadTimeFormat

  195. Security

  196. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  197. EtherNet/IP connector concepts

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

  198. padValue

  199. alterCodePackage

    Update the code in the server

  200. Hot Alter Table

  201. primaryKey

  202. deleteOutput

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

  203. describeCodePackages

    Return information about specified code packages

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

  205. alterMqSession

    Alter session settings without disrupting the client

  206. JSONPath

    Use JSONPath to query for JSON values

  207. Conditional Expression Function Reference

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

  208. Basic Connection String Attributes and Defaults

  209. pingSession

    Identify if there are errors in a FairCom server instance

  210. Unicode for Standalone

  211. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  212. deleteIntegrationTables

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

  213. FairCom DB Error Codes

  214. describeOutputs

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

  215. Tutorials

    Modbus tutorials for FairCom Edge

  216. runSqlStatements

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

  217. describeAccounts

    Describe roles that the account is authorized to see

  218. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  219. mtconnectDeviceNamePropertyPath

  220. "responseOptions"

  221. listLabelGroups

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

  222. "recordPath"

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

  223. Conditional Data Collection

  224. JSON to different table tutorial

  225. listInputs

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

  226. getRecordsUsingSQL

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

  227. Label API FAQs

    Frequently Asked Questions about the Label API

  228. createDatabase

    JSON DB "createDatabase" action creates a database

  229. partialKey

  230. Accounts concepts

    Concepts to manage accounts with the accounts API

  231. retentionPeriod

  232. deleteInput

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

  233. onChangeTrigger

  234. Performance Monitoring

  235. alterIntegrationTable

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

  236. createMqApiSession

    Create a new MQ session

  237. FairCom DB Database Engine

  238. mtconnectDataItemId

  239. mtconnectSequencePropertyPath

  240. onChangeTriggerTags

  241. onChangeScopeTags

  242. describeIntegrationTables

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

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

  244. sourcePayloadDateFormat

  245. revertCodePackage

    Revert the code package to the specified historical version

  246. listBrokerConnections

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

  247. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  248. Data Compression

  249. describeTables

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

  250. getRecordsInKeyRange

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

  251. Using JSON in SQL

  252. File Notification

  253. Grant access privileges

    Tutorial for granting access privileges to accounts

  254. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  255. listIntegrationTables

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

  256. mtconnectDataTypePropertyPath

  257. Response properties

  258. mtconnectComponentNamePropertyPath

  259. listTopics

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

  260. alterStreamingConnection

    Update a streaming connection

  261. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  262. FairCom Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  263. rebuildIndexes

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

  264. describeDataChangeStreams

    View information about specified data change streams

  265. FairCom DB Access Configuration

  266. New user from ADMIN group

  267. truncateRecords

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

  268. mtconnectTimestampPropertyPath

  269. MTConnect tutorials

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

  270. Memory Files

  271. listTables

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

  272. deleteBrokerConnection

    Delete connections to external brokers

  273. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  274. API Reference

    Allen-Bradley connector programming specifications

  275. Standalone Multi-User

  276. Database Backup Guide

  277. Data File Snapshots

  278. createservercert.py

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

  279. Schema Export Utility: dbschema

  280. changeLabels

    Modify sets of labels in bulk

  281. testTransformScope

  282. Client-Side Operation

  283. createIndex

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

  284. deleteMqSession

    Disconnect a client's MQ session

  285. Linux Caching Considerations

  286. permanentSession

  287. describeInputs

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

  288. FairCom DB Server Configuration Recommendations

  289. configureTopic

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

  290. File Recycle Bin

  291. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  292. timeFormat

  293. Data Caching Best Practices

  294. sessionHealth

  295. listTransactions

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

  296. linkLabelsToRecords

  297. Tuning Index Page Size

  298. Label concepts

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

  299. alterTable

    JSON DB "alterTable" action modifies an existing table

  300. deleteDataChangeStreams

    Delete specified data change streams

  301. configureBrokerConnection

    Connect a FairCom Server to an external broker

  302. primaryKeyFields

  303. Sessions and Services API FAQs

    Frequently Asked Questions for the Sessions & services API

  304. transformStepMethod

  305. getRecordsByPartialKeyRange

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

  306. listServices

    Return information about the specified services

  307. mtconnectDataItemIdPropertyPath

  308. createAndStartDataChangeStreams

    Initialize one or more data change streams

  309. Server Best Practices

  310. "propertyPath"

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

  311. path

  312. rollbackTransaction

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

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

  314. deleteSession

    Disconnect a client from Remote Procedure Call service

  315. mtconnectDeviceUuid

  316. Siemens S7 API reference

    Siemens S7 connector programming specifications

  317. describeSessions

    Return a list of session objects

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

  319. revertTransactionToSavepoint

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

  320. describeMqSessions

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