KTA - Support for IBM DB2 Databases for Data Access

Issue

Errors are produced when trying to use Data Access Services (DAS) in Kofax TotalAgility (KTA) when trying to access an IBM DB2 database. An ODBC connection has been established.

Cause

Data Access Services in KTA only support SQL Server or Oracle databases. See the following note from the KTA Online Help.

Note: You can use DAS to connect to any database for which an OLE DB driver is available. However, the Data Access Service in TotalAgility only supports SQL Server and Oracle databases.

• Note: Data access activity does not support 'Always Encrypted' columns in SQL Server 2016 and above.

Solution

Use either a SQL Server or Oracle database for DAS functions.

Level of Complexity 

Moderate

Applies to  

References