The ODBC Driver for Salesforce from CData provides ODBC-based access to live Salesforce data, allowing you to interact with Salesforce data in a range of BI, reporting, and ETL tools — as well as directly using SQL queries. In this article, we demonstrate how to connect to Salesforce data using an ODBC connection in Alteryx Designer to conduct self-service BI, data preparation, data blending, and advanced analytics.
When you send complex SQL queries from Alteryx Designer to Salesforce, the driver sends supported SQL operations straight to Salesforce, such as filters and aggregations, and uses the embedded SQL engine to handle unsupported operations client-side (e.g., SQL functions and JOIN operations). With built-in dynamic metadata querying, you