Creating a database

First, you need to create a database.

Note: Depending on your setup, you may need to create a new database or connect to an existing database.

To create a new database:

  1. On the computer where the Application Server is installed, install Microsoft SQL Server Native Client 2012 or later or Oracle Data Access Components (ODAC) of the same bitness with the Application Server. If you attempt to create a database without Microsoft SQL Server Native Client, you will see this error message: "Provider cannot be found. It may not be properly installed."
    Note: You don't need to install Microsoft SQL Server Native Client if you have Microsoft SQL Server 2012 or later or Microsoft SQL Management Studio 2012 or later installed.
  2. On the computer where the Application Server is installed, open the Administration and Monitoring Console and click Service → Application Server to open the page http://<ApplicationServer>/FlexiCapture12/Monitoring/#Settings/DbConn (where <ApplicationServer> is the name of the computer on which the Application Server is installed) under the Windows administrator account:
  3. Click the Create New Database button.


  1. The database creation page will open:

Database creation page (ORACLE):

Database creation page (MS SQL):

Database creation page (Azure):

On this page, specify the following:

    • The name of the Server instance in the format <server name>\<instance name>
    • The name of the new database for Microsof SQL Server and Azure. Note the limitations imposed by Microsoft SQL Server on database names (see this Microsoft website for details)
    • A user account that has necessary permissions for Microsoft SQL Server, Azure or Oracle


    • Select the Use external file storage option and specify the path to the file storage. For details, see the Setting up a file storage section.The file storage stores binary data, such as images to be processed, project settings, captured data, etc. The speed of communication between the Application Server and the file storage  greatly affects the overall performance of ABBYY FlexiCapture. For this reason, we recommend placing the file storage on the same disk as the Application Server.


Important! A file storage can only be created when creating a database and cannot be created later while processing documents with ABBYY FlexiCapture. You also won't be able to disconnect the file storage you connected when creating the database.


You must add the file storage to the exceptions of your anti-virus software and the Windows search indexing service.

    • Use the Test Connection button to check the entered values. If the test is successful, click OK.


When creating a Microsoft SQL Server database, the following operations will be performed:

see details...

Permissions required for creating and configuring a Microsoft SQL database

Privileges required for working with an Oracle database

  1. Once the database is created, the user name and the temporary password password will be displayed.
    Important! The user will need to change the temporary password on the login page (http://<ApplicationServer>/FlexiCapture12/Login where <ApplicationServer> is the name of the computer on which the Application Server is installed). Once the temporary password is changed, the user will be redirected to the Administration and Monitoring Console.
  2. The user that creates the database automatically gets administrative privileges. The Administrator also has the permissions to change the settings of the Application Server, upload projects, grant access permissions for projects, create new users, and manage their roles and access permissions. The Administrator can grant the Administrator role to another user and delegate further configuration of the system to that user. The user that creates the database cannot be deprived of the Administrator role.

13.04.2021 11:12:26

Please leave your feedback about this article