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[[BR]]

You can find out more about these downloads on the following pages ​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.