Push data from LoggerNet data cache to relational databases
Visão Geral
LoggerNet DB (LNDB) is ideally suited for transitioning data from LoggerNet’s data cache to a relational database of your choice. Publishing user-selected LoggerNet collected data to these relational databases enables data administrators to share their data with a large customer base across various platforms and methods. Those platforms could include custom websites (including those developed with RTMC and CSIWEBS), custom data reporting systems, data warehousing, and customer software (web and desktop) applications. This application is for data network administrators that want to push their valuable LoggerNet data into relational databases and have that data published in real time (as often as the data is collected).
The low-cost LNDB software is simple to set up and administer and gives you the flexibility you need for your organization. Most users can have the software installed and LoggerNet data uploading to their relational database in less than 20 minutes' time (assuming the database and LoggerNet are set up and proper credentials are issued to the data manager). After setup, LNDB runs as a service on Windows and continues to reliably push LoggerNet data to the relational database, allowing you to focus your time and energy on other projects.
Leia maisBenefícios e Características
- Reliably moves data from user-selected LoggerNet data caches into tables in a relational database
- Can be used to import data from user-created data files into a relational database table
- Exports data from a database table into a data file
- Includes QuickReports application to design simple report from an LNDB database
- Allows users to review database data in real time
- Monitors the LNDB data ingestion engine
- Simple to set up and easy to use
- Saves data managers money by not having to hire a database administrator and a custom software developer
imagens
Produtos Relacionados
Descrição Técnica
LNDB can be run as a service on the workstation or server. This ensures that when the computer is restarted, LNDB is automatically started without human intervention. This allows data ingestion from LoggerNet to the relational database to continue after unforeseen power issues or automatic operating system updates.
LNDB Manager is the main client screen used to configure the LNDB engine. It is used to determine which LoggerNet system to connect to and which database is used. LNDB Manager can also be used to watch the status of various data collections and data push events. Data can be reviewed in tabular columns directly from the database without having to use database-specific tools. Status messages and Significant Events can be viewed using LNDB Manager as well.
DBExport is a database client that can be used to retrieve data directly from the relational dabase. Users can pull all the data from the database or select data using data ranges. EDExport also has the ability to check for and inform the user of missing records for the exported data. Exported file formats include TOA5, TOACI1, TOB1, CSIXML, and Custom CSV.
DBImport is a database client that can be used to import data from existing data files. The user can ingest the data into an existing table or create a new one in the database. These data files can be either those created by LoggerNet or database files from other sources or data loggers.
QuickReports is another database client that can be used to generate simple reports and graphs with data from the relational database.
Especificações
| Operating System | Windows 11 or 10 and Windows Server versions 2012 R2, 2016, or 2019. (Users using Windows Server with security policies other than the default policies will need to work with their IT administrations to resolve any security issues.) |
| Required Framework | This software requires the Microsoft .NET 4.6.2 (or better) Framework to run properly. To use the reporting functions of LNDB 2.0, Microsoft .NET Framework 3.5 also needs to be installed. If the required version of the .NET framework is not already installed on your computer, it can be obtained from the Microsoft Download Center. |
Documentos Relacionados
Lâminas do produto
Compatibilidade
Please note: The following shows notable compatibility information. It is not a comprehensive list of all compatible products.
Data Loggers
| Product | Compatible | Note |
|---|---|---|
| 21X (retired) | ||
| CR10 (retired) | ||
| CR1000 (retired) | ||
| CR1000X | ||
| CR10X (retired) | ||
| CR200X (retired) | ||
| CR206X (retired) | ||
| CR211X (retired) | ||
| CR216X (retired) | ||
| CR23X (retired) | ||
| CR295X (retired) | ||
| CR300 | ||
| CR3000 (retired) | ||
| CR310 | ||
| CR350 | ||
| CR500 (retired) | ||
| CR5000 (retired) | ||
| CR510 (retired) | ||
| CR6 | ||
| CR800 (retired) | ||
| CR850 (retired) | ||
| CR9000 (retired) | ||
| CR9000X (retired) |
Software
| Product | Compatible | Note |
|---|---|---|
| CSIWEBS | ||
| CSIWEBSL | ||
| CSIWEBSL/U | ||
| CSIWEBS Upgrade | ||
| LoggerNet | ||
| LoggerNet Admin | ||
| LoggerNet Admin Upgrade | ||
| LoggerNet Upgrade | ||
| RTMCPRO | ||
| RTMC Pro Upgrade |
Additional Compatibility Information
Supported Databases
LNDB has been tested and shown to work with the following databases:
- Microsoft® SQL Server® (Express, Standard, and Enterprise) 2005–2019
- Microsoft® SQL Server® Compact 3.5 SP2 (installed with LNDB)
- MySQL 5.0–8.0 (with an appropriate 32-bit ODBC database driver; for example, MySQL 5.0 or 5.1 with MySQL 3.51.27 or 5.1.6 ODBC database driver, note that earlier versions of 5.x ODBC database drivers have known issues; MySQL 5.6 with MySQL 5.3 ODBC database driver)
- Oracle Database 12c Release 1 (12.1.01) and 18c (18.1.0)
- PostgreSQL 9.4 through 12
Note: LNDB may work with other versions of SQL Server Express, SQL Server Compact, MySQL, Oracle Database, or PostgresSQL.
Computer Requirements
LNDB runs on Windows 11 or 10 and Windows Server 2012 R2*, 2016*, or 2019*.
*Users using Windows Server with security policies other than the default policies will need to work with their IT administrations to resolve any security issues.
Downloads
LNDB Trial v.2.0 (45.7 MB) 01-04-2019
A fully functional 30 day trial version of LNDB (LoggerNet DataBase) software.
Note: This application requires the Microsoft .Net 3.5 and .Net 4.6.2 Frameworks. If they are not already installed on your computer, they can be obtained from the Microsoft Download Center.
Perguntas Frequentes Relacionadas
Number of FAQs related to LNDB: 26
Expandir todosRecolher todos
-
There are several approaches you can try:
- The LNDB Interface can pull data from LoggerNet and insert it into a database instance. Supported database platforms are as follows: Microsoft SQL; MySQL; unofficially, MariaDB as it is open source MySQL, PostGRESQL, and Oracle. The database table structure and metadata will match the structure of the station’s program and the station name used in LoggerNet exactly. You cannot customize the structure. Refer to the setup documentation.
- Read or parse data from LoggerNet .dat files. The files are CSV formatted and can be parsed in using most any programming language. Files by default are stored on the LoggerNet computer in the following path: C:\Campbellsci\LoggerNet.
- LDMP Server, a LoggerNet Admin component, offers a listening socket for data to be pulled directly from the LoggerNet cache over the LoggerNet Service listening port 6789. Complete documentation in LoggerNet Admin is stored in the following path: C:\Program Files (x86)\Campbellsci\LoggerNet\ldmp_server2.pdf.
- Read in data using the CSI web server’s built in Web API. The webAPI accepts queries in the same format as the data logger’s built-in webAPI. Refer to the data logger webAPI documentation.
- The LNDB Interface can pull data from LoggerNet and insert it into a database instance. Supported database platforms are as follows: Microsoft SQL; MySQL; unofficially, MariaDB as it is open source MySQL, PostGRESQL, and Oracle. The database table structure and metadata will match the structure of the station’s program and the station name used in LoggerNet exactly. You cannot customize the structure. Refer to the setup documentation.
-
Check C:\Campbellsci\LNDB\logs.
-
The LNDB service runs under a local system account by default, which may be why it uses the computer name. Go to Control Panel | Administrative Tools | Services and set it to run under a user name.
-
LNDB currently requires that all data logger table columns have a corresponding database table column. There are currently three options when table definitions change:
- Stop Storing Data (The user can manually alter/archive the database table.)
- Archive Database Table
- Modify Database Table (New columns are added, and old columns are orphaned. If the database column data type is not what is expected, an archive occurs.)
-
No. LNDB works independently of Baler.
-
Yes, as part of the SDK—the CSIDataSource control.
-
Table names in LNDB are automatically generated and cannot be changed.
-
If the stations are all accessed by the same instance of LoggerNet, LNDB can collect table data from multiple stations. In the LNDB Manager, highlight the station in the left tree, and select the checkboxes next to the desired table names.
Note: LNDB can only communicate with one instance of LoggerNet.
-
The easiest way to get the data into LNDB is to store the information in the LoggerNet data cache (or, for the information to be in a format that looks like a data logger data file to LNDB so that it can be imported).
-
Not at the same time. Currently, a user would have to manually switch back and forth between the database hosts periodically using the File menu Select Database... option to keep them both updated.
Estudos de Caso
Intelligent Infrastructure Systems, a Pennoni company, was contracted to design and install an efficient structural-health......Leia mais