Database connections

Last modified by superadmin on 24.01.2017

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 "sources", without all users having to know the access information.

Create database connection

  • Open the module "DB-connections" and click on the button "New".
  • Allocate a various alias and an optional description.
  • For the data base connection itself, the following data is necessary:
    • Type: Type of the database. At the time H2 server, MYSQL, Oracle, PostgeSQL and the MS SQL server are available.
    • Server: Name or IP address of the database server.
    • Port: Communication port of the database. This entry is predefined at the choice of the database type and must only be adjusted at divergented settings.
    • Name: Name of the database, which needs to be connected.
    • Username: Username of the database user.
    • Password: Password of the data base user.
    • 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".
  • After creating the DB-coonection, it appears in the left part (list) of the connections.

Before saving you have the opportunity to test the inserted data. The button "Tect connection" checks, if a connection was set up successfully. If no connection was set up, an error message is displayed. Then maybe approach the concerned administrator.

upload and execute script data

Via the button "Upload SQL file and execute" you can upload an SQL file, which is executed directly after uploading.

Delete database connections

A DB-connection can only be deleted, if it is not referenced by an action/data source anymore.

Tags:
Created by superadmin on 02.06.2015
Translated into en by superadmin on 22.07.2016
  
Copyright 2000-2016