Live ODBC Import Agent

<< Click to Display Table of Contents >>

Navigation:  Live > Agents > Other Agents >

Live ODBC Import Agent

The ODBC Import Agent is a Live agent/report available in EQuIS Live (in EarthSoft.Live.Reports.dll) for importing data from database management systems (DBMS) into EQuIS Live, using Open Database Connectivity (ODBC).

 

Also see Database Import Agent (Microsoft SQL), for importing data from Microsoft SQL Server databases (EQuIS or not) into EQuIS Live.

 

Importing Data

 

The ODBC Import Agent can be run as a scheduled EQuIS Information Agent (EIA), at the desired frequency, to automatically import data as often as needed. Or it can be run outside of EQuIS Enterprise, as a Windows Service, using the Agent Service.

 

The ODBC Import Agent has the following input parameters.

 

Parameter

Description

ODBC DSN Source

ODBC source connection string (e.g., some_odbc, connects to the ODBC source using DSN=some_odbc).

SQL SELECT

SQL SELECT statement used to import data from the ODBC source.

 

Example: SELECT 'logger' as logger_code, sensor_name as series_name, sensor_desc as series_desc, value_date as datum_utc_dt, value_num as datum_value, value_flag as datum_qualifier WHERE value_date > ?

 

where '?' is the minimum date time of all of the ODBC source series' most recent date times in the EQuIS Live database (in DT_LOGGER_DATUM.DATUM_UTC_DT).

 

Note: ODBC cannot use named parameters. The command string uses placeholders for every parameter and this placeholder is a single question mark, not the parameter name. See here for more info.

Date Type

The date/time type of the the ODBC source (e.g., the value_date type in the SQL SELECT example).

 

The Date Type can be one of the following values:

Date

DateTime

SmallDateTime

Time

Timestamp

 

See the OdbcType Enum for more details.

UTC Data Offset(s)

The UTC offset, in hours, used to convert from a local ODBC source date time to the UTC date time in the EQuIS Live database (in DT_LOGGER_DATUM.DATUM_UTC_DT).

 

Example: -5 for Eastern Standard Time (EST).

SAVE changes to database?

Check this box to save the imported data to the EQuIS Live database, or uncheck it to display a summary of the imported data without saving it.