The terms 32-bit and 64-bit refer to the way a computer’s processor (also called a CPU), handles information. The 64-bit version handles large amounts of random access memory (RAM) more effectively than a 32-bit version.
The important thing to understand that the 32-bit version uses 32-bit version drivers and it cannot use 64-bit drivers. Same apply for the 64-bit version. Before installing the 64-bit version you have to make sure that relevant 64-bit drivers, ODBC Drivers, OleDB Providers and Clients are installed.
For example to make sure that 64-bit version works with Oracle Database you would need to install the 64-bit version of Oracle Client
During our tests, the performance of 64-bit version was very similar to 32 bit.
If you are:
Use the 32-bit version, It is easier to install and configure
For more technologies supported by our ETL Software see Advanced ETL Processor Versions