This section will cover the integration and technical aspects of the Configuration Option within the System Manager. This option configures the settings required for DATASCOPE WMS to function.
This option allows the configuration options for the DATASCOPE WMS to be added or edited. It is typically used on new installations or where changes are made to Databases/Servers or login credentials; otherwise, this section remains unchanged.
The first screen in this option looks as follows, and the integration here is mentioned below in some detail:
When the operator clicks the Next button after entering the details in the above fields, the system will validate several things and then save this information to the registry.
Note: To view the Registry, search for Registry Editor from your Windows Explorer. |
Settings required:
SQL Server
o SQL Name/IP –the name or IP address where the primary SQL Server is installed. (The port number can be included in this field. If left out, the standard SWL port 1433 will be used.)
o SQL Username – this refers to the SQL Administrator username. (This must be a dedicated user and not a general account)
o SQL Password – this refers to the SQL Administrator password. (This will be encrypted when stored within the Registry)
SYSPRO Server
o SYSPRO Name/IP – This might be the same as the SQL Server Name/IP address, but if it is a different server, add the correct IP address. (This is used for the communication to the SYSPRO WebServices, WCF or WCF Load Balancer)
o Integration – Select an Integration method – WCF vs. WebServices. (This option allows the system to integrate with one of the supported platforms. Legacy WebServices or WCF. The WCF option should be used for both WCF or WCF Load Balancer)
o Site Name – You must ensure the Port is set to the correct Port Number. This is located under Services / SYSPRO 8 e.net Communication Load Balancer. If you do not update this port number, you will get an error later.
o SYSPRO Version – Select the current SYSPRO version.
o License Type – This will depend on the type of licensing. It indicates if the site is running a SYSPRO Runtime or Standard License.
WMS Server
o WMS Name / IP Port - the server's name or IP address where DATASCOPE WMS is installed. The port must also be included, which is the port number on which the DATASCOPE WMS WebAPI will operate.
Validation Steps
A standard PING command will be fired to the SQL Name/IP server to validate it exists.
A standard SQL Connection will then be made to the SQL Name/IP server to validate the SQL Username and SQL Password are correct.
A standard PING command will be fired to the SYSPRO Name/IP server to validate it exists.
A standard PING command will be fired to the WMS Name/IP server to validate it exists.
Once the validation is successful, a registry entry will be created as follows:
HKEY_LOCAL_MACHING\SOFTWARE\WOW632Node\DATASCOPEWMS\
The following string entries, shown in BLUE, will be made. These are all the values entered on the above-mentioned form.
The following screen will appear: Core Service Account. These are the details for the account used to run the WebAPI and Core Services DATASCOPE WMS Services on the new Server.
The next screen in this option looks as follows, and the integration here is mentioned below in some detail. This refers to the linked databases.
When this screen is loaded, a query is made to the following database table to obtain a list of
the SYSPRO Companies that are set up.
Database Name | Sysprodb |
Table Name | SysproAdmin |
If the standard Sysprodb does not exist, the operator will be asked to specify it. When this happens, a query is made as follows.
Database Name | master |
Table Name | sysdatabases |
When selecting Next, the next SYSPRO Company Databases can be configured.
The option exists to create a third SYSPRO Company as well.
Once the list of SYSPRO Companies has been obtained, the operator can loop through each company and configure the SYSPRO and WMS Databases, respectively. Each drop-down will be loaded by querying the below:
Database Name | master |
Table Name | sysdatabases |
Once the operator moves to the next company, the below entries will be added to the registry as follows:
HKEY_LOCAL_MACHING\SOFTWARE\WOW632Node\DATASCOPEWMS\
The following entries in BLUE will be added/updated.
NOTE: Each company will have the entries prefixed with the SYSPRO Company Letter in this case TMS_ |
