As part of the CPS ERP integration for carpet, with the CpsLinkToConnect-module, BMSvision needs to execute specific queries on the customer’s database while the customer continues to run their own database operations in parallel.


To ensure stable and reliable coexistence of all database activities, the customer environment must meet a set of technical prerequisites covering platform requirements, database configuration, firewall rules, and server security.


Please review the requirements detailed below carefully. Verifying and, if necessary, adjusting these prerequisites in advance will ensure compatibility, prevent integration issues, and allow all queries, both on the customer side and on the BMSvision side to function correctly.



Installation of the CpsLinkToConnect-module requires compliance with these prerequisites:


Firewall configuration

  • Allow inbound TCP traffic on the database port (default: 1433) from the BMSedge to the SQL-server.


SQL-server requirements

  • Version: Microsoft SQL Server 2019 CTP 2.0 (build 895) or higher.
  • Database compatibility level: 150 or higher.
  • Ensure that TCP/IP connections are allowed to the SQL-server.
  • Provide a database user account with SELECT and INSERT permissions on:
    • The CPS database
    • The logging database (both may reside in the same database)


More info:
View or change the compatibility level of a database
More details about Compatibility levels 


Server security requirements

  • Transport encryption:
    • TLS 1.2 must be enabled and enforced.
  • Certificates:
    • Must comply with SSL security level 2 at a minimum.
    • SSL security level 3 is recommended.


More info:
SSL Security Level