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.

Note: The saved data files from the ODBC Import Agent report can be saved to any letter data drive. Saving the data files to either of the options listed below is recommended:

1.Save the data files to the same lettered drive on the server as where EQuIS Enterprise Workflow Service is running, including the processing of EIAs.

2.If the computer is configured to "Map Network Drive To" another computer, files may be saved to the other computer as long as the server is accessible from where the Workflow Service is running.

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 > {INSERT MINIMUM DATE} where '{INSERT MINIMUM DATE}' 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.