Database connection for automated document creation

How to link SmartDocuments templates
with databases ...
When using our smart templates, and when creating documents, there are different ways in which variable data can be incorporated into the template. In addition to the classic data capture via the SmartWizard or the integration of XML data from third-party applications, it is also possible to connect internal and external databases.
With the direct database connection, all data records are available to you within the SmartWizards when creating documents. This allows you to search specifically for relevant data, such as addresses, product information, or similar, without having to enter it manually. This not only reduces the time required for document creation but also minimizes the risk of errors.
Options
Internal databases
- SQL databases (e.g. MSSQL, Oracle, MySQL, PostgreSQL)
- Database types that have a JDBC driver
External databases
- Connecting web databases via API
And this is how it works
Tips & Tricks: Connecting internal databases
Tips & Tricks: Connecting external databases