Features

• Access Salesforce data in real time for in-depth analysis - Connect directly to Salesforce from BI & analytics tools, databases, data warehouses, and custom applications.
  • Integrate Salesforce with various data management solutions.
  • Enable bi-directional connectivity using standard data access protocols.
  • Ensure data security with user-specific, source-level permission controls.
  • Increase performance with push-down processing that offloads filtering and aggregation to the server when applicable.
• Extended SQL syntax - Work with Salesforce objects in the same way as with SQL tables. The extended SQL syntax allows using all the SQL benefits in SQL-92 compatible SELECT statements.
  • Complex JOINs
  • WHERE conditions
  • GROUP BY statements
  • ORDER BY clauses
  • Aggregation functions
  • Subqueries
• Verified Compatibility With Data Integration Tools - Devart ODBC drivers are verified to be compatible with leading analytics and reporting tools, various IDEs, and programming languages. Get fast and secure access to your data in any application:
  • Database Management Software
    • SQL Server Management Studio (SSMS)
    • Microsoft Access
    • DBeaver
    • RazorSQL
    • and others
  • Business Intelligence & Analytics Software
    • Power BI
    • Tableau
    • QlikView
    • TIBCO Spotfire
    • and others
  • Document Management Software
    • Microsoft Excel
    • LibreOffice
    • OpenOffice
    • StarOffice
    • and others
  • Application Development Tools
    • Microsoft Visual Studio
    • Python, PHP
    • FileMaker
    • C++ Builder
    • and others

Salesforce ODBC Driver

• Support for SQL / SOQL queries - Execute both SQL and SOQL queries to retrieve and manipulate data from your Salesforce instance. Easily switch between relational and Salesforce-specific query languages to address your querying needs.
• ODBC conformance - Ensure full compliance with ODBC standards, maintaining consistent behavior across ODBC-compliant applications. Integrate Salesforce data flawlessly into your tools and platforms.
• DML operations - Perform DML operations, including INSERT, UPDATE, and DELETE, ensuring data remains synchronized and up-to-date across all ODBC-enabled applications and your Salesforce environment.
• Salesforce compatibility - Stay compatible with the latest Salesforce features and APIs. Keep your connection robust and reliable as Salesforce updates and introduces new innovations.
• Advanced data conversion - Take advantage of data conversion capabilities for smooth interoperability between Salesforce and ODBC-compliant systems. Enjoy accurate data type translation during data exchange.
• High performance - Enjoy exceptional performance with fast, efficient data access. Benefit from optimized queries and data retrieval, even when handling large datasets from Salesforce.