Relational databases
A relational database is an organized collection of tables and views that contain related data. Data can be accessed and 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 TotalAgility supports the following relational databases:
-
Microsoft SQL Server
-
ODBC connected databases
-
Oracle
If you are using an Oracle database,set up access rights for Kofax TotalAgility. You also need to install the Oracle .NET driver, and then restart your server. Kofax TotalAgility does not support using an Oracle database with an Oracle 11g or 12c client.
To manage relational databases:
-
Create a connection to a relational database
-
Configure the connection:
-
Configure a Microsoft SQL Server connection.
-
Configure an ODBC connection.
-
Configure an Oracle connection.
-
Set up authentication for the relational database connection.
-