I am trying to connect to SQL Server from Knime version 3.2. I have followed the steps as mentioned in thread for installing SQL driver.
But, i am not able to get the SQL Server driver in the dorndown in Database Reader node.
Following is the error found in Knime.log
2016-08-17 23:36:36,396 : DEBUG : ModalContext : DatabaseDriverLoader : KNIME_project : 0 : Could not load JDBC ODBC driver class 'sun.jdbc.odbc.JdbcOdbcDriver'. Class has been removed in Java 8.
Can somebody please help to correct this?
There isn't a native driver in KNIME for SQL server. You need to download the jdbc driver from microsoft. I have a feeling this is the link (https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774), there are different versions, try tehm until you find one that works. We are using sqljdbc_4.2\enu\sqljdbc4.jar
After you've downloaded the driver, place it in a folder and then in the KNIME Analytic Platform go to File -> Preferences -> KNIME -> Database. Click on the Add file and pick the jar file.
After this, it should appear in the database driver choices. Ours come out as com.microsoft.sqlserver.jdbc.SQLServerDriver