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
fcschema and all its objects must be owned by the user account that the Application Server uses to work with the 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.