function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
jojoforcejojoforce 

DBAmp versus DataDirect OpenAccess SFDC ODBC Driver

Our company is looking to utilize an ODBC driver, and I was wondering if anyone has/have used DBAmp and/or DataDirect OpenAccess SFDC ODBC. Which one will give us more bang for our buck?

 

I've done my fair amount of research..  I mean googling ;) on these two products and so far it seems that DBAmp has more documentation available than OpenAccess. I've tried the trial version of both, but due to the limited amount of time they allow to evaluate these software, I couldn't make out advantages and disadvantages of using one or the other.

 

Thanks to anyone in advance who might be able to provide us some insights on these two tools. Thank You

 

DataDirect OpenAccess ODBC for SalesForce.com

http://web.datadirect.com/products/other/openaccess-sf/index.html

 

DBAmp

http://www.forceamp.com/

SalesforceODBCSalesforceODBC

Progress DataDirect Connect XE for ODBC Driver for Salesforce CRM and Force.com was released just last week.

Here are the Release Highlights: http://www.datadirect.com/products/odbc/salesforce_crm_odbc_driver/index.html

You can download a fully functional trial copy of the driver and find out more about our ODBC and JDBC Salesforce drivers here: http://www.datadirect.com/solutions/saas_and_cloud_computing/cloud_data_access/index.html.  If you need some additional time to test over the two-week initial period, your account manager can often work with you to get the trial license extended.

forceAMPforceAMP

Advantages of DBAmp

 

- Installed in over 1000 salesforce.com sites

- Direct support for SOQL queries (for best performance when doing joins)

- Extensive support for maintaining a local copy with both Full and Incremental backups

- UPSERT api call support for complicated integrations

- BULKAPI support for massive data loads

- Support for multiple currency

- Ability to retrieve both archived and deleted records of a table

- Written in high performance C++

- 32 five star ratings on AppExchange

- Licensed per salesforce org, install it on as many local servers as you like

- $1295 a year

- All sandboxes included in the license fee

 

But as the developer, I'm probably a little biased :)

 

 

scaifeascaifea

Or the new Easysoft Salesforce ODBC Driver!

 

  • This ODBC Driver uses our proven, robust and fast SQL Engine.
  • Use any ODBC compliant 32-bit or 64-bit application to gain insight into your business.
  • It extends the native Salesforce Object Query Language (SOQL) providing improved management of the data.
  • Potentially lower support costs if your developers already use ODBC.
  • Establish a secure connection to your Salesforce.com data.
  • Provides the ability to define company specific reports based on real-time data.