Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.gru
	1	+XWiki.nlo

Content

...	...	@@ -2,13 +2,14 @@
2	2
3	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	4
5		-{{figure image="db-verbindung-en.png" width="300"}}
6		-Creating an DB connection in {{formcycle case="dat"/}}
	5	+{{id name="fig_data_db_con"/}}
	6	+{{figure image="data_db_con_en.png"}}
	7	+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.
7	7	{{/figure}}
8	8
9	9	== Create database connection ==
10	10
11		-* Open the module "DB-connections" and click on the button "New".
	12	+* 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"]]).
12	12	* Allocate a various alias and an optional description.
13	13	* For the data base connection itself, the following data is necessary:
14	14	** **Name**: Name of the database, which needs to be connected.
...	...	@@ -15,7 +15,7 @@
15	15	** **Description**: Description of the database-connection
16	16	** **Type:** Type of the database. At the time Oracle® MySQL, Oracle® Database, PostgreSQL, Microsoft® SQL Server and "Other (JDBC)" are available.
17	17	** **JDBC URL**: The JDBC URL of the database-server
18		-** **JDBC driver**:The name of the JDBC driver if the type is "Other (JDBC)". This value can automatically be set with the button "Determine", othweise please refer [[Database configuration>>doc:Datenbankkonfiguration||rel="__blank"]].
	19	+** **JDBC driver**:The name of the JDBC driver if the type is "Other (JDBC)". This value can automatically be set with the button "Determine", othweise please refer [[Database configuration>>doc:Formcycle.SystemSettings.DatabaseConfiguration||rel="__blank"]]
19	19	** **Username**: Username of the database user.
20	20	** **Password**: Password of the data base user.
21	21	** **Number of connections at once**: Number of connections to the data base at once. On a great many of accesses to this connection, the value should be > 10. Notice here the utilization of the database server if necessary and accommodate the settings correspondingly. Normally the default setting 10 should be enough. Confirm the information with the button "Save".
...	...	@@ -33,4 +33,4 @@
33	33
34	34	== Delete database connections ==
35	35
36		-A DB-connection can only be deleted, if it is not referenced by an action/data source anymore.
	37	+A DB-connection can only be deleted {{ficon name="trash-alt2"/}}, if it is not referenced by an action or data source anymore.