Here you can manage data that is then available to you in the system. For example, you can use data as selection options from selection fields in the form or call it up via an HTTP request. The “data” module is divided into several sub-modules:
Database connections are a way for you to centrally maintain connection data to different databases. These database connections can then continue to be used in the system without you having to reconfigure the connection data and the database type each time.
For example, when creating a database query or in processing actions such as "DB query", you can access the connection data stored here.
Database queries behave similarly to data sources (XML, CSV, JSON), but are not stored statically, but are read dynamically from a database. SQL is used as the "query language". You must pay attention to the differences between the individual database types.
You also have the option of testing the database query immediately.
(Only with licensed LDAP module)
LDAP queries are similar to database queries. They are used to dynamically determine data from an LDAP server. In addition to filtering via an LDAP query, you can also restrict the return values to specified attributes. You also have the opportunity to test the LDAP query immediately.
Data sources are statically stored data. Data in CSV, JSON and XML format are supported. The import of Excel documents is also supported. You can define CSV data sources as selection options in a selection field in the Designer, for example. You can process JSON and XML data sources in the Designer via the script area.
FORMCYCLE OFFERS YOU MANY POSSIBILITIES, HERE ARE OTHER IMPORTANT FEATURES.