Connect to and Query Salesforce Data in QlikView


QlikView is a business discovery platform that helps anyone perform self-service business intelligence. This article explains how to use the CData ODBC Driver to connect to Salesforce data and create data visualizations in QlikView. 

When you send advanced SQL queries from QlikView to Salesforce, the driver sends supported SQL operations, such as filters and aggregations straight to Salesforce and performs unsupported actions (e.g. SQL functions and JOIN operations) client-side using the embedded SQL engine. You can visualize and analyze Salesforce data using native QlikView data types thanks to built-in dynamic metadata querying. 

Connect to Salesforce as an ODBC Data Source 

If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the