Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

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

Articles by Ked

  1. Driver Setup

  2. Database Backup

  3. Replication

  4. SQL Analytic Functions

  5. Custom Server SDK

  6. Unicode

  7. File Mirroring

  8. Diagnostics

  9. Backward Compatibility

  10. FairCom DB SQL Operations and Utilities Guide

  11. jsonAction request

    List of properties in JSON Action request messages

  12. FairCom DB API for Java Tutorials

  13. jsonAction response

    List of properties in JSON Action response messages

  14. FairCom client Components License Agreement

  15. Tutorials

  16. FairCom DB SQL ADO.NET Data Provider

  17. ISAM API Callbacks

  18. NAV c-treeDB API Callbacks

  19. Administrative Utilities - Client

  20. Utilities - Client

  21. Administrative Utilities - Standalone

  22. Utilities - Low Level

  23. redist Folder

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

  25. ADO.NET Driver Overview

  26. ADO.NET QuickStart

  27. Developing ADO.NET Applications with FairCom DB SQL

  28. FairCom Callbacks Overview

  29. Server SDK Callbacks

  30. Advanced Encryption Master Key Custom Storage Retrieval

  31. Replication API Callbacks

  32. Partitioned Files

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

  34. Compiling

  35. Direct SQL for C and C++ Tutorials

  36. FairCom DB Direct SQL Interface

  37. FairCom DB Direct SQL Function Reference Guide

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

  39. Java Stored Procedures, Triggers, and UDFs

  40. .NET Support

  41. FairCom DB API for VB.Net Overview

  42. FairCom DB API for Java Overview

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

  44. subscribeToMq

    Add or remove a client's subscriptions

  45. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  46. Subsystem

  47. Basic Configuration

  48. Transaction Processing

  49. Glossary

  50. Startup and Shutdown

  51. Recovery

  52. Cache and Memory

  53. I/O Control

  54. File Management

  55. Locking

  56. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  57. Data Change Stream concepts

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

  58. FairCom DB Expression Parser and Grammar

  59. manageService

    Configure settings for a FairCom Edge service

  60. deleteRecords

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

  61. describeCodePackageHistory

    Return historical information about the specified code packages

  62. FairCom Typographical Conventions

  63. Utilities - Standalone

  64. Predefined Functions

  65. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  66. alterInput

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

  67. Overview

  68. FairCom JSON Conventions

  69. SQL Data Load Utility: dbload

  70. commitTransaction

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

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

  72. Data Unload Utility: dbdump

  73. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  74. Function Name Cross Reference

  75. significantMagnitude

  76. listSessions

    Return a list of active sessions

  77. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  78. unlinkLabelsFromRecords

  79. Modbus Data types

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

  80. Glossary

  81. onError

  82. mtconnectCategoryPropertyPath

  83. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  84. Integration tables concepts

    Concepts for the Integration Tables API

  85. createSession

    Log into the FairCom server

  86. mtconnectDataNamePropertyPath

  87. alterSession

    Alter the settings of a session

  88. Using the Low-Level API

  89. createTransactionSavePoint

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

  90. ISAM for C Database Technology

  91. Request properties

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

  92. alterAccount

    Alter an existing account

  93. FairCom DB JSON APIs

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

  94. createCodePackage

    Store JavaScript code in the server

  95. optimizeLabelLinks

  96. describeBrokerConnections

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

  97. listLabels

    Retrieve a filtered list of label names

  98. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  99. Grant rights to an integration table

  100. deleteTables

    JSON DB "deleteTables" action deletes tables

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

  102. Session and Services Concepts

    Concepts for creating and managing sessions and services

  103. JSON to fields tutorial

  104. createStreamingConnection

    Create a streaming connection

  105. Installing on Your Operating System

  106. primaryKeys

  107. normalUpperLimit

  108. listAccounts

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

  109. createIntegrationTable

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

  110. Using JavaScript to perform JSON actions

  111. listCodePackageHistory

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

  112. Configuring FairCom DB

  113. onChangeScope

  114. createTable

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

  115. Performance Optimization

  116. listIndexes

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

  117. OPC UA connector tutorials

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

  118. FairCom MQ APIs

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

  119. createAccount

    Create an account to log into a server

  120. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  121. resumeStreamingConnection

    Activate paused streaming connections

  122. createLabel

    Create a new label

  123. Conditional Expressions Overview

    Overview of the conditional expressions data filters and conditional indexes

  124. listDatabases

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

  125. Fields to JSON tutorial

  126. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  127. getRecordIdsLinkedToLabel

  128. publishMessagesToMq

    Publish messages to a topic from the specified client

  129. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  130. Example property paths that group related properties

  131. deleteStreamingConnection

    Delete specified streaming connections

  132. FairCom DB Utility Programs

  133. listMqSessions

    View a list of sessions that match the "partialClientName"

  134. listOutputs

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

  135. listStreamingConnections

    Return a list of streaming connections that match all specified filters

  136. FairCom ISQL

  137. License Authorization File

  138. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  139. getLabelsLinkedToRecordIds

  140. Conditional Data Persistence Tutorial

  141. Client Communication

  142. Siemens S7 connector tutorials

  143. Multi-User Concepts

  144. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  145. Capacity Planning Considerations

  146. tagName

  147. getRecordsByIds

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

  148. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  149. Logging and Monitoring

  150. getRecordsFromCursor

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

  151. Custom Application Expressions

  152. Backups and Data Integrity

  153. createInput

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

  154. API reference

    Modbus connector programming specifications for FairCom Edge

  155. Master Encryption Key Management

  156. Code packages concepts

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

  157. FairCom DB Configuration Options

  158. assignRolesToAccounts

    Add and remove roles from accounts

  159. createOutput

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

  160. User's Control of Security Options

  161. numberFormat

  162. Create a user account

  163. cloneCodePackage

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

  164. pauseStreamingConnection

    Pause specified streaming connections

  165. variantFormat

  166. sourcePayloadBinaryFormat

  167. Conditional Expression Callback Function

  168. dropAccounts

    Mark an account as dropped from the server

  169. Server-Side Queues

  170. FairCom DB Server Basic Operations

  171. listDataChangeStreams

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

  172. getRecordsStartingAtKey

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

  173. listCodePackages

    Return a list of code packages that match all specified filters

  174. alterLabel

    Modify an existing label

  175. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

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

  177. closeCursor

    JSON DB "closeCursor" action closes a previously opened cursor

  178. updateRecords

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

  179. ISQL Statements

  180. cloneAccount

    Clone an existing account and its roles

  181. testIntegrationTableTransformSteps

    Test new transform steps before running them

  182. mtconnectDeviceUuidPropertyPath

  183. Monitoring FairCom DB

  184. Record Schemas and DODA Resources

  185. sourcePayloadTimeFormat

  186. Security

  187. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  188. EtherNet/IP connector concepts

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

  189. Database Rollback and Roll Forward Guide

  190. padValue

  191. alterCodePackage

    Update the code in the server

  192. Hot Alter Table

  193. primaryKey

  194. deleteOutput

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

  195. describeCodePackages

    Return information about specified code packages

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

  197. alterMqSession

    Alter session settings without disrupting the client

  198. JSONPath

    Use JSONPath to query for JSON values

  199. Sample Programs

  200. Conditional Expression Function Reference

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

  201. Basic Connection String Attributes and Defaults

  202. pingSession

    Identify if there are errors in a FairCom server instance

  203. Unicode

  204. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  205. deleteIntegrationTables

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

  206. FairCom DB Error Codes

  207. describeOutputs

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

  208. Tutorials

    Modbus tutorials for FairCom Edge

  209. runSqlStatements

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

  210. describeAccounts

    Describe roles that the account is authorized to see

  211. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  212. mtconnectDeviceNamePropertyPath

  213. "responseOptions"

  214. listLabelGroups

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

  215. "recordPath"

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

  216. Conditional Data Collection

  217. JSON to different table tutorial

  218. listInputs

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

  219. getRecordsUsingSQL

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

  220. Label API FAQs

    Frequently Asked Questions about the Label API

  221. createDatabase

    JSON DB "createDatabase" action creates a database

  222. partialKey

  223. Accounts concepts

    Concepts to manage accounts with the accounts API

  224. retentionPeriod

  225. FairCom ISAM API for C - Developers Guide Overview

  226. deleteInput

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

  227. onChangeTrigger

  228. Performance Monitoring

  229. alterIntegrationTable

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

  230. createMqApiSession

    Create a new MQ session

  231. FairCom DB Database Engine

  232. mtconnectDataItemId

  233. mtconnectSequencePropertyPath

  234. onChangeTriggerTags

  235. onChangeScopeTags

  236. describeIntegrationTables

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

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

  238. sourcePayloadDateFormat

  239. revertCodePackage

    Revert the code package to the specified historical version

  240. listBrokerConnections

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

  241. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  242. Command-Line Administration Utilities

  243. Data Compression

  244. describeTables

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

  245. getRecordsInKeyRange

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

  246. Using JSON in SQL

  247. File Notification

  248. ISAM for C Data Management

  249. Grant access privileges

    Tutorial for granting access privileges to accounts

  250. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  251. listIntegrationTables

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

  252. mtconnectDataTypePropertyPath

  253. Response properties

  254. mtconnectComponentNamePropertyPath

  255. listTopics

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

  256. alterStreamingConnection

    Update a streaming connection

  257. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  258. FairCom Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  259. rebuildIndexes

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

  260. describeDataChangeStreams

    View information about specified data change streams

  261. ISAM for C Operational Models

  262. FairCom DB Access Configuration

  263. New user from ADMIN group

  264. truncateRecords

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

  265. mtconnectTimestampPropertyPath

  266. MTConnect tutorials

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

  267. Memory Files

  268. listTables

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

  269. deleteBrokerConnection

    Delete connections to external brokers

  270. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  271. Data and Index Files

  272. API Reference

    Allen-Bradley connector programming specifications

  273. Standalone Multi-User

  274. Database Backup Guide

  275. Data File Snapshots

  276. createservercert.py

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

  277. Schema Export Utility: dbschema

  278. changeLabels

    Modify sets of labels in bulk

  279. testTransformScope

  280. Client-Side Operation

  281. createIndex

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

  282. deleteMqSession

    Disconnect a client's MQ session

  283. Linux Caching Considerations

  284. permanentSession

  285. describeInputs

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

  286. FairCom DB Server Configuration Recommendations

  287. configureTopic

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

  288. File Recycle Bin

  289. Transaction Processing (FC API for C)

  290. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  291. timeFormat

  292. Data Caching Best Practices

  293. sessionHealth

  294. listTransactions

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

  295. linkLabelsToRecords

  296. Tuning Index Page Size

  297. Label concepts

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

  298. alterTable

    JSON DB "alterTable" action modifies an existing table

  299. deleteDataChangeStreams

    Delete specified data change streams

  300. configureBrokerConnection

    Connect a FairCom Server to an external broker

  301. primaryKeyFields

  302. Advanced Configuration

  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