ODBC Compliance

The Progress DataDirect for ODBC for Salesforce driver is compliant with the Open Database Connectivity (ODBC) specification. See "ODBC API and Scalar Functions" for a list of the Core and Level 1 functions supported by the driver for the Salesforce.com Web Services API.

The Salesforce driver extends the standard results returned by the SQLColumns ODBC function to include the IS_EXTERNAL_ID column, as shown in the following table.

Table 1. Extended Functionality for the SQLColumns Function
Column	Data Type	Description
IS_EXTERNAL_ID	VARCHAR (3), NOT NULL	Provides an indication of whether the column can be used as an External ID. External ID columns can be used as the lookup column for insert and upsert operations and foreign-key relationship values. Valid values are: YES: The column can be used as an external ID. NO: The column cannot be used as an external ID. The standard catalog table SYSTEM_COLUMNS is also extended to include the IS_EXTERNAL_ID column.