In the Connections category, the basic database connection for the operation of the INETAPP server is set first. Furthermore, the configuration of LDAP data sources for user matching as well as the addition of further database connections for asset and user import from an external databases is done here.
Note: For creating reports the data sources of the datasource manager are used.
The i-net HelpDesk server connects to its database via the universal database interface JDBC (Java Database Connectivity).
Separate drivers are required for each specific database. The following database drivers are included in INETAPP.
It is possible to specify your own database connection URL in advanced configuration mode, should additional parameters be required for the connection. However, only the above three database types are supported.
You should always test whether the settings you have made are valid. If the connection fails, please refer to the message text for the exact reason.
The connection to the HelpDesk database has the internal designation HDS (HelpDeskService). You can refer to the designation HDS as a data source in the data source selection for reports.
For automatic import and synchronization with an LDAP directory server, enter the connection data here. For access, you must specify an account that has at least read access to the LDAP directory. The connection to OpenLDAP or Microsoft AD servers is supported.
Domain
field is example
(without .local
). If the account is in a child domain, e.g. nord.example.local
, the entry is nord
, as the following applies in LDAP notation: dc=nord,dc=example,dc=local
.The LDAP connection configured here is used in the application Data import.
Note: Data is only read from the LDAP source. No data is written back to the LDAP.
cn=USERS,DC=company,DC=local
ou=berlin,DC=company,DC=local
ou=berlin,DC=company,DC=local;cn=USERS,DC=company,DC=local
Additional database connections for external sources can be configured. These are used in the following modules:
The database management systems (DBMS) supported are: MS SQL-Server, MySQL and Oracle, MS Excel as well as the database interface ODBC.
The drivers required to access a DBMS are already included in INETAPP. ODBC should only be set up if there are special reasons, e.g. access to MS Access or to a csv file.
For the aforementioned supported DBMSs, you should always use the JDBC driver supplied by i-net software, as it is much faster than ODBC.