2025
View the various changes made to the FairCom documentation in the year 2025
View the updates and features developed in the year 2025
change log for 2025
change log
update log
new feature log
2025
Description
You can now establish secure communications with FairCom servers by using the FairCom JDBC driver. JDBC allows you to write SQL against the FairCom server. TLS authentication is used to establish secure communications over the internet. The FairCom JDBC driver API can now be used to establish secure connections for private and protected communications.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 5.0.0
FairCom MQ 5.0.0
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Users , Developers , and Administrators
Source references
D1548
JDBC now supports TLS secure communications
Description
This enhanced Python tutorial makes it quick and easy for developers to use the FairCom JSON action API to interact with FairCom servers. It gets you started creating databases, tables, and indexes as well as writing and reading records.
Documents updated
Initial products and versions
Add, remove, update the product versions that apply to this update.
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
Audience
Developers
Source references
D1504
Updated JSON DB Python tutorial
Description
Requiring a client certificate increases communication security. You can now optionally require a client certificate when establishing secure client to server communications. This capability is enabled in the server configuration options.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers , Administrators
Source references
D1363
Increase secure communications by requiring a client certificate
Description
By default, the server automatically starts a transaction when creating, deleting, and renaming files if a transaction has not yet been started. This change prevents automatic recovery errors on transaction-controlled files created without the transaction-dependent feature. If desired, the feature can be disabled at startup by setting an option in the server configuration file.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers , Administrators
Source references
D1554
Transactions when creating, deleting, and renaming files
Description
FairCom can now make the data you collect more meaningful by assigning meaningful text to bit values. For example, you could assign string values to voltage bits to tell you if there is low, normal, or high voltage.
Documents updated
Initial products and versions
FairCom Edge 4.2.2
Audience
Users
Source references
ITG49
New bit data types for the Modbus connector
Description
You can now use FairCom's certificate manager to easily import CA certificates into your MacOS KeyChain Access application with our new tutorial, enabling your MacOS device to trust connections to FairCom servers.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Administrators
Source references
DB9
New tutorial to import CA certificates into MacOS
Description
Learn to create a plugin to extend FairCom replication with custom functionality. This tutorial includes code that demonstrates how to log replication actions.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers , Administrators
Source references
DB7
Tutorial to create a replication extension program
Description
FairCom's new label API actions manage labels, lookup lists, and tag sets. They speed up application development by codifying the best practices for using lookup lists and tag sets.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers and Administrators
Source references
ITG84
Use the new Label API to manage labels, lookup lists, and tag sets
Description
You can now use the "dataPersistenceStrategy"
and "immediatelyCollectDataOnStart"
properties to set the input service to persist only changes to data. This addition reduces storage costs and makes events more meaningful.
Documents updated
Initial products and versions
FairCom Edge 4.2.2
Audience
Users and Developers
Source references
ITG45
New "dataPersistenceStrategy"
and "immediatelyCollectDataOnStart"
properties.
Description
FairCom now supports the MTConnect protocol so that you can seamlessly access, store, transform, and write data collected from Mitsubishi PLCs and other devices.
Documents updated
Initial products and versions
FairCom Edge 4.2.2
Audience
Users and Developers
Source references
ITG71 ITG72 ITG73
New MTConnect connector to access, store, transform, and write data collected from Mitsubishi PLCs
Description
You can now easily set up secure TLS communications using FairCom's setuptls.py script. We have also provided a new tutorial to help you get started quickly.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Administrators
Source references
DOC1368
New tool to configure TLS communications in FairCom servers
Description
Our new tutorial shows you how to quickly and easily get a count of all records in a SQL query and use a cursor to paginate over the results efficiently.
Documents updated
Initial products and versions
FairCom DB 13.0.2
FairCom Edge 4.2.2
FairCom MQ 4.2.2
FairCom RTG COBOL 5.0.0
FairCom RTG Btrieve 5.0.0
Audience
Developers
Source references
ITG100
New tutorial for counting and paginating records
Description
Our new Allen-Bradley tutorial shows how to quickly and easily capture, store, transform, and query data from Allen-Bradley PLCs using the EtherNet/IP protocol.
Documents updated
Initial products and versions
FairCom Edge 4.2.2
Audience
Users
Source references
ITG
Our new Allen-Bradley tutorial shows how to quickly and easily capture, store, transform, and query data from Allen-Bradley PLCs using the EtherNet/IP protocol
Description
Our new Siemens S7 tutorial shows how to quickly and easily capture, store, transform, and query data from Siemens S7 PLCs.
Documents updated
Initial products and versions
FairCom Edge 4.2.2
Audience
Users
Source references
ITG115