Configuring the MsSql endpoint to export read and hit events - You can configure the ALPR Manager role to automatically export license plate read event metadata to a Microsoft SQL database. - Security Center 5.13

You can configure the ALPR Manager role to automatically export license plate read event metadata to a Microsoft SQL database.

1. From the Config Tool homepage, click System > Roles, and then click the ALPR Manager you want to configure.
2. Click the Properties tab and enable the Data Exporter option.
3. Select the required Queueing protocol from the drop down menu.

   Standard

   This is the default mode.

   High volume

   Select this mode if you need to export a high volume of events.

   NOTE: In the Communication settings pop-up window, enter the details configured in the RabbitMQ installation.

4. Click Endpoints () and select MsSql from the list.
5. In the Parameters section, enter the Endpoint name.
6. In the Configuration settings section, enter the following:

   Database server

   Enter the name of the database server, for example, (local)\sqlexpress01.

   Database name

   Enter the name of the database.

   Database table

   Enter the name of the database table.

7. By default, connections are encrypted. For additional security, turn on Validate certificate and select whether the certificate uses Windows or SQL Server authentication.
8. In the Export settings section, select the metadata that you want to export with the event.
   NOTE:

   • To add additional metadata that is not included in the list, click Add and select the metadata to include in the list.
   • You cannot export images to a database; you can only export the metadata associated with license plate reads.
   • If you select the Context attribute, it exports the associated regional ALPR context, for example, Florida. In this case, "Context" does not refer to the context image.
9. Click Apply.