ODBC Driver for Salesforce

Build 24.0.9029

Data Model

You can use the driver to work with all of the tables in your account. The driver connects to Salesforce and gets the list of tables and the metadata for the tables by calling the appropriate web services. Any changes you make to your Salesforce account, such as adding a new table, adding new columns, or changing the data type of a column, are immediately reflected when you connect using the driver.

Tables

The driver models the Salesforce API as relational Tables. The table definitions are dynamically retrieved; here, we show the sample table definitions that are included in the Salesforce.com development environment.

In addition to the tables, the driver also offers stored procedures and views, enabling you to work with other aspects of the Salesforce API, like bulk jobs, custom reports, and so on.

Stored Procedures

Stored Procedures are function-like interfaces to Salesforce. They can be used to search, update, and modify information in Salesforce.

Views

Views offer additional metadata information from Salesforce.

Working with Polymorphic Fields

Polymorphic Fields explains how to work with related objects as different types of objects.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9029