• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Installing the required database drivers

You must have the required ODBC or OLE DB drivers installed for the Database Compare Suite to connect to the source and target databases. Installing the required database drivers is an important operation that should be completed before you try to connect to Amazon Redshift, Greenplum, IBM DB2, Microsoft Access, Oracle, Sybase ASE, Sybase IQ, and Vertica databases.

You can download the database drivers from the following locations. When in doubt, choose the driver version corresponding to the version of the server, that is used.

Database Platform Download link
Amazon Redshift http://docs.aws.amazon.com/redshift/latest/mgmt/install-odbc-driver-windows.html
Greenplum https://www.postgresql.org/ftp/odbc/versions/msi
IBM DB2 https://www.ibm.com/analytics/us/en/technology/db2/db2-trials.html
Microsoft Access https://www.microsoft.com/en-US/download/details.aspx?id=13255
Oracle http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
Sybase ASE https://support.sap.com/software/installations.html
Sybase IQ https://www.sap.com/cmp/syb/crm-xm13-dtb-dbtch-tr20/crm-xm13-dtb-dbtch-tr30/index.html
Vertica https://my.vertica.com/download/vertica/client-drivers
Other Other database platforms do not require driver installation.