Enable foreign keys retrieval

Retrieving metadata from cloud services generally takes longer compared to traditional databases, with foreign key retrieval being one of the most time-consuming operations.

By default, the driver doesn’t include foreign keys in the metadata it retrieves from Salesforce. doesn’t include foreign keys in the metadata it retrieves from Salesforce This improves application performance by reducing the amount of data processed and transferred, resulting in faster metadata retrieval and lower resource consumption.

If your application needs foreign keys, you can enable their retrieval in ODBC Data Source Administrator:

1. Select your DSN, then click Configure.

A selected DSN in ODBC Data Source Administrator

2. Select the Advanced Settings tab.

3. Select Return Foreign Keys (may significantly degrade performance).

4. Click OK.

Advanced Settings tab in the Devart ODBC Driver for Salesforce Configuration dialog