title: connect to postgresql from enterprise architect
body: <p>I've Enterprise Architect v12 and I want to use its Database builder in order to create a live connection between it and a postgresql database.</p>
  
  <p>This is what I've done:</p>
  
  <ul>
  <li>I've downloaded and installed PostgreSQL 9.5</li>
  <li>During installation I've installed with StackBuilder <code>Npgsql v2.2.4.3-2</code> and <code>psqlODBC (64 bit) v09.03.0400-1</code>.</li>
  <li>I've started <code>pgAdmin III</code> and I can connect to my local database. I've created a new one without problems.</li>
  <li>I've created in EA a new project: in technology I've selected <code>Database</code> and <code>Data model: PostgreSQL</code>.</li>
  <li>In <code>DataModel -&gt; Tables -&gt; Tables</code> I've added a table <code>Table1</code> and I've created a column <code>id</code> (varchar and primary key)</li>
  <li>In the same table I've added a Datatabase connection <code>Database connection 1</code>.</li>
  <li>I double click on <code>Database connection 1</code> and then I select <code>ODBC based database</code>. Then click OK</li>
  </ul>
  
  <p>At this point I'm not able to select my postgresql database. The data origin window (I don't know if it's the right name I've the italian version of windows) gives me two tabs: File origin data and computer origin data. In the first case inside the postgresql data folder that I've selected during installation I don't find anything useful, while in the second case I can see only <code>Excel files</code> and <code>MS Access Database</code>. If I click on <code>New</code> button I can select the data origin only for the current user and in the list I can't see postgresql (SQL Server, Microsoft paradox, etc).</p>
  
  <p>What I'm doing wrong? How can I read my posgresql database from EA?</p>