The table below lists all the supported databases. While Altova endeavors to support other databases, successful connection and data processing have only been tested with the databases listed below. If your Altova application is a 64-bit version, ensure that you have access to the 64-bit database drivers needed for the specific database you are connecting to.
Firebird 2.x, 3.x
IBM DB2 8.x, 9.x, 10.x, 11.x
IBM Db2 for i 6.x, 7.4
Logical files are supported and shown as views.
IBM Informix 11.70 and later
MariaDB 10 and later
Microsoft Access 2003 and later
At the time of writing (early September 2019), there is no Microsoft Access Runtime available for Access 2019. You can connect to an Access 2019 database from Altova products only if Microsoft Access 2016 Runtime is installed and only if the database does not use the "Large Number" data type.
Microsoft Azure SQL Database
SQL Server 2016 codebase
Microsoft SQL Server 2005 and later
Microsoft SQL Server on Linux
MySQL 5 and later
Oracle 9i and later
PostgreSQL 8 and later
PostgreSQL connections are supported both as native connections and driver-based connections through interfaces (drivers) such as ODBC or JDBC. Native connections do not require any drivers.
Progress OpenEdge 11.6
SQLite connections are supported as native, direct connections to the SQLite database file. No separate drivers are required.
In Authentic view, data coming from a SQLite database is not editable. When you attempt to save SQLite data from the Authentic view, a message box will inform you of this known limitation.
Sybase ASE 15, 16