LNDB LoggerNet Database Software
Designed for Data Network Administrators
Push data from LoggerNet data cache to relational databases
weather applications water applications energy applications gas flux and turbulence applications infrastructure applications soil applications

Overview

Current Version: 2.0

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.

Read More

Benefits and Features

  • 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

Images

Similar Products

lndb/u upgrade to current version
lndb/u升级到当前版本

Detailed Description

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是主要的客户端屏幕用于配置LN吗DB 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.

DBExportis 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.

DBImportis 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.

QuickReportsis another database client that can be used to generate simple reports and graphs with data from the relational database.

Specifications

Current Version 2.0
Operating System Windows 10, 8, or 7 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.

Compatibility

Note:The following shows notable compatibility information. It is not a comprehensive list of all compatible or incompatible 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
CR310
CR500(retired)
CR5000(retired)
CR510(retired)
CR6
CR800
CR850
CR9000(retired)
CR9000X(retired)

Software

Product Compatible Note
CSIWEBS
CSIWEBSL
CSIWEBSL/U
CSIWEBS/U
LoggerNet
LoggerNet Admin
LoggerNet Admin Upgrade
LoggerNet/U
RTMCPRO
RTMCPRO/U

其他兼容性信息

支持的数据库

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 12cRelease 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, or MySQL.

Computer Requirements

LNDB runs on Windows®10, 8, or 7 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)04-01-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.

Frequently Asked Questions

Number of FAQs related toLNDB:25

展开全部Collapse All

  1. Is there a stored copy of LNDB “Significant Events”?

    CheckC:\Campbellsci\LNDB\logs.

  2. How can the Windows Authentication that LNDB uses be changed from a host name (computer name) to a user name?

    TheLNDBservice runs under a local system account by default, which may be why it uses the computer name. Go toControl Panel | Administrative Tools | Servicesand set it to run under a user name.

  3. Is there any way to save the RTMC Alarm Log to LNDB from within the LoggerNet environment?

    The easiest way to get the data intoLNDBis to store the information in theLoggerNetdata cache (or, for the information to be in a format that looks like a data logger data file toLNDBso that it can be imported).

  4. Can LNDB be connected to the database software FileMaker?

    No. For information about creating live connections to Microsoft SQL Server, Oracle, or MySQL data sources with FileMaker Pro’s External SQL Data Source feature, visit theFileMaker website.

  5. Is Baler needed to use LNDB with LoggerNet?

    No.LNDBworks independently ofBaler.

  6. 是否有任何方法可以在不使用LNDB管理器的情况下更改LNDB使用的LoggerNet服务器？

    No. It can only be changed using theLogin to LoggerNet Serverdialog box. TheLogin to LoggerNet Server对话框自动打开LNDBis installed. It can also be opened at any time from theFile | Select LoggerNet Servermenu item or by double-clicking theLN Connection Status Labelon the Status Bar.

  7. Does LNDB work on any server-class OS, or is it limited to a desktop OS?

    LNDBhas been tested to run on Windows 7, Windows 8, and Windows 10.

    Because Windows Server installations are all uniquely configured, it is nearly impossible for our application engineers to replicate a customer’s implementation environment at our facility.

    To test whetherLNDBwill work in a particular Windows Server environment, download the 30 day trial versions ofLoggerNetandLNDB. Each is available in the Downloads section of the product page:LoggerNetandLNDB.

  8. Can table names be changed in LNDB?

    Table names inLNDB是自动生成的,不能更改。

  9. Can LNDB be used to select a specific date range to create a separate data file?

    One method is to useCustom Collectto specify a range of data and then store the data to a different file. Alternatively, ifLNDBis set up to store data in a database, a range of data can be pulled out and stored in a separate data file. These two methods, however, are manual ones.

  10. Does LNDB use LoggerNet-SDK to pull data from the LoggerNet cache?

    Yes, as part of the SDK—the CSIDataSource control.

Case Studies

delaware river: bridge health
Delaware River: Bridge Health
Intelligent Infrastructure Systems, a Pennoni company, was contracted to design and install an efficient structural-health......read more
Explore All Case Studies

Privacy Policy Update

We've updated our privacy policy.Learn More

Baidu