Salesforce Connectivity Architecture

Connect your applications to Salesforce using ODBC drivers

Supported Applications

🗄️
SQL Server
🔶
Oracle
📋
Microsoft Access
📊
Excel
📈
Crystal Reports
⚙️
Custom Apps
📊

Easysoft Salesforce ODBC Driver

Standard ODBC connectivity

Uses SQL Statements
  • Standard SQL syntax support
  • Familiar interface for developers
  • Works with existing SQL tools
  • Read and write capabilities
  • Cross-platform compatibility

Technical Details

Best for: Traditional database applications, reporting tools, and data integration scenarios where SQL familiarity is important.

Query Language: Standard SQL (SELECT, INSERT, UPDATE, DELETE)

Performance: Optimized for bulk operations and complex queries

Use Cases: ETL processes, business intelligence, legacy system integration

☁️

Easysoft Salesforce SOQL ODBC Driver

Native Salesforce connectivity

Uses SOQL Statements
  • Native SOQL query support
  • Direct Salesforce API integration
  • Salesforce-specific optimizations
  • Relationship query support
  • Real-time data access

Technical Details

Best for: Applications requiring native Salesforce functionality, complex relationship queries, and real-time data access.

Query Language: SOQL (Salesforce Object Query Language)

Performance: Optimized for Salesforce API efficiency and relationship traversal

Use Cases: CRM integrations, real-time dashboards, Salesforce-centric applications

☁️

Salesforce

CRM Platform & API Services

SQL vs SOQL

SQL: Standard query language familiar to most developers. Translated internally to work with Salesforce data structures.

SOQL: Salesforce Object Query Language designed specifically for Salesforce. More efficient for complex relationship queries.

Feature SQL Driver SOQL Driver
Learning Curve Low (familiar) Medium (SF-specific)
Relationship Queries Good Excellent
Performance Good Optimized

📦 Single Distribution

Both drivers are included in one convenient package, allowing you to choose the best approach for each use case.

Benefits:

  • Simplified deployment
  • Consistent licensing
  • Unified support
  • Flexible implementation

🔧 Setup & Configuration

Easy configuration through standard ODBC Data Source Administrator or connection strings.

Requirements:

  • Salesforce account credentials
  • Security token (if required)
  • Network access to Salesforce
  • ODBC-compatible application