... |
... |
@@ -1,22 +1,11 @@ |
1 |
1 |
{{content/}} |
2 |
2 |
|
3 |
|
-Database connections pose a possibility to record data connections to different data bases, apart from location and type, centrally. You can access deposited file connections later comfortably, for example in ""actions" (data base) or "[[DB querys>>doc:DBQueries]]", without all users having to know the access information. |
4 |
|
- |
5 |
5 |
{{id name="fig_data_db_con"/}} |
6 |
|
-{{figure image="data_db_con_en.png"}}Creating a DB connection in {{formcycle case="dat"/}}. (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.{{/figure}} |
7 |
7 |
|
|
5 |
+{{figure image="data_db_con_en.png" clear="h1"}}Creating a DB connection in {{formcycle case="dat"/}}. (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.{{/figure}} |
8 |
8 |
|
9 |
|
-{{html wiki="true"}} |
10 |
|
-<div class='xm-figure xm-float-right xm-clear-global' data-alt='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'><div class='xm-figure-inner' style='width:310px'>{{lightbox image='data_db_con_en.png' width='300' group='$height' group='$group' title='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'/}}<div class='xm-figure-caption'>Creating a DB connection in {{formcycle case="dat"/}}. (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.</div></div></div> |
11 |
|
-{{/html}} |
|
7 |
+Database connections pose a possibility to record data connections to different data bases, apart from location and type, centrally. You can access deposited file connections later comfortably, for example in ""actions" (data base) or "[[DB querys>>doc:DBQueries]]", without all users having to know the access information. |
12 |
12 |
|
13 |
|
- |
14 |
|
- |
15 |
|
-{{html wiki="true"}} |
16 |
|
-<div class='xm-figure xm-float-right xm-clear-global' data-alt='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'><div class='xm-figure-inner' style='width:310px'>{{lightbox image='data_db_con_en.png' width='300' group='$height' group='$group' title='Creating a DB connection in . (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.'/}}<div class='xm-figure-caption'>Creating a DB connection in {{formcycle case="dat"/}}. (1) To the left is a list of existing database connections. (2) On the right users can configure the selected database connection.</div></div></div> |
17 |
|
-{{/html}} |
18 |
|
- |
19 |
|
- |
20 |
20 |
== Create database connection == |
21 |
21 |
|
22 |
22 |
* Open the module "DB-connections" and click on the button "New" {{ficon name="plus-circle-outline"/}} in the header of the list (see [[figure>>||anchor="fig_data_db_con"]]). |
... |
... |
@@ -25,6 +25,7 @@ |
25 |
25 |
** **Name**: Name for this database connection. |
26 |
26 |
** **Description**: Description of the database connection |
27 |
27 |
** **Type:** Type of the database management system. Currently we support Oracle® MySQL, Oracle® Database, PostgreSQL, Microsoft® SQL Server and "Other (JDBC)". |
|
17 |
+{{version major="7" minor="0" patch="10"}}{{/version}} The H2 database driver is no longer supplied by {{formcycle/}} since version 7.0.10 and has to be installed manually like the drivers of the other database types. |
28 |
28 |
** **JDBC URL**: The JDBC URL of the database server |
29 |
29 |
** **JDBC driver**:The name of the JDBC driver if the type is //Other (JDBC)//. This value can automatically be set with the button "Determine", otherwise please refer to [[database drivers>>doc:Formcycle.SystemSettings.DatabaseDrivers||rel="__blank"]] |
30 |
30 |
** **Username**: Username of the database user. |