Relational databases

A relational database is an organized collection of tables and views that contain related data. Data can be accessed searched in many different ways without any changes needed to the database tables.

Most relational databases use a structured query language (SQL) to search and gather information from the data stored in the database.

Kofax Transformation Modules supports the following relational databases:

  • Microsoft SQL Server

  • ODBC connected databases

  • Oracle

Important If you are using an Oracle database,set up access rights for Kofax Transformation Modules. You also need to install the Oracle .NET driver, and then restart your server. Kofax Transformation Modules does not support using an Oracle database with an Oracle 11g, 12c, or 18c client.

To manage relational databases: