... |
... |
@@ -1,20 +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"/}} |
|
4 |
+ |
6 |
6 |
{{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}} |
7 |
7 |
|
|
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. |
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}} |
12 |
|
- |
13 |
|
-{{html wiki="true"}} |
14 |
|
-<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> |
15 |
|
-{{/html}} |
16 |
|
- |
17 |
|
- |
18 |
18 |
== Create database connection == |
19 |
19 |
|
20 |
20 |
* 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"]]). |
... |
... |
@@ -23,6 +23,7 @@ |
23 |
23 |
** **Name**: Name for this database connection. |
24 |
24 |
** **Description**: Description of the database connection |
25 |
25 |
** **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. |
26 |
26 |
** **JDBC URL**: The JDBC URL of the database server |
27 |
27 |
** **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"]] |
28 |
28 |
** **Username**: Username of the database user. |