KTA - Support for IBM DB2 Databases for Data Access
Article # 3045864 - Page views: 50
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
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
KTA | All |
References
Article # 3045864