Housekeeping Generic tool to perform regular housekeeping tasks on file systems and database servers. File system housekeeping such as deleting specific files, files in specific folders and folders whose date exceeds the defined retention period. SQL Server database housekeeping including index rebuilds, statistic rebuilds and backups. SQL Server actions, such as scripts to run against the database, for example to remove records which have expired based on user specific business rules. MySQL backup to disk, also supports restore to disk, which is ideal to restore test data periodically i.e. at the start of each round of testing etc. This console application can run unattended via the Windows Task Scheduler, to ensure your development, test and prodcution environments are always optimsed.
Log Monitor Configure this program to look for the existence of files in a specific folder meeting a defined pattern or for specific files in a specific folder and if found a templated email is sent to a series of recipients. For example if you system produces an error log only when an exception occurs, this program can detect it and alert support personnel to investigate further. Not restricted to log and error files, basically it monitors files and folders, so it could be that a file is uploaded onto your servers from a customer or supplier, let this program alert you that it is there. This console application can run unattended via the Windows Task Scheduler, alerting when intervention is required.
Site Monitor A simple utility program which attempts to connect to web sites defined in a configuration file, if the site is not responsive it sends a templated email alert to defined individuals/groups such as a support/service desk. Other monitor services perform ping tests, however this only tells you if the server and its network card are responding, here the program effectively opens the site as if it were a client/user and therefore you can ensure that your sites are functioning and delivering the best service to your users. In addition, the utility can monitor Web Services making GET or POST requests as required. The expect response is configured, therefore where no response or an invalid response in the case of errors for example, the utility can alert support teams to investigate if an error has occured etc. This console application can run unattended via the Windows Task Scheduler, alerting when intervention is required.
Outbound/Queued Email Server Clients who have licensed the NABU Application Framework are able to submit emails into a queue for later processing. This improves the performance of the user experience by not having the users wait whilst the server connects to email providers. These cached emails are sitting in an outbound email queue. This application looks for these queued emails and sends them out to clients as a background activity. This console application can run unattended via the Windows Task Scheduler ensuring that emails are sent, alerting support staff when there is an error.
Heartbeat Monitor All of the NABU ETL Services and many of the NABU Tools utilise a heartbeat feature. This utility program monitors this heatbeat to ensure that the programs are still operating as required. When the program detects that the programs heart has stopped, it alerts support personnel via a templated email, allowing proactive investigation and resolution. This console application can run unattended via the Windows Task Scheduler, alerting support staff when there is an error.
Database Administrator The standard NABU Database includes many reference tables accross the range of business domains. Each implementation of the NABU Application Framework is different, therefore this tool is provided to allow the management of these reference tables. The utility runs as a Windows application, allowing the administrator to connect to the database and manage the reference tables through a intuitive graphical user interface.
CRM/Dynamics Synchroniser This program is designed to interface with Microsoft Dynamics CRM solution, whether hosted internally, externally or through Office-365. The NABU Database can store lots of information about people and places and there relationships etc. Some business use the NABU database as an abstraciton of the CRM system, allowing end users to manage thier own contact information etc. This simple utility program is then able to connect with Dynamics and compare the data stored in the abstraction layer and automatically synchronise the CRM as reqruied. This console application can run unattended via the Windows Task Scheduler, alerting support staff when there is an error.
Crypto Security is so important at the moment, with lots of stories of hackers attacking public facing services and releasing information about clients/users. Data protection and specifically encryption is therefore particularly important. Often back office systems are full of connection strings, and user names, and passwords to email services and so on. Just because the configuration files are on servers behind firewalls doesn't make them safe. The Crypto tool is a command line utility that can convert your sensitive information to an encrypted version. This encrypted version can then be decrypted within the software using the NABU Encryption Library which forms part of the NABU Application Framework. To increase the encryption and reduce the likelihood of decryption additional 'salt' can be added to the encryption key thereby making it even more secure. All of the programs within the NABU Tools and NABU ETL Service support the encryption of passwords within configuration files to reduce risks from hackers etc.
