Ked Peregoy

Ked Peregoy

kedryn.peregoy@faircom.com

Groups: Group::Drop
398 Total Articles
26 This Month
6 Last Month
0 Followers

Articles by Ked

  1. File Notification

  2. Direct SQL for C and C++ Tutorials

  3. SLMP Quickstart tutorial

  4. Advanced Authorization Overview

  5. createRole

  6. Modbus emulator - how to read and write data

  7. Advanced Encryption Master Key Custom Storage Retrieval

  8. Tag action FAQs

  9. describeValuesFromHierarchy

  10. Linux FairCom installation folder structure

  11. Parameter limits

  12. Supported languages and IDEs

  13. Data and Index Files

  14. SLMP API Reference

  15. ISAM for C Database Technology

  16. Compiling

  17. Privilege Hierarchy

  18. deleteThings

  19. FairCom DB SQL Operations and Utilities Guide

  20. pingSession

    Identify if there are errors in a FairCom server instance

  21. Advanced Windows Installation

  22. Linux installation

  23. alterThing

  24. Secure the FairCom install

  25. linkRoleWithPrivileges

  26. Multiple server instances

  27. Docker installation

  28. Transaction Processing

  29. listTags

  30. Optimize server memory usage

  31. Product Development/Evaluation License Agreements

  32. LOGIN INSTRUCTIONS

  33. DSQL field types and transaction isolation levels

  34. How to change web service ports and settings (services.json)

  35. Grant rights to an integration table

  36. listAccounts

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

  37. Installation Prerequisites

  38. Modbus Data types

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

  39. describeThings

  40. MTConnect API reference

    MTConnect connector specifications for FairCom Edge

  41. Detailed privilege hierarchy

  42. setValues

  43. unlinkLabelsFromRecords

  44. Advanced Docker installation

  45. Default protocols, ports, and services

  46. alterTag

  47. EtherNet/IP tutorials

    FairCom Edge EtherNet/IP connector service tutorials

  48. Windows FairCom installation folder structure

  49. FairCom DB API for VB.Net Overview

  50. getValues

  51. Developing ADO.NET Applications with FairCom DB SQL

  52. cloneRole

  53. linkRolesWithAccounts

  54. SLMP Connector Concepts

  55. Concepts for querying data

  56. Backward Compatibility

  57. VB.Net Tutorials

  58. OPC UA connector concepts

  59. FairCom DB API for Java Tutorials

  60. Modbus connector concepts

  61. Sample Programs

  62. Database Backup Guide

  63. Replication API Callbacks

  64. testInput

  65. tagId

  66. runSqlStatements

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

  67. HTTP status codes

  68. testOutput

  69. Code packages concepts

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

  70. Logging and Monitoring

  71. listActions

  72. jsonAction response

    List of properties in JSON Action response messages

  73. Advanced Configuration

  74. ISAM for C Data Management

  75. MQ APIs

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

  76. createTag

  77. Client Communication

  78. Basic Configuration

  79. describeValues

  80. LICENSE NOTIFICATION

  81. status (connectors)

  82. Backups and Data Integrity

  83. createIndex

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

  84. FairCom DB Utility Programs

  85. deleteTags

  86. createThing

  87. listThings

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

  89. getRecordIdsLinkedToLabel

  90. manageService

    Configure settings for a FairCom Edge service

  91. describeTags

  92. FairCom DB Standalone V12/V13 Updates

  93. Performance Monitoring

  94. Tag action concepts

  95. Installation troubleshooting

  96. dropRole

  97. alterRole

  98. .NET Support

  99. I/O Control

  100. alterSession

    Alter the settings of a session

  101. Command-Line Administration Utilities

  102. Siemens S7 connector tutorials

    Learn how to quickly implement Siemens S7 communication, including setup and commands for efficient data collection and exchange.

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

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

  105. Advanced Linux Installation

  106. deleteTopic

    JSON MQ "deleteTopic" action deletes an MQTT topic

  107. validateMqttPayload

  108. FairCom DB Configuration Options Overview

  109. listRoles

  110. describeRoles

  111. Multi-User Concepts

  112. EtherNet/IP API Reference

    Allen-Bradley connector programming specifications

  113. ISAM for C Operational Models

  114. alterInput

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

  115. getRecordsStartingAtKey

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

  116. ADO.NET QuickStart

  117. Connector concepts

  118. Thing API concepts

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

  119. Thing API FAQs

  120. sourcePayloadBinaryFormat

  121. Siemens S7 connector concepts

  122. Key-Value concepts

  123. SQL Data Load Utility: dbload

  124. getRecordsByPartialKeyRange

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

  125. Java and .NET glossary

  126. FairCom DB Access Configuration

  127. NAV c-treeDB API Callbacks

  128. jsonAction request

    List of properties in JSON Action request messages

  129. Modbus API reference

    Modbus connector programming specifications for FairCom Edge

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

  131. getRecordsFromCursor

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

  132. Diagnostics

  133. configureTopic

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

  134. Supported field bus connectors

  135. Startup and Shutdown

  136. deleteValues

  137. Unicode

  138. Hot Alter Table

  139. Replication

  140. File Mirroring

  141. Accounts API FAQs

    Frequently Asked Questions about the Accounts API

  142. FairCom DB Expression Parser and Grammar

  143. deleteRecords

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

  144. describeCodePackageHistory

    Return historical information about the specified code packages

  145. FairCom Typographical Conventions

  146. DB overview for admins

  147. FairCom JSON Conventions

  148. Read from OPC and write to Modbus using simulators

    Learn to connect OPC data sources to Modbus systems using simulators for seamless data integration and communication.

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

  150. Data Unload Utility: dbdump

  151. rebuildTables

    JSON DB "rebuildTables" action rebuilds specified tables

  152. significantMagnitude

  153. listSessions

    Return a list of active sessions

  154. onError

  155. mtconnectCategoryPropertyPath

  156. Modbus Quickstart Tutorial

    Learn how to quickly implement Modbus communication, including setup and commands for efficient data collection and exchange.

  157. Integration tables concepts

    Concepts for the Integration Tables API

  158. mtconnectDataNamePropertyPath

  159. Client-Side Operation

  160. Utilities - Low Level

  161. Utilities - Client

  162. alterAccount

    Alter an existing account

  163. createCodePackage

    Store JavaScript code in the server

  164. optimizeLabelLinks

  165. describeBrokerConnections

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

  166. listLabels

    Retrieve a filtered list of label names

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

  168. getMessagesFromMqTopic

    Retrieve messages published on a specific topic

  169. Sessions and services concepts

    Concepts for creating and managing sessions and services

  170. Utilities - Standalone

  171. Installing on Your Operating System

  172. thingName

  173. primaryKeys

  174. normalUpperLimit

  175. Using JavaScript to perform JSON actions

  176. listCodePackageHistory

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

  177. listIndexes

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

  178. Record Schemas and DODA Resources

  179. Predefined Functions

  180. createAccount

    Create an account to log into a server

  181. Configuring FairCom DB

  182. describeTopics

    JSON MQ "describeTopics" action returns info about MQTT topics

  183. createLabel

    Create a new label

  184. Conditional Expressions Overview

    Overview of the conditional expressions data filters and conditional indexes

  185. listDatabases

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

  186. Fields to JSON tutorial

  187. publishMessagesToMq

    Publish messages to a topic from the specified client

  188. Example property paths that group related properties

  189. deleteStreamingConnection

    Delete specified streaming connections

  190. resumeStreamingConnection

    Activate paused streaming connections

  191. File Management

  192. listMqSessions

    View a list of sessions that match the "partialClientName"

  193. listOutputs

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

  194. FairCom ISQL

  195. getLabelsLinkedToRecordIds

  196. Conditional Data Persistence Tutorial

  197. Partitioned Files

  198. Unicode for Standalone

  199. Transform data as it comes into the database

    Use the "integrationTableTransform" in the code package API

  200. getRecordsByIds

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

  201. insertRecords

    JSON DB "insertRecords" action inserts records into a table

  202. alterOutput

    JSON hub "alterOutput" action modifies a FairCom Edge output

  203. Custom Application Expressions

  204. Master Encryption Key Management

  205. assignRolesToAccounts

    Add and remove roles from accounts

  206. User's Control of Security Options

  207. numberFormat

  208. Create a user account

  209. cloneCodePackage

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

  210. pauseStreamingConnection

    Pause specified streaming connections

  211. variantFormat

  212. Conditional Expression Callback Function

  213. dropAccounts

    Mark an account as dropped from the server

  214. Server-Side Queues

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

    JSON DB "closeCursor" action closes a previously opened cursor

  218. updateRecords

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

  219. ISQL Statements Overview

  220. cloneAccount

    Clone an existing account and its roles

  221. testIntegrationTableTransformSteps

    Test new transform steps before running them

  222. mtconnectDeviceUuidPropertyPath

  223. sourcePayloadTimeFormat

  224. Log messages

    OPC Server status codes logged to CTSTATUS.FCS

  225. EtherNet/IP connector concepts

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

  226. padValue

  227. alterCodePackage

    Update the code in the server

  228. primaryKey

  229. deleteOutput

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

  230. describeCodePackages

    Return information about specified code packages

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

  232. JSONPath

    Use JSONPath to query for JSON values

  233. Conditional Expression Function Reference

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

  234. Basic Connection String Attributes and Defaults

  235. rerunIntegrationTableTransformSteps

    Rerun transform steps after updating them

  236. describeOutputs

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

  237. listStreamingConnectionProblems

    View a streaming connection's errors and warnings

  238. describeAccounts

    Describe roles that the account is authorized to see

  239. mtconnectDeviceNamePropertyPath

  240. listLabelGroups

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

  241. "recordPath"

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

  242. Conditional Data Collection

  243. JSON to different table tutorial

  244. listInputs

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

  245. getRecordsUsingSQL

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

  246. Label API FAQs

    Frequently Asked Questions about the Label API

  247. createDatabase

    JSON DB "createDatabase" action creates a database

  248. partialKey

  249. Accounts concepts

    Concepts to manage accounts with the accounts API

  250. retentionPeriod

  251. onChangeTrigger

  252. alterIntegrationTable

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

  253. createMqApiSession

    Create a new MQ session

  254. mtconnectDataItemId

  255. onChangeTriggerTags

  256. onChangeScopeTags

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

  258. listBrokerConnections

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

  259. Data Compression

  260. describeTables

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

  261. getRecordsInKeyRange

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

  262. copyIntegrationTableTransformSteps

    Replace a target table's transform steps

  263. listIntegrationTables

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

  264. mtconnectComponentNamePropertyPath

  265. listTopics

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

  266. describeDataChangeStreams

    View information about specified data change streams

  267. truncateRecords

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

  268. MTConnect tutorials

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

  269. listTables

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

  270. deleteBrokerConnection

    Delete connections to external brokers

  271. createservercert.py

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

  272. Schema Export Utility: dbschema

  273. changeLabels

    Modify sets of labels in bulk

  274. testTransformScope

  275. deleteMqSession

    Disconnect a client's MQ session

  276. alterMqSession

    Alter session settings without disrupting the client

  277. createIntegrationTable

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

  278. Linux Caching Considerations

  279. permanentSession

  280. FairCom DB Server Configuration Recommendations

  281. Code Packages FAQs

    Frequently Asked Questions about the Code Package API

  282. Administrative Utilities - Standalone

  283. listTransactions

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

  284. linkLabelsToRecords

  285. Tuning Index Page Size

  286. Label concepts

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

  287. Memory Files

  288. Glossary

  289. deleteDatabase

    JSON DB "deleteDatabase" action deletes a database

  290. Recovery

  291. FairCom ISAM API for C - Developers Guide Overview

  292. alterTable

    JSON DB "alterTable" action modifies an existing table

  293. Event streaming concepts

    Concepts for event streaming and messaging with the MQ API

  294. FairCom DB Server Basic Operations

  295. OPC UA API reference

    OPC UA connector programming specifications for FairCom Edge

  296. commitTransaction

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

  297. mtconnectSequencePropertyPath

  298. Create a permanent session

    Use the "permanentSession" property to create permanent sessions

  299. MTConnect connector concepts

  300. FairCom DB JSON APIs

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

  301. tagName

  302. deleteIntegrationTables

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

  303. createOutput

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

  304. getValuesFromHierarchy

  305. thingId

  306. getKeysFromHierarchy

  307. Cache and Memory

  308. JSON to fields tutorial

  309. Capacity Planning Considerations

  310. New user from ADMIN group

  311. FairCom DB Error Codes

  312. hasPermissions

  313. FairCom DB Direct SQL Function Reference Guide

  314. renameKeys

  315. FairCom DB SQL ADO.NET Data Provider

  316. Transaction Processing (FC API for C)

  317. createInput

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

  318. Account level security

  319. Server-level security (SLS)

  320. Database-level security

  321. Security API Overview

  322. listPrivileges

  323. Basic and Advanced Authorization Comparison

  324. Table-level security

  325. Basic Authorization

  326. Authorization FAQs

  327. "responseOptions"

  328. Performance Optimization

  329. describeIntegrationTables

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

  330. Using JSON in SQL

  331. listStreamingConnections

    Return a list of streaming connections that match all specified filters

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

  333. configureBrokerConnection

    Connect a FairCom Server to an external broker

  334. Data Caching Best Practices

  335. deleteIndexes

    JSON DB "deleteIndexes" action deletes indexes

  336. Locking

  337. Database Backup

  338. Using the Low-Level API

  339. revertCodePackage

    Revert the code package to the specified historical version

  340. timeFormat

  341. sourcePayloadDateFormat

  342. Monitoring FairCom DB

  343. createTable

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

  344. Transform data as it is read from the database

    Use "getRecordsTransform" in the code package API

  345. primaryKeyFields

  346. deleteTables

    JSON DB "deleteTables" action deletes tables

  347. rebuildIndexes

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

  348. subscribeToMq

    Add or remove a client's subscriptions

  349. Sessions and Services API FAQs

    Frequently Asked Questions for the Sessions & services API

  350. deleteInput

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

  351. Industrial Ethernet Connector Concepts

  352. getMessagesFromMqApiSession

    Retrieve undelivered messages from an MQ API client-subscribed topic

  353. Edge Concepts

    FairCom Edge's architecture and internals described for engineers

  354. FairCom DB Database Engine

  355. mtconnectDataTypePropertyPath

  356. ADO.NET Driver Overview

  357. alterLabel

    Modify an existing label

  358. Grant access privileges

    Tutorial for granting access privileges to accounts

  359. FairCom Callbacks Overview

  360. transformStepMethod

  361. listServices

    Return information about the specified services

  362. License Authorization File

  363. FairCom DB API for Java Overview

  364. mtconnectDataItemIdPropertyPath

  365. Security

  366. sessionHealth

  367. Subsystem

  368. Standalone SQL driver setup

  369. Standalone Multi-User

  370. ISAM API Callbacks

  371. mtconnectTimestampPropertyPath

  372. createAndStartDataChangeStreams

    Initialize one or more data change streams

  373. Server Best Practices

  374. FairCom DB FAQs

  375. "propertyPath"

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

  376. Data File Snapshots

  377. describeInputs

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

  378. createTransactionSavePoint

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

  379. onChangeScope

  380. Data Change Stream concepts

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

  381. Java Stored Procedures, Triggers, and UDFs

  382. Function Name Cross Reference

  383. path

  384. rollbackTransaction

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

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

  386. deleteSession

    Disconnect a client from Remote Procedure Call service

  387. SQL Analytic Functions

  388. createStreamingConnection

    Create a streaming connection

  389. deleteDataChangeStreams

    Delete specified data change streams

  390. alterStreamingConnection

    Update a streaming connection

  391. Administrative Utilities - Client

  392. createSession

    Log into the FairCom server

  393. mtconnectDeviceUuid

  394. Siemens S7 API reference

    Siemens S7 connector programming specifications

  395. describeSessions

    Return a list of session objects

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

  397. revertTransactionToSavepoint

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

  398. describeMqSessions

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