Export to a database

1. In the Document Definition editor window select the menu item Document Definition → Export Settings…
2. Click Add… and select Export to ODBC-compatible database in the Type field.
3. Specify whether export is obligatory.
4. Specify whether images should be exported.
5. Specify which documents (with and/or without errors) should be exported and click Next>.
6. Specify export settings and click Next>.
   • Establish a connection with a database. Enter the connection parameters in the Connection string window or click the Setup… button and configure the connection parameters in the Data Link Properties dialog box.

1. Provider - OLE DB Provider for ODBC Drivers
   Note: Selecting “OLE DB Provider for SQL Server” may cause problems when working with certain data types and long fields.
2. Driver - SQL Server

1. Provider - OLE DB Provider for ODBC Drivers
2. Driver - Microsoft Access Driver (Driver do Microsoft Access or Microsoft Access-Treiber)
   Note: To connect the 64-bit version of FlexiCapture to the Access database, you will need to install the 64-bit version of the Access Database Engine x64 driver.

1. Provider - Oracle Provider for OLE DB
2. Selecting the driver is not required
   For details see Exporting to an Oracle database.

1. Provider - OLE DB Provider for ODBC Drivers
2. Selecting the driver is not required

• Select a schema from the drop-down list.

• You can check the connection with the database by clicking the Test Connection button.
• Click the Create Tables Automatically button to automatically create new tables in the database, where data from documents will be exported. A separate table will be created for each document section. The structure and the format of fields in automatically created tables correspond to the set of Document Definition fields and their data types.
  Note: Before the export, ABBYY FlexiCapture queries the database for information about all objects of the schema. It is recommended that schemas with a small number of objects should be used for export. Otherwise creating tables can take considerable time (up to several hours).
• If it is necessary to export data to existing tables of a database, establish a correspondence between the Document Definition fields and the database table fields using the Set Up Field Mapping… button.
• In the Field Mapping dialog box specify to what tables and table columns of the database the program will export field values of the Document Definition.

1. If images should be saved (document images and/or field images of the Picture type), specify image saving options and click Next>.
   • Specify whether images should be saved to the database or as files.
   • If you choose to save images to files, specify a file naming template (click Edit…) and when files should be overwrite if their names coincide. For more information, see Export file naming options.
   • If required, specify the fields to be concealed upon export.

1. If the option to save images was selected, specify a file saving format and click Next>.
   • Select the desired image format, quality, and color.
   • To change the resolution of the source images, select Change resolution to and select the appropriate value from the list.
   • If you select PDF or PDF/A as a storage format, you can create searchable PDF files.
2. Enter an export profile name and click Finish.
3. Pictures are exported to separate files. The name and path to the picture file can be stored in the corresponding field of the database (this can be set up when mapping fields).
4. If the path to the target folder for images, pictures, etc. contains a network disk, ensure that all the processing stations working with the project have access to this disk.

​

Specifics of configuring data export by using stored procedures of databases

• Speed of working with a database
• Possibility to use additional calculations
• Ensuring data integrity

Create procedure Export( @userId as int, @lastName as nvarchar(255), @firstName as nvarchar(255) )
as
begin
  if Exists( Select Id from Users where Id = @userId ) begin
     Update Users set LastName = @lastName, FirstName=@firstName where Id = @userId
  end else begin
     Insert into Users ( Id, LastName, FirstName ) values( @userId, @lastName, @firstName
)
  end
end

• an identifier (UserId);
• the first name (FirstName);
• the last name (LastName).

​

Configuring export by using stored procedures

​

Exporting to an Oracle database

1. Role: Connect
2. Privileges:
   • CREATE ANY TABLE for creating a table
   • INSERT ANY TABLE and UNLIMITED TABLESPACE for exporting data