Our Advanced Serial Data Logger software offers two methods to write RS232 data to a database. Both methods have the following key features:
- The logger exports RS232 data to a database in real-time.
- Our RS232 logger software supports most popular databases (MS SQL Server, MySQL, MS Access, Oracle, Firebird, Interbase, SQLite and others).
- Our logger can be configured to write data to a table with any structure.
RS232 to database. Method #1.
Exporting data from RS232 to a database using the "ODBC Database" plugin.
- [+] Number of supported database is rather large than in the method #2;
- [+] This plugin does not require a knowledge of SQL dialect;
- [-] ODBC drivers are required;
- [-] This plugin cannot create a copy of data if a connection with the ODBC database is lost;
Advanced Serial Data Logger and all necessary plugins you can download from our download area. The standard installation package includes all necessary plugins to log data from RS232 to the ODBC database.
RS232 to database. Method #2.
Exporting data from RS232 to a database using the "SQL Database Pro" plugin.
- [+] This plugin can create a copy of data if a connection with the database is lost;
- [+-] You should know the SQL dialect, but it allows to use server specific features like stored procedures and functions;
- [+] This method is rather faster because the logger does not use third-party drivers and connects to the database directly.
- [+] This method allows writing data from RS232 to several tables at the same time.
Advanced Serial Data Logger and all necessary plugins you can download from our download area. You need to download the "SQL Database Pro" plug-in separately.
RS232 to a database using our data logger software
Complete the following steps in order to configure our software for data logging from RS-232 to database:
1. RS-232 Data Logger Software Free Trial downloads
Download and install our software.
You will need the following plug-ins:
- The "ASCII Data Parser" plug-in to extract data from the common data flow.
- The "ODBC Database" plug-in to export data from RS232 to an ODBC database using the method #1.
- The "SQL Database Pro" plug-in to export data from RS232 to a SQL database using the method #2.
The following diagram illustrates the internal data flow from RS232 to a database:
2. Configure the ASCII data parser
Our tutorials section contains several examples for different data formats. Also, our support team will glad to help you with the parser settings.
3. Create and configure the database
You need to create a database with necessary structure and grant the access rights to an user. The detailed description of this process you can find in our tutorials.
4. Configure a connection with the database
The help file for each plug-in contains the detailed description of connection parameters.
5. Bind your columns from a table with RS232 data
In the "SQL Database Pro" plug-in you should write a SQL statement like:
INSERT INTO DATA (Column1, Column2) VALUES (:P1, :P2)
and bind your parser items to P1-P2.
In the "ODBC Database" plug-in you can import a table structure and bind your parser items to necessary columns. Then you can delete unused columns from the list.
RS-232 to database Glossary
RS232 Port, RS232, RS-232 - usually identifies serial ports more or less compliant to the RS-232 standard.
Database - A database is an organized collection of data for one or more purposes, usually in digital form.