ThingWorx Flow Prerequisites for Microsoft SQL Server
The following sections provide information about the prerequisites that you need to set before you install ThingWorx Flow:
Prerequisites for Windows Server 2016 with Microsoft SQL Server
You must have the following:
• Windows Server 2016 with Administrator access
• A local or remote database connection for ThingWorx Flow. The following table provides the prerequisites that you need to set:
|
Database Connection
|
Prerequisites
|
|---|---|
|
Local database connection
|
• The host on which ThingWorx Flow is to be installed must have access to Microsoft SQL Server.
• A valid Microsoft SQL client (sqlcmd) is installed and is available in the PATH environment variable.
• A Microsoft SQL user with Administrator access.
|
|
Remote database connection
|
Install sqlcmd and make it available in the PATH environment variable.
|
• Microsoft SQL Server database that can be used for ThingWorx Flow. You can use the existing ThingWorx Foundation database or create a separate database for ThingWorx Flow. Set the following configuration settings on the database:
◦ Set Collation to your collate. For example: Latin1_General_100_CS_AS_SC. See Microsoft documentation to View Collation Information.
◦ Set the following properties to ON:
▪ READ_COMMITTED_SNAPSHOT
▪ ALLOW_SNAPSHOT_ISOLATION
 |
Ensure that you have not used this database for a previous ThingWorx Flow installation.
|
• Ensure that your database user has the following settings and privileges:
◦ Create a login for the Microsoft SQL Server with an SQL Server Authentication. The password for the login is the ThingWorx Flow Database Login Password.
◦ Create a database user for that login.
◦ Set the database user as the owner of the database.
• From your Microsoft SQL Server database, note the following values:
◦ SQL Server IP Address or Host Name
◦ SQL Server Port
◦ SQL Server Instance
◦ ThingWorx Flow Database Name
◦ ThingWorx Flow Database Login Username
◦ ThingWorx Flow Database Login Password
|
|
ThingWorx Flow does not support Force Encryption mode for Microsoft SQL Server. Ensure the value for Force Encryption mode is set to No before installation.
|
Prerequisites for Red Hat Enterprise Linux 7.5, 7.6, 8.0, 8.1, or 8.2 with Microsoft SQL Server
|
|
Ensure that you are installing ThingWorx Flow on the supported version of Red Hat Enterprise Linux. For more information, see Supported operating systems.
|
• Red Hat Enterprise Linux (RHEL) 7.5 with Administrator access
• In the /etc/selinux/config file, set SELINUX=enforcing, and restart the machine.
• Run the following commands to enable Software Collections:
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 RHSCL (RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Extra(RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Optional (RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 RH Common (RPMs)'
◦ yum-config-manager --enable 'Red Hat Enterprise Linux Server 7 Supplementary (RPMs)'
• Run the following commands to enable EPEL repository:
wget https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
yum localinstall epel-release-latest-7.noarch.rpm
• A local or remote database connection for ThingWorx Flow. The following table provides the prerequisites that you need to set:
|
Database Connection
|
Prerequisites
|
|---|---|
|
Local database connection
|
• The host on which ThingWorx Flow is to be installed must have access to Microsoft SQL Server.
• A valid Microsoft SQL client (sqlcmd) is installed and is available in the PATH environment variable.
• A Microsoft SQL user with Administrator access.
|
|
Remote database connection
|
1. Install sqlcmd and make it available in the PATH environment variable. For instructions on installing sqlcmd, see Install sqlcmd on Linux.
2. After installation, run the following command:
ln -s /opt/mssql-tools/bin/sqlcmd /usr/bin/sqlcmd
|
• Microsoft SQL Server database that can be used for ThingWorx Flow. You can use the existing ThingWorx Foundation database or create a separate database for ThingWorx Flow. Set the following configuration settings on the database:
◦ Set Collation to your collate. For example: Latin1_General_100_CS_AS_SC. See Microsoft documentation to View Collation Information.
◦ Set the following properties to ON:
▪ READ_COMMITTED_SNAPSHOT
▪ ALLOW_SNAPSHOT_ISOLATION
|
|
Ensure that you have not used this database for a previous ThingWorx Flow installation.
|
• Ensure that your database user has the following settings and privileges:
◦ Create a login for the Microsoft SQL Server with an SQL Server Authentication. The password for the login is the ThingWorx Flow Database Login Password.
◦ Create a database user for that login.
◦ Set the database user as the owner of the database.
• From your Microsoft SQL Server database, note the following values:
◦ SQL Server IP Address or Host Name
◦ SQL Server Port
◦ SQL Server Instance
◦ ThingWorx Flow Database Name
◦ ThingWorx Flow Database Login Username
◦ ThingWorx Flow Database Login Password
|
|
ThingWorx Flow does not support Force Encryption mode for Microsoft SQL Server. Ensure the value for Force Encryption mode is set to No before installation.
|