title: Knime with database
body: <p>How to add new driver into database through KNIME preferences? Generally,  </p>
  
  <pre><code>File-&gt; Preferences -&gt; Add File/ Add Directory
  </code></pre>
  
  <p>The files accepted are only of <code>*.jar</code> or <code>*.zip</code>.  </p>
  
  <p><strong>MY QUESTION</strong>  </p>
  
  <p>I have installed <code>ODBC64</code> into my PC. Now I need to add that file into <code>knime</code> preferences and use the Driver into Database Connector node.  </p>
  
  <ul>
  <li>How to add and use the file into my Knime?</li>
  <li>And What  is meant by Database URL <code>jdbc:mysql://host:port/database_name</code><br>
  Host and port?</li>
  </ul>
  
  <p>Can anyone please briefly explain and  help me out?</p>