Custom business attribute fields allows an administrator to assign user defined values to client-servers. This can be configured in the application user interface, and includes the ability to add values in bulk. An option to mark a field as a required value is also available (Figure 20).
Figure 20 – Business Attributes configuration screen
On the ‘Central Client Overview’ screen (Figure 21), custom columns are included as search fields and displayed dynamically in the display list. It is editable after installation. This feature allows excellent management and organization of any business specific attributes when using Conductor4SQL.
Figure 21 – Central Client Overview with attributes
A Dynamic Database Name support feature, for installations where each client-server has a unique database name, for example: ‘STORE001, STORE002….’ is provided in this release. This is based on a saved expression for the corresponding part of the name, for this example: ‘STORE%’. All the existing functionalities can be used even with differing database names at client-servers.
In version 2.98 stored commands and queries can be scheduled to execute daily, weekly and monthly by utilizing the Conductor4SQL windows service (Figure 22).
Figure 22 – Conductor4SQL Scheduler
Data compression is implemented on messages sent to and from client-servers and reduces bandwidth usage by between 20 to 100 times.
The Meta data comparison functionality, released with version 2.95, has been further refined to do separate reports on stored procedures, tables, views, functions and constraints across all installed client-servers.