Advanced Serial Data Logger

Trust In Confidence!

For Windows 2000 - Windows 10 (2016) (incl. Server, x86 and x64). Latest version: 4.2.1 build 131. .


RFID software: writing data from an RFID reader to a database (for example, Firebird)

Download and install our software

Download Advanced Serial Data Logger

Advanced Serial Data Logger you can download here. Plugins can be downloaded separately here.

Configuring data writing to a Firebird database

Prerequisites

  1. The database engine has been installed (http://www.firebirdsql.org).
  2. ODBC drivers for the database have been installed (http://www.firebirdsql.org/en/odbc-driver/ , regardless if you have a 32-bit or 64-bit operating system, install the 32-bit version of the ODBC driver).
  3. A database file for storing data has been created.
  4. A user has been created in that database, who will be given the rights to write data to a database table.

Creating a table for storing the data

Below you can see the recommended SQL script for creating a table, a trigger, and a sequence. This script should be run by the "SYSDBA" user.

CREATE GENERATOR TAG_DATA_ID_SEQ; 
SET GENERATOR TAG_DATA_ID_SEQ TO 0; 
CREATE TABLE TAG_DATA 
( 
 	    ID int  primary key, 
 	    TAG_ID varchar(32) not null, 
 	     DATE_TIME_STAMP timestamp default current_timestamp, 
 	     TAG_ANTENNA_ID int, 
 	     TAG_FIRST_SEEN timestamp, 
 	     TAG_LAST_SEEN timestamp, 
 	     TAG_SEEN_COUNT int, 
 	     TAG_OUT_OF_FOV int 
); 
set term !! ; 
CREATE TRIGGER TAG_DATA_BI FOR TAG_DATA 
ACTIVE BEFORE INSERT POSITION 0 
AS 
BEGIN 
 	if (NEW.ID is NULL) then NEW.ID =  GEN_ID(TAG_DATA_ID_SEQ, 1); 
END!! 
set term ; !! 

Selecting and configuring the data export module

To write data to the Firebird database, use the "ODBC database" module. You can select it on the "Data export" tab (Figure 6).

Selecting the data export module
Figure 6: Selecting the data export module

To configure the module, select it in the list, and then click the "Configure" button below the module list.

When a window appears (Figure 7), enable writing to the database.

Enabling writing to the database
Figure 7: Enabling writing to the database

On the "Connection" tab (Figure 8), click the "Configure" button and add the System ODBC data source (Fig. 9 and 10).

Configuring the connection
Figure 8: Configuring the connection

Adding a data source
Figure 9: Adding a data source

An example of configuring a connection with the local copy of the Firebird database
Figure 10: An example of configuring a connection with the local copy of the Firebird database

After closing the ODBC connections administrator window, click the "Update" button and select the newly created connection in the drop-down list.

Switch to the "Linking" tab (Figure 11) or click the "Import" button. If the connection to the database was configured correctly, the application will prompt you to import the table structure from the database (Figure 12).

Configuring linking
Figure 11: Configuring linking

Importing the table structure
Figure 12: Importing the table structure

After importing the table structure, link table columns and parser variables (Figure 13).

Linking columns and variables
Figure 13: Importing the table structure

The "ID" column in the test table is automatically filled by the trigger, so you can safely delete that column from the list of linked columns and variables.

Save all settings of the module by clicking the "OK" button.

Now, when new data are received from the reader, the application will automatically write them to the database. If the write is successful, the application’s event log will display a message about that (Figure 14).

successful data write message
Figure 14: A successful data write message

Tip: To display values and variables in the application’s main window (see Figure 14), you may want to set the data view as shown in Figure 15.

Linking columns and variables
Figure 15: Configuring the data view

Related articles:

RFID