Skip to main content

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
FC-Icons_SSL-TLS_Secure_1.svg
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

TLSJDBCsecure communications

FairCom_DB_Horizontal_logo.svgpython_icon.svg

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

PythonJSON DBJSONtutorial
FC-Icons_SSL-TLS_Secure_1.svg
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

TLSSecuritySecureCAcertificate
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

TransactionsfilesSecure
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

bit data typesmodbus connectormodbus data types
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

CA certificatesimport certificateshow to import certificates Macimport CA certificates Mactutorials for MacOS
DB_Data_Replication.svg
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

extensionreplicationtutorial
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

Label APImanage labelslookup liststag setslabel actions
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.

data persistence strategydataPersistenceStrategyimmediately collect data on startimmediatelyCollectDataOnStart
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

MTConnectconnectorMitsubishiPLCs
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

TLSconfigure communicationssetuptls.pytls tutorial
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

Count and paginatepaginate recordscount recordstutorialhow to count recordshow to paginate 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

Allen-Bradleytutorialsethernet/ip protocolAllen-Bradley PLCs
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

Our new Siemens S7 tutorial shows how to quickly and easily capture, store, transform, and query data from Siemens S7 PLCs

Siemens S7tutorialsSiemens S7 PLCs