N. America: (800)876-3101 | World: +44 (0) 1-344-386-367

SALESFORCE ODBC DRIVER

The Most Scalable, Best Performing Salesforce ODBC Driver

Salesforce.com ODBC Driver Salesforce.com ODBC Driver
Click to Enlarge

New data sources established in the cloud bring new challenges to ensure best-of-class data connectivity. The Progress DataDirect Connect XE for ODBC driver delivers the best performance, scalability, and reliability for enterprise applications that need to leverage mission-critical Salesforce.com data.

Try it now – Download Salesforce ODBC driver.

DataDirect's Platinum ODBC Salesforce driver is available for UNIX and Linux platforms as well as Windows and for 64 bit ODBC connectivity. With low latency, high throughput and resource efficient access to Salesforce, DataDirect Connect XE for ODBC moves business applications closer to Salesforce data. In effect, IT organizations no longer need to mirror Salesforce instances to ensure high performance SQL access.




Improves the performance and scalability of your applications DataDirect ODBC drivers are proven to out-perform competitive drivers, demonstrating marked improvement in response time, throughput, and scalability. The wire protocol architecture, as well as easy-to-use tuning options, optimizes the rate and efficiency of data transfer. Application-driven caching increases Salesforce.com integration scalability. And a high-performance Bulk Load capability enables large amounts of data to be loaded very quickly.
Reduces the cost and time of deploying and maintaining applications DataDirect’s wire protocol architecture eliminates the need for additional components on the database server for connectivity. Apart from a Java runtime environment, one install contains everything needed to connect to Salesforce.  DataDirect’s SQL engine offers full SQL 92 compliance over any Salesforce instance.
Enables streamlined modification of Salesforce data The DataDirect Salesforce ODBC driver is written to the Salesforce API, and it is widely used for modifying data, including bulk loading.
Provides comprehensive coverage from one vendor DataDirect offers a Platinum ODBC driver for Salesforce.com on every major platform – Windows (including v7), Linux and UNIX, including UNIX platforms such as IBM AIX, HP-UX, and Sun Solaris, across a wide range of processor architectures. A 64 bit ODBC driver for Salesforce enables 64-bit applications to take full advantage of faster processing speeds.
Makes it easy and cost effective to support multiple databases / database versions One Salesforce ODBC driver supports simultaneous connections to Salesforce, which significantly reduces the costs of deploying and testing applications. This also allows you to consolidate critical business applications onto a single platform. In addition, DataDirect drivers boast numerous interoperability features that simplify the task of supporting other databases in addition to Salesforce, such as Oracle, DB2, SQL Server, Sybase, MySQL, and more.
Reinforces your security strategy DataDirect drivers include advanced, industry standard security mechanisms such as SSL data encryption.
Ensures high availability Connect XE for ODBC delivers improved reliability with abstracted failover semantics without application modification.
Guarantees quality and reliability Connect XE for ODBC is ODBC 3.5 compliant with Driver Manager and ODBC Administrator integration. DataDirect ODBC drivers are quality tested and certified with a wide variety of applications and environments and are proven in hundreds of leading commercial software products and thousands of the most demanding corporate environments.
Reduces total cost of ownership through superior technical support In contrast to database vendors and other third-party vendors, DataDirect's award-winning support is focused exclusively on data connectivity and includes 24x7 phone, web, email, forum, and an extensive knowledgebase. Resolving data connectivity issues quickly reduces the total cost of ownership of software.

 

DataDirect features are 100% driver implemented, allowing them to be leveraged quickly without requiring changes to application code or proprietary Salesforce extensions.

Performance

  • Wire protocol architecture
  • Increased Salesforce integration scalability with application driven caching
  • Bulk Load
  • Built-in debugging capabilities
  • Enterprise-quality driver logging
  • Advanced Connection Pooling
  • Data conversion
  • Socket management
  • Network wire management
  • Batching and throughput optimization

Comprehensive Database / Platform Coverage

Security

  • SSL data encryption

Enterprise Application Functionality

  • Application failover - Improved reliability with abstracted failover semantics without application modification
  • Windows ODBC Driver Manager for Unix/Linux
  • Unicode and ANSI character sets
  • Exposes Salesforce reports as stored procedures

Interoperability

  • Interoperability including SQL up-leveling, which simplifies the task of supporting other databases in addition to Salesforce, such as Oracle, DB2, SQL Server, Sybase, MySQL, and more
  • Common architecture across drivers makes it easy to support different databases

Quality and Reliability

  • Quality tested and certified with the DataDirect ODBC Verification Suite (OVS), the largest, most mature ODBC testing infrastructure
  • 100% ODBC 3.5 compliance with Driver Manager and ODBC Administrator integration specification compliance – leverage Salesforce functionality without proprietary extensions or code

Additional Salesforce ODBC Driver Functionality

  • SQL Engine offering full SQL 92 compliance over any Force.com instance
  • Exposes Force.com reports as stored procedures
  • Scalar and catalog functions
  • Parameter arrays
  • Data type conversions
  • Supports the ability to execute a single SQL statement using multiple rows of values