Differences

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

--- how_to:dbconnection [2009/12/16 09:14]
132.168.73.247 créée
+++ how_to:dbconnection [2016/08/24 15:38] (current)
132.168.73.77
@@ Line 1: / Line 1: @@
-====== How to create a connecting to a database ======
+====== How to create a connection to a database ======
-In order to use hEIDI, a connection to a MSI db (Mass Spectrometer Identification database) is requiered. But it is possible to create a conenction to all kind of databases and to execute queries on it.
+In order to use hEIDI, a connection to a MSI db (Mass Spectrometer Identification database) is required. But it is possible to create a connection for all kind of databases and to execute queries on it.
-===== Create a connection on database =====
 In the ''Service'' window,
-  * expend the ''Drivers'' node
+  * Expand the ''Drivers'' node
-  * select the database server type hosting your MSIdb
+  * Select the database server type hosting your MSIdb: ''PostgreSQL''
-  * enter the connection properties in appropriate fields.
+  * Right-click and select ''Connect using...'' in the context sensitive menu in order to enter the connection properties.
-{{:connect.png|}}
+**Connection to a Postgres server**
-**Connection to a postgres server**
+**Note** :
+  * :!: **Information that appear in the screen shot below are dummy, ask your system admin for your serverhost/database/user/password in order to connect to your database** :!:
+  * MSIdb are most often created on postgreSQL databases server and in the ''Advanced'' tab, choose ''public'' as schema
-**Note** : MSIdb are most often created on postgresql databases server and in advance tab, choose ''public'' as schema
+{{:connect.png|}}

hEIDI

User Tools

Site Tools

Differences

Page Tools