Export External DataBase

Introduction

AdvanNet can be configured to export reads and events to a DataBase. Internal configuration files have to be edited in order to enable this feature.

The configuration will be different depending on the SQL database used: MySQL, PostgreSQL, ...

Credentials

To be able to configure this feature, you will need the credentials for your reader/system, please follow this section of our wiki to obtain them: http://wiki.keonn.com/series150#TOC-Disclaimer-Agreement

Download internal configuration files

The first step is to download the internal configuration files in order to edit them on your computer.

Using an SFTP program like FileZilla or WinSCP, download the following file:

• • /home/keonn/kernel/module/app.AdvanNet/META-INF/connectors.xml

SQL configuration

The section to edit in the connectors.xml file is between the tags SQL:

Edit this section in the connectors.xml file until it looks like this:

This step is different between each SQL system:

MySQL

Download the file connectors-mysql.xml and copy the text between the tag CUSTOM_SQL_EXPORTER from this file to the connectors.xml file that you downloaded from your reader/system.

Edit the tags:

• • <connString>jdbc:mysql://<IP-ADDRESS>/<DATABASE></connString>

  • <user>user</user>

  • <password>password</password>

Edit the different SQL_STATEMENTs, for AdvanNet to be able to create the tables 'inventory' and 'events', and to insert info in these tables.

The connectors.xml file should look like this:

Upload files on to the reader/system

Upload the configuration

Using filezilla or WinSCP, connect to the reader/system and upload the edited connectors.xml file:

Upload the Java libraries

Upload the Java libraries needed:

MySQL

Download the file mysql-connector-java-5.1.6.jar from the Downloads section and upload it to the reader/system on the directory:

• • /home/keonn/kernel/module/app.AdvanNet/lib

Reboot the system

The enable this feature, please reboot the reader/system.

Downloads