Server-Based Software / LoggerNet DB Upgrade
LoggerNet DB Upgrade Upgrade to Current Version
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

LoggerNet DB/U is an upgrade to the latest version of our LoggerNet DB (LNDB) software. You must have an earlier version of LNDB to qualify for the upgrade. 

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

  • Upgrade from older version to current version for a discounted price

Images

Detailed Description

LNDB/U allows users who have an earlier version of LNDB to upgrade to the latest version of LNDB.

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 (retired)
CR10X (retired)
CR200X (retired)
CR206X (retired)
CR211X (retired)
CR216X (retired)
CR23X (retired)
CR295X (retired)
CR300 (retired)
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
  • 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, or MySQL.

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.

Specifications

Operating System 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.)

Frequently Asked Questions

Number of FAQs related to LoggerNet DB Upgrade: 25

Expand AllCollapse All

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

    Check C:\Campbellsci\LNDB\logs.

  2. Can table names be changed in LNDB?

    Table names in LNDB are automatically generated and cannot be changed.

  3. 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 the FileMaker website.

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

    LNDB has been tested to run on Windows 10 and 11. 

    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 whether LNDB will work in a particular Windows Server environment, download the 30 day trial versions of LoggerNet and LNDB. Each is available in the Downloads section of the product page: LoggerNet and LNDB.

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

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

  6. Is there a version of LNDB for Linux?

    Currently, LNDB cannot run under Linux unless it is run under a virtual machine that emulates Windows. However, LNDB has the ability to work with these different database engines:

    • SQL Server Compact
    • SQL Server
    • MySQL (uses the MySQL ODBC driver)
    • Oracle
    • PostgreSQL

    There is nothing to prevent a user from continuing to run LNDB on the same Windows host on LoggerNet and posting the data to MySQL, Oracle, or PostgreSQL running under Linux. Configure LNDB (running on Windows) to point to the MySQL, Oracle, or PostgreSQL server running on Linux.

  7. Is there a way to establish connections between LNDB and two different database hosts at the same time?

    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.

  8. How does LNDB handle duplicate records?

    LNDB uses two fields as primary keys: the record number and time stamp. If the record number and time stamp are both duplicated, the record is discarded. If only the record number or only the time stamp is duplicated, LNDB should import the record. 

  9. Can LNDB be used to upload data gathered from LoggerNet to a remote Linux MySQL server?

    Yes, but LNDB can only run on a Windows platform. Run LNDB on the same Windows host on LoggerNet, and post the data to MySQL running under Linux. Configure LNDB (running on Windows) to point to the MySQL server running on Linux.

  10. Which port needs to be open to enable LNDB to communicate with the LoggerNet server?

    The LoggerNet default port number is 6789. If a command line argument has been used to change the LoggerNet default port number, this alternate port number must be open.

    Note: The alternate port number must be specified in the Login to LoggerNet Server dialog box when entering the Server Address (for example, 192.168.7.123:6700).

Visit the FAQ Library

Listed Under

Other Accessory for the following products:

Privacy Policy Update

We've updated our privacy policy.  Learn More

Cookie Consent

Update your cookie preferences.  Update Cookie Preferences