PolyWorks|DataLoop™ Three-Tier Architecture
PolyWorks|DataLoop requires that certain server applications be installed and configured. The following schema shows how PolyWorks® applications communicate with one another as well as with Microsoft SQL Server.
Server recommendations for PolyWorks|DataLoop
To use PolyWorks|DataLoop, a network infrastructure must be set up with potentially multiple servers. The number of servers and their configurations depend on the number of users that are expected to interact with the servers.
Recommendations for up to 50 users with a single server
Machine configuration:
- Operating system: Microsoft Windows Server 2016, 2019, or 2022 only
- CPU: 4 physical cores
- RAM: 32 GB
- Disk space:
- 500 GB on a solid-state drive (SSD) for the operating system, all components to install, as well as for the Microsoft SQL Server instance and database files. a
- At least 1 TB on a hard disk drive (HDD) for the Microsoft SQL Server FILESTREAM data. a
- Components to install:
- Microsoft SQL Server 2017 or later
- Internet Information Services (IIS)
- SSL certificate - required for the HTTPS communication to the server b
- Google Chrome 64-bit web browser
- The required size varies depending on the volume of data stored in the file system. A monitor software should be configured to send alerts when disk space is low.
- SSL certificates issued from a well-known certification authority are recommended.
Recommendations for 50 to 250 users with two separate servers
Server 1 configuration:
- Operating system: Microsoft Windows Server 2012 R2 or later
- CPU: 8 physical cores
- RAM: 32 GB
- Disk space:
- 500 GB on a solid-state drive (SSD) for the operating system, all components to install on this server as well as for the Microsoft SQL Server instance and database files.a
- At least 20 TB on a hard disk drive array (HDD RAID) for the Microsoft SQL Server FILESTREAM data.a
- Components to install:
- Microsoft SQL Server 2017 or later.bc
- The required size varies depending on the volume of data stored in the file system. A monitor software should be configured to send alerts when disk space is low.
- We recommend that you do not install Microsoft SQL Server on a domain controller.
- Microsoft SQL Server Enterprise Edition is recommended if 24/7 operation is required and no downtime is expected.
Server 2 configuration:
- Operating system: Microsoft Windows Server 2016, 2019, or 2022 only
- CPU: 4 physical cores
- RAM: 16 GB
- Disk space: 250 GB on a solid-state drive (SSD)
- Components to install:
- Internet Information Services (IIS)
- SSL certificate - required for the HTTPS communication to the server a
- Chrome 64-bit web browser
- SSL certificates issued from a well-known certification authority are recommended.
Note that the two servers must be on the same Windows domain for authentication using the Active Directory to work properly.