Deployment
The deployment of SchemaSuite is done through two very user-friendly installers. However, it is necessary to deploy the following architecture on your network in order to make our solution work.
Newis gladly provides its technical team to help you set up the required architecture on your infrastructure. And if you do not wish to deploy this on your infrastructure, we can directly provide you with a server and use the SchemaSuite application remotely from any Windows / Apple / Android terminal.
Architecture
SchemaSuite saves all its data in two SQL databases. The NewisService Windows service must be installed once on your architecture. It manages floating licenses as well as the multi-user synchronization of the application. The SchemaSuite client must be deployed on each user workstation. The SchemaSuite Client contains the 3 different modules SchemaFiber, SchemaElec, and SchemaGeo. It is also possible to install SchemaSuite on a RemoteApplication server and allow clients to connect to the application using Microsoft’s RDS technology.
The diagram below explains the different communication channels used by the SchemaSuite application.
Database Server
The different installation and configuration prerequisites on the database server are as follows:
Hardware
As most servers are virtualized nowadays, we do not provide precise recommendations for the server hardware. The virtualization architecture allows each solution to be adapted according to the product usage. In order to provide a good level of performance to SchemaFiber, the minimum recommended specifications for the database server are: 2 Intel® Xeon® cores with a minimum clock speed of 3.0 GHz 16GB of RAM
Microsoft SQL server
The installation of SchemaSuite requires the creation of two databases on a Microsoft SQL Server. Microsoft SQL Server Express can be used for small networks (less than 2000 optical nodes).
The SQL server versions tested and validated by Newis are:
Microsoft SQL server 2012 Microsoft Express SQL server 2012
Microsoft SQL server 2014 Microsoft Express SQL server 2014
Microsoft SQL server 2016 Microsoft Express SQL server 2016
Microsoft SQL server 2017 Microsoft Express SQL server 2017
Microsoft SQL server 2019 Microsoft Express SQL server 2019
If you want to use another version, please let us know to allow us to validate the proper functioning of the application. No version older than 2012 is supported. The creation of two empty databases is required in SQL. The standard configuration uses the following two names:
SchemaSuiteData
Used by the SchemaSuite application.
Contains the entire topology of your different networks.
SchemaSuiteLocking
Used by the Newis Service application.
Allows multi-user synchronization of the application.
It is not necessary to start from a specific backup of the database. The application takes care of injecting the complete model of tables during the first connection.
In order to inject the tables of the database during the first connection, an SQL user with the following rights is required:
db_owner
To work, a user with the following rights is required at a minimum:
db_datareader
db_datawriter
(also necessary only for consultation)
Newis Service
The Newis Service allows multi-user synchronization of the SchemaFiber application. We will provide you with a setup for deploying the Newis Service. Each instance of the SchemaFiber client connects to the Newis Service via TCP port: 5000. The Newis Service only connects to the SchemaSuiteLocking database on the SQL server and injects the database model. The SQL user used must have read/write rights (db_datareader, db_datawriter) on the SchemaSuiteLocking database. (db_owner for the first injection)
The basic SQL configuration of the Newis Service uses the current user of the computer to connect to the server.
For the sake of improving the performance of our software, we recommend installing Newis Service directly on the database server, although it is possible to install it on a third-party computer. Newis takes care of the configuration of Newis Server to ensure its proper functioning.