The CData Excel Add-In for Salesforce Marketing Cloud models two Salesforce Marketing Cloud APIs as relational databases, the REST API and the SOAP API. Set the Schema property and use the information in each section to select the proper API based on your project needs.
Collaborative Query Processing
The add-in offloads as much of the SELECT statement processing as possible to the Salesforce Marketing Cloud APIs and then processes the rest of the query within the add-in.
See SupportEnhancedSQL for more information on how the add-in circumvents API limitations with in-memory client-side processing.
Using the REST API
The REST API exposes broader access to Salesforce Marketing Cloud capabilities. All new Salesforce Marketing Cloud technologies implement REST API. See REST Data Model for the available entities in the REST API.
Using the SOAP API
The SOAP API provides comprehensive access to most email functionality. The SOAP API uses SOAP envelopes to pass information between you and Salesforce Marketing Cloud. See SOAP Data Model for the available entities in the SOAP API.