User Tools

Site Tools


firststeps

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
firststeps [2009/04/20 08:23]
132.168.73.247 créée
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**
 +
 +===== hEIDI Projects =====
 +
 +It is possible to create hEIDI projects in order to organise data. For now, data consist of SQL queries...
 +To create a Project, click right in the ''​Project''​ window or choose ''​File > New Project''​ menu and only specify the project name in the wizard. ​
 +
 +
 +===== SQL Queries =====
 +
 +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''​.
 +
 +{{:​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''​.
 +
 +
firststeps.txt · Last modified: 2010/01/05 15:40 by 132.168.73.247