User Tools

Site Tools


firststeps

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Next revision Both sides next revision
firststeps [2009/04/20 08:55]
132.168.73.247
firststeps [2009/04/22 16:33]
132.168.73.247
Line 10: Line 10:
  
 {{:​connect.png|}} {{:​connect.png|}}
 +
 **Connection to a postgres server** **Connection to a postgres server**
  
Line 20: Line 21:
 ===== SQL Queries ===== ===== SQL Queries =====
  
-Once the connection is successful, the first simple feature is to explore the database or create SQL queries. ​The MSI database model is available here (FIXME).+Once the connection is successful, the first simple feature is to explore the database or create SQL queries. ​Information on MSI database ​and its model is available ​[[http://​biodev.extra.cea.fr/​docs/​irma/​doku.php?​id=msidb| ​here ]].
  
 You can create new SQL files from hEIDI project (''​File > New File''​ menu then choose ''​Empty File''​ or directly ''​New Empty File''​ from hEIDI Project window) . It is also possible to select a Table under database connection and choose ''​Veiw Data''​. You can create new SQL files from hEIDI project (''​File > New File''​ menu then choose ''​Empty File''​ or directly ''​New Empty File''​ from hEIDI Project window) . It is also possible to select a Table under database connection and choose ''​Veiw Data''​.
 +
 +{{:​sql_comment.png|}}
 +
 +** SQL queries sample **
  
  
 +===== Open MSI Session =====
  
 +To open a working session on the MS identification database, select the connection in ''​Service Window''​ and open menu ''​MS Identification > Open session''​.
  
-===== En-tête 2 ===== 
  
firststeps.txt · Last modified: 2010/01/05 15:40 by 132.168.73.247