Configuring a SQL database

Blue Spider can record all incoming data to a SQL database. It is highly recommended that you configure a database and use this feature. With database logging correctly configured it can be possible to recover all raw data and reconstruct log files from the raw data. If for example you forgot to record a required data field in a particular CSV log file or if you misconfigured a particular input then with database logging set up and having recorded data for your entire job you can retrospectively reconstruct the missing data. Without database logging you may well have to go back at your own cost to do the job again!!

To configure database logging you first need to download and install a suitable database engine back end. We recommend using MariaDB and use of the following two installers:

MariaDB Server Version 10.2.14 GA (use the 64 bit installer unless installing on a 32 bit machine)[
​https://downloads.mariadb.com/MariaDB/mariadb-10.2.14/winx64-packages/mariadb-10.2.14-winx64.msi

MariaDB Connector/C 3.0 Series (always use the 32 bit installer)
​https://downloads.mariadb.com/Connectors/c/connector-c-3.0.3/mariadb-connector-c-3.0.3-win32.msi

Use the links above to directly download the installers (unless the pages have moved)

During installation of MariaDB Server you will be asked to define a root password. Make a note of this password as you will need it later. If you are installing the MariaDB server on the same machine as BSPEngine then you can log data to the database using the root password. If the SQL server is located on a different machine to the Engine then you should NOT enable remote access using the root password but instead should create a separate account by following instructions (provided by Maria) on how to do so.

You can find out more about MariaDB and these downloads on the following pages:
​https://mariadb.com
​https://mariadb.com/downloads/mariadb-tx
​https://downloads.mariadb.org/connector-c/

Once you have run these installers all you have to do is configure Blue Spider to use the database and you will be ready to start recording data.