eDNA

The SQL to eDNA Service provides an optimized, bi-directional gateway between your eDNA system and your databases supporting Structured Query Language (SQL Databases). Values from any eDNA real-time service are collected and transferred into any SQL Database such as Oracle or MS SQL Server, and values from any SQL Database are collected and transferred into eDNA. The SQL to eDNA Service is a real-time service. The SQL service allows eDNA to easily work with other existing systems.

The act of collecting groups of eDNA real-time values and transferring them to an SQL Database is referred to as a transaction. The status of transactions are posted to a current-value-table and optionally maintained in eDNA history. When the SQL to eDNA service collects values from SQL, the values are posted to a fully functional eDNA real-time service.

Values retrieved from a SQL Database are:

• Posted to a current-value-table where they can be accessed by any eDNA real-time client and accessed by eDNA Services like the Calculation Service
• Stored to eDNA Archive Service where they can be accessed by all the standard eDNA history clients. The SQL to eDNA service communicates using open database connectivity (ODBC). ODBC is Microsoft's strategic interface for accessing data in a heterogeneous environment of relational and non-relational database management systems (DBMS). ODBC provides a uniform way of accessing data stored in a variety of proprietary personal computer, minicomputer, and mainframe databases.

We have seen an increase in the attempted use of SQL databases for storing real-time values. Because of the nature of access and storage methods employed by SQL databases, moving data to a SQL Database in real-time can impose loads which can easily overwhelm an application. eDNA users are increasingly viewing the SQL to eDNA Service as a means of relieving some of the load from their SQL Databases. In many cases eDNA can act as a buffer between real-time data and the SQL database. Data, acquired by eDNA either directly or from the SQL database, can be accessed using the flexible eDNA tools at their disposal for performing data analysis and monitoring.