DemandTools - Which Version: 64-bit or 32-bit?

DemandTools will run on a 64-bit PC and can utilize up to 32GB of RAM for faster downloads, building of results grids, and greatly minimizes "System Out of Memory" exceptions.

Recommendations for Running the 64-bit Version

• Minimum 8GB of RAM
  • More RAM is recommended for users with millions of records up to a maximum of 32GB
• 64-bit Microsoft Office (2010 or higher) is HIGHLY RECOMMENDED with the 64-bit version for full support of all file types
  • Office 2007 or lower available as 32-bit ONLY
  • .csv and .accdb CANNOT be read with the 32-bit version of Office (cannot write to .accdb either), unless running 32-bit Office 2013 with the 64-bit drivers manually installed (see "Note" below)
    • Most other functions will work, but 64-bit Office is HIGHLY recommended for full compatibility
  • .mdb files NOT supported, only .accdb files
    • Version 2.6 supports BOTH reading and writing .accdb files

Note:  The 64-bit Version will support .csv and .accdb with 32-bit Office 2013 as long as the 64-bit Microsoft Access Drivers are manually installed.  Office 2010 WILL NOT allow installing 64-bit drivers with 32-bit Office, but 32-bit Office 2013 DOES allow the 64-bit drivers to be installed.  The 64-bit Access Database Engine drivers can be downloaded HERE.  When you click "Download" select "AccessDatabaseEngine_x64.exe" to install the 64 bit drivers. Users will get the error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" if the 64-bit drivers are not installed.

Improvements can be seen throughout the modules, but areas where significant improvements have been seen include:

• Single Table Dedupe
  • Searching millions of records for duplicates
  • Application of a master rule to large dupe results sets
• Discovery -> Find/Report ID's
  • Can read in much larger input files for comparison to millions of records
• MassImpact
  • Applying formulas to millions of records
  • Using the Object Count and Field Sum Tabs
• MassEffect Export
  • Much faster than the 32-bit version and will not encounter "System out of Memory" exceptions when exporting to .xlsx or .accdb
    • CSV files do not encounter memory errors in the 32-bit version, but the export is still significantly faster in the 64-bit release

Note:  Results are dependent on how much RAM is installed on the PC and the overall processing power of the PC.  Many tests were performed on PC's with 16GB of RAM, Intel(R) Core(TM) i7 CPU @ 2.50GHz working with approximately 2 million records.  The speed of processing any merges, posting any data changes etc. will be Salesforce API dependent. Using BULK API where available for processing results is highly recommended.

A 32-bit version is also available for users running on a 64-bit PC that still want/need the 32-bit version due to not being able to upgrade to 64-bit Office and/or smaller Salesforce Organizations that do not need the extra RAM/processing power to complete their requests.

Version Matrix

Please use the following matrix to determine which version to install based on the OS version type (32bit or 64bit) as well as the version of Microsoft Office running on the PC.



Notes:

• 32-bit versions CANNOT be upgraded to the 64-bit version
• Users installing the 64-bit version with 64-bit Office (full support) may want to uninstall the 32-bit version once they have successfully installed the 64-bit version, otherwise both will be installed on the PC
• The 32-bit version installs in the Program File(x86)\DemandTools folder and the 64-bit version installs in the ProgramFiles\DemandTools64Bit folder
• Users can upgrade (no uninstall required) from a previous 32-bit version to the new 32-bit version, and 64-bit users will  be able to upgrade to later 64-bit versions (i.e. future releases)