Dynamic AI connects to databases through the definition of a connection made within Dynamic AI administration.
A connection represents a logical ID, which is the basis for all data-bound reports, listings and forms in Dynamic AI.
The connection definition is read in real-time whenever a data-bound Report is executed in Dynamic AI. Being real-time resolved, the connection ID definition can be freely enhanced / combined with e.g. user @alias variables.
Dynamic AI can connect to a number of different database providers such as Oracle, IBM DB2, Microsoft SQL Server, Sybase, Informix, various ODBC data sources and file based databases such as Microsoft Access.
The connection ID is a unique ID and is stored (by reference) as part of the following Dynamic AI elements:
· Dictionary definitions
· Relationship definitions
· Dynamic Views
· Reports
Whenever these elements needs a connection to the data-source defined by the connection ID, Dynamic AI will resolve the settings specified in Connection Maintenance for that specific ID. Changing or deleting a connection will have direct impact on these elements.
E.g.: a wrong username and password specified on a database connection will make it impossible for a Report to connect to underlying data and the Report will therefore raise an error.