Due to limitations of Java 8, ODBC is no longer supported for Access database
connections, and the only supported database driver type is JDBC.
For an MS SQL Server (JDBC) connection, when Microsoft is
selected from the Db Version list, you need to download the
Microsoft JDBC driver for SQL Server on Microsoft Download Center, unpack the downloaded zip
file, choose a jar in the unzipped folder based on your JRE version, rename the
jar to mssql-jdbc.jar and install it manually. For more
information about choosing the jar, see the System Requirements information on
Microsoft Download Center.
You can set up a connection to Oracle using the Wallet by selecting
Oracle Custom from the DB Type
drop-down list, then selecting the Use SSL Encryption check
box and specifying the related properties, including the path to your TrustStore
and KeyStore files and the password for each of them, and whether to disable the
use of CBC (CipherBlock Chaining).
If you need to connect to Hive, we recommend using one of the
Talend
solutions with Big Data.