Sales Force Connector
Connect to Salesforce via ODBC
The SalesForce ODBC Connector is a powerful tool that allows you to connect to the live SalesForce account data directly from any application that supports ODBC connectivity. Access Salesforce data from a database: read, write and update leads, contacts, opportunities and accounts through a standard ODBC driver interface. This connector is suitable for both Qlik Sense like QlikView, but can also be used for other tools, such as our data warehouse solution TimeXtender and other BI tools, such as PowerBI In Excel.
Your benefits
- Includes support for custom Salesforce entities.
- Perform atomic and batch update activities.
- Compatible with SOAP API versions 30.0 and above.
- Translated SQL-92 queries to SOQL queries.
- Powerful metadata querying enables SQL-like access to non-database resources.
- Push-down optimization pushes SQL operations down to the server where possible, improving performance.
- Client-side query execution engine, supports SQL-92 operations not available on the server.
- Connect to live Salesforce & Force.com data for real-time access to data.
- Seamless integration with leading BI, reporting and ETL tools as well as with custom applications.
- Full support for data aggregation and complex JOINs in SQL queries.
- Secure connectivity through modern cryptography, including TLS 1.2, SHA-256, ECC, etc.
Specifications
- Supports 32-bit and 64-bit applications.
- ODBC 3.8 compliant proprietary protocol based drivers.
- Extensive ANSI SQL-92 support.
- Full Unicode support - any language, any data.
- Cross platform ODBC. Available for Windows, Linux and macOS.