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.
Important! In ABBYY FlexiCapture Release 4 Update 2, PostgreSQL is enabled by default. To be able to work with PostgreSQL databases in earlier versions of ABBYY FlexiCapture, you will need to enable PostgreSQL first.
To create a new database:
- On the computer where the Application Server is installed, install
Microsoft SQL Server Native Client 2012 or later
Oracle Data Access Components (ODAC) of the same bitness with the Application Server
psqlODBC version 11 or later.
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 2016 SP2 or later or Microsoft SQL Management Studio 2016 SP2 or later installed.
- On the computer where the Application Server is installed, open the Administration and Monitoring Console and click Service → Application Server to open the page https://<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:
- Click the Create New Database button.
- The database creation page will open:
Database creation page (ORACLE):
Database creation page (MS SQL):
Database creation page (Azure):
Database creation page (PostgreSQL):
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 Microsoft SQL Server, Azure or PostgreSQL. Note the limitations imposed by Microsoft SQL Server on database names (see this Microsoft website for details)
- A user account that has the necessary permissions for Microsoft SQL Server, Azure, Oracle or PostgreSQL.
- 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:
Permissions required for creating and configuring a Microsoft SQL database
Privileges required for working with an Oracle database
Privileges required for working with a PostgreSQL database
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 (https://<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.
- 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.