The CData ADO.NET Provider for Salesforce Data Cloud models Salesforce Data Cloud objects as tables and views. The following sections show the available API objects and provide more information on executing SQL to Salesforce Data Cloud APIs.

Schemas for most database objects are defined in simple, text-based configuration files.

Custom Data Source DLOs (Tables)

Salesforce Data Cloud allows you to use Ingestion API Connectors to define connections to data sources that are not natively supported by Salesforce Data Cloud.

After setting up an Ingestion API Connector for your data source and creating a data stream from it, that data stream is made available in the provider as a table. These tables support UPSERT and DELETE operations.

See Custom Data Sources as Tables for more information.

Using CalculatedInsights

See CalculatedInsights Data Model for the available entities in the CalculatedInsights schema.

Using DataGraphs

See DataGraphs Data Model for the available entities in the DataGraphs schema.

Using DataModelObjects

See DataModelObjects Data Model for the available entities in the DataModelObjects schema.

Using DataLakeObjects

See DataLakeObjects Data Model for the available entities in the DataLakeObjects schema.