Skip to main content
Instead of creating a new database, the administrator may need to connect to an existing database (for example, if the connection settings have been changed).
For databases created in earlier versions of ABBYY FlexiCapture, see Update databases and projects created in ABBYY FlexiCapture Distributed.
  • 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.
  • In the case of a PostgreSQL database, the fc schema and all its objects must be owned by the user account that the Application Server uses to work with the database.
To connect to an existing database:
1

Open the Application Server settings

On the computer where the Application Server is installed, open the Administration and Monitoring Console under the Windows administrator account and click Settings → 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).If the Application Server is already connected to a database, start at step 4.
2

Start a new connection

Click Connect to Existing Database.
3

Enter the connection details

In the form that opens, complete the following fields: the name of the Microsoft SQL Server, Oracle, Azure, or PostgreSQL instance; the name of the existing database (for Oracle, Azure, or PostgreSQL); the user that administers the database server; and the path to the file storage (if any).
4

Test the connection

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

Upgrade the database if prompted

Your server is now connected to the database. If an Upgrade link is displayed on the Settings → Application Server page next to the database version, upgrade the database before you proceed (see Upgrade a database).
6

Note the temporary password

If ABBYY FlexiCapture authentication has never been used for this database, the user under whose account the Administration and Monitoring Console is running is issued the temporary password password.

Upgrade a database

When upgrading a database, you may need to change its structure. To change the database structure, use the script provided with the upgrade. To execute the script, click Apply Upgrade and provide the path to the script.