In the PROMOTIC system there are inbuilt the ODBC, DAO, SQL default interfaces for the access to external databases.
By means of the PmaAdo object (or PmaDatabase) the user has access to databases of several types, for example: dBase, Excel, Microsoft Access, PARADOX, FoxPro, MS SQL Server, MySQL, Oracle, etc.
These objects allow to perform both simple and complex database operations of the following types: read/write records, select, sort, etc.
The usage of the PmaAdo and PmaDatabase objects requires purchase of the "PmDB" licence. With the freeware version PmFree, or when developing the application (with development environment for tersting purposes), this component is always functional.