Database Export Connector

Export images and update corresponding index data to a database of choice

Export to Database 140x140The most straightforward way of image enabling a business process is by adding a reference to a scanned document to an existing database.  This could be a Microsoft SQL patient database, An Oracle 11g employee database, Sybase manufactured goods database or for a small business or department, it could be a customer or supplier MS-Access database. As long as you can connect to the database through an ODBC data source, it is possible to update your database with the CaptureBites™ Database export connector. You can also directly connect through an SQL Connection string witha Microsoft SQL Database and make use of BLOB fields to upload images.

Setup Screens

 

Database_Setup_Lookup

001 Connect through ODBC or directly to your SQL database.

002 Select the database table.

003 Always add records or lookup and update existing records via an index field

004 Store documents as TIF, PDF or PDF/A on a file server and configure folder structure and file naming as desired

005 Construct the folder and file structure by using fixed values, system values like date and time and Kofax Express index values.

Database_Setup_Mapping 

001 Store the document image path in a database field of choice.

002 Create direct hyperlinks to your PDF files in your Microsoft Access database. A single click on the link in the MS Access table will open the PDF file in the PDF viewer.

003 With a direct SQL connection, you can also store the TIF or PDF document files directly in a BLOB field.

004 Use Kofax Express fields containing multiple values. For example, a single document containing multiple bar code values can be used to update the database multiple times. Each value will generate a new record in the database pointing to the document image.

005 Map database fields with Kofax Express index fields.

Functionality

  • The first section defines the ODBC source to connect to your database. The trial download includes a demo job which connects to an Excel table through ODBC. But we also have installations using the connector with Oracle and MS SQL Databases.
  • Technically you can connect to any database for which you have an ODBC driver available.
  • We also provide the option to connect directly to an SQL database through a connection string.
  • After you click “Connect”, all tables in your database are listed and you need to select the table in the database which you want to update.
  • In the “Lookup information” tab, you define which field you want to use to retrieve the matching data record to be updated. This lookup field should be unique for each record in the database. If no matching record can be found, a record is automatically added.
    • If you do not want to lookup records but always want to add new records, then select from the Lookup Field drop down list. With this option enabled, every exported document will generate a new database record.

Export to Database No Lookup Setup

  • The “Image File” section defines the location where all document images will be exported to, the file type and naming convention. The Database connector supports PDF and PDF/A without or without searchable text or super compression.
  • The “Fields” section defines the mapping between your database and Kofax Express index fields. If you don’t want Kofax Express to update a particular database field, just don’t map it with anything.
  • The “Upload image” to a BLOB field is available when you connect directly to your MS SQL database with a connection string. This allows to store the PDF files directly in your MS SQL database.

Combine this product with CaptureBites MetaTool for advanced index extraction and more

Use this product in combination with CaptureBites MetaTool for advanced index extraction, keyword document separation, floating data extraction, multi-field and drill down database lookup and other advanced functionality.

To learn more about MetaTool, press any of the feature buttons below.

The MetaTool presents itself as a standard Kofax Express export connector and passes through extracted data and processed images to an export destination of choice such as EmailFolder StructureFTP ServerDatabaseMS SharePoint Server & OnlineAlfrescoOpenText Content ServerXerox DocuShare, or other DMS systems.

About the download and included demo jobs

The download button on top of this page installs a functional version of this CaptureBites product. It also includes some demo images and a demo job to show the functionality.

In demo mode, a demo seal will be stamped in all exported images. You can switch the demo version to full production mode by entering an activation code which you can purchase from our partners. You can continue using any of the jobs you configured in demo mode after activation of the software.