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.