SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

Login with Google
FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!
QUESTIONS? CALL: 865-637-8986
  • LOGIN

SimpleIndex

  • LEARN MORE
    • GENERAL INFO
      • Getting Started
      • How To Scan Documents
      • Barcode Scanning Guide
      • Searching & Viewing
      • Sunshine Software
      • News & Updates
      • Schedule a Consultation
    • FEATURES
      • Streamlined Interface
      • Automated & 1-Click Processing
      • TWAIN and ISIS Scanning
      • Zone OCR and Dynamic OCR
      • Handwriting Recognition Software
      • Amazon Textract OCR and ICR
      • Screenshot OCR
      • Document Classification
      • Database Integration
    • –
      • PDF & MS Office Text Parsing
      • Email Document Processing
      • Barcode Recognition
      • Optical Mark Recognition
      • Match Documents to Existing Data
      • Required Documents Check
      • Imprinting & Watermarking
      • SharePoint Document Scanning
      • AI and SimpleIndex
  • SOLUTIONS
    • General
      • All-In-One Scanning & Sorting Tool
      • Affordable Document Management
      • Instant Integration
      • Network Scanners & Copiers
      • Remote Document Capture
      • Reduce Click Charges for Data Capture
      • Compare with Other Solutions
    • Feature Demos
      • Zone OCR with Template Matching
      • PDF Text Processing
      • Organize Office Documents
      • Automatic Image Splitting
      • Amazon Textract OCR and ICR
      • Full-Page OCR & Multi-User Workflow
      • PDF Form Filling with XML & RPA
      • AP to QuickBooks Online with RPA
      • CRM Integration with RPA
    • Marketplace
      • Sales Tax Exemption Forms OCR
      • Invoice Processing
      • Automatic Web Image Optimization
      • Material Safety Data Sheets (MSDS) Indexing
      • Patent ID and Title Extraction OCR
      • Federal Tax Returns
      • Mortgage & Loan Documents
  • SUITE
    • SimpleCoversheet – Print Bar Codes
    • SimpleExport – Data File Converter
    • SimpleView – Search, View & Edit
    • SimpleQB – QuickBooks Integrator
    • SimpleOCR – Freeware OCR
    • Buy Suite Apps
  • DOWNLOAD
  • SHOP
    • COMPARE VERSIONS
    • SIMPLEINDEX
      • Workstation License
      • Concurrent License
      • Subscription License
    • SIMPLEINDEX SERVER
    • SOLUTIONS
      • LoanStacker
      • Material Safety Data Sheets (MSDS) Indexing OCR
      • Patent ID and Title Extraction OCR
      • Sales Tax Exemption Forms OCR
      • SimpleInvoice
      • TaxStacker Add-on for SimpleIndex
    • ADDONS AND EXPANSIONS
    • MAINTENANCE & CONSULTING
    • MANAGE SUBSCRIPTIONS
    • FIND A DEALER
      • Dealer Locator
      • Become a Dealer
    • CONTACT SALES
  • SUPPORT
    • WIKI HELP
    • KNOWLEDGE BASE
    • SIMPLEINDEX UNIVERSITY
    • PRIVACY POLICY
    • CONTACT SUPPORT
    • NEWSLETTER
    • SCHEDULE A CONSULTATION
  • My Account
    • MANAGE SUBSCRIPTIONS
    • Downloads
    • Register Account
    • Login
  • MY CART
    No products in cart.
  • Home
  • Posts tagged "Database"

Data is essential in every sector of business. Not matter the field, companies rely on data accumulation and management day in and day out. When compiled, each piece of input provides companies with comprehensive databases of fundamental information that can be processed, stored, manipulated, and analyzed. Databases act as crucial repositories of information that often encompass vast sets of data. Given the mere amount of input involved, data accumulation and management can be a tedious and overwhelming task, especially when involving manual data entry, intricate spreadsheets, copious archives of documents, and clunky software.

While there are plenty of database solutions for processing and storing sets of data, such as SQL (MySQL, Access, Postgres, etc.) and NoSQL (Mongo, AWS, etc.), issues commonly arise during the processes of identifying and transferring data from raw unprocessed texts and images. Overall, data recognition and collation can be an incredibly tedious task in which small errors resulting from misreading and mismatching of input can disrupt entire database processes and outputs. Thus, the key to successful data management lies in the precision of character recognition and classification. With this in mind, we’ve tailored our solution to rigorously identify and meticulously catalog great amounts of data with accuracy in order to save you time, money, and headaches!

SimpleIndex provides an Unprecedented Control of Database Interactions

Open database integration is a powerful feature of SimpleIndex® and one that furthers its interoperability with custom programs. Instead of using a proprietary database, SimpleIndex allows you to map its index fields to cells in any database table. It can be configured to create new records, update existing ones or retrieve them for viewing. Using these three basic database functions, SimpleIndex is able to interface with and operate on any database.

SimpleIndex 11 – More Than “Just an Update”

Friday, 03 October 2025 by Simple Software
We almost switched to Roman Numerals, it’s that big of a deal The most significant update in years, SimpleIndex 11 introduces major new features like handwriting recognition and email processing, while optimizing existing features to dramatically improve processing speeds for large batches and files. Some more major new features are: Get the full list of new features and fixes on the SimpleIndex Wiki.
1-Click ProcessingAutomatic Indexing SoftwareDatabaseDocument AutomationFile IndexingInvoice OCROCROCR Form Processingon-prem OCRScanning SoftwareServer OCRUnattended ProcessingZone OCR
Read more
  • Published in Newsletter
No Comments

SimpleIndex 11.4 Release Notes

Friday, 05 September 2025 by Simple Software
SimpleIndex 11.4 new version, adds major new features like an easy option to customize what emails need to be processed from email boxes by setting dates and subfolders and automatically updating them each time these emails are processed. Additionally, ChatGPT integration was added. This allows you to extract index values and text from any document
1-Click ProcessingAutomatic Indexing SoftwareDatabaseDocument AutomationFile IndexingInvoice OCROCROCR Form Processingon-prem OCRScanning SoftwareServer OCRUnattended ProcessingZone OCR
Read more
  • Published in Release Notes
No Comments

AI and SimpleIndex

Friday, 02 May 2025 by Simple Software
When it comes to automating the document processing workflow, it is impossible to avoid the question of AI. It is very hard to do anything nowadays without some use of AI-powered tools. Recent studies have shown that at least 40% of the average workday will soon be done by AI. AI is involved with OCR
1-Click ProcessingBar Code ScanningCommand-LineDatabaseDocument AutomationDocument Capture SolutionDocument ImagingDocument Management SoftwareImprintingImprinting & WatermarkingMS OfficeOCROffice PDF Text Processingoffline OCRon-prem OCRon-site OCROne-time payment OCRPDF BookmarkingRPAScanning SoftwareSelf-hosted OCRSubscription free OCRSunshine OCRTWAINTWAIN & ISIS Scanning
Read more
No Comments

Reduce Click Charges for Data Capture

Monday, 14 November 2022 by Simple Software
If you operate a high-volume scanning department or service bureau, chances are you use software like Kofax to scan and index documents for your clients. If you do then you are well aware of the high cost of click charges and the inevitable mad rushes to purchase additional clicks at the end of a peak
1-Click ProcessingAutomatic Data CaptureDatabaseDocument ClassificationDocument Imagingoffline OCRon-prem OCRon-site OCROne-time payment OCRSelf-hosted OCRSubscription free OCRSunshine OCRTWAIN & ISIS ScanningWorkflow
Read more
No Comments

Instant Integration With Any Application

Monday, 14 November 2022 by Simple Software
SimpleIndex® provides a great alternative to “reinventing the wheel” using a document imaging SDK to implement scanning in your custom application. SimpleIndex uses a command line interface to enable developers to execute customized scanning workflows from another application. This lets you take advantage of SimpleIndex‘s TWAIN/ISIS scanning, zone OCR, barcode recognition and database export features
1-Click ProcessingBar Code ScanningCommand Line InterfaceDatabaseDocument AutomationDocument ImagingFront End ScanningOCROffice PDF Document IndexingRPATWAIN & ISIS Scanning
Read more
No Comments

Automated Processing & 1-Click Interface

Monday, 14 November 2022 by Simple Software
SimpleIndex® 1-click scanning and indexing is enabled with its command line interface. SimpleIndex job files can be saved and opened just like a Word document. When you open a job file, SimpleIndex begins processing a new batch automatically. Scanning, processing (OCR, barcodes, database autofill, etc) and export happen in sequence with no further input from
1-Click ProcessingCommand Line InterfaceCommand-LineDatabaseDocument Automationon-prem OCRon-site OCRSunshine Software OCRUnattendedUnattended ProcessingWorkflow Software
Read more
No Comments

Database Integration

Monday, 07 November 2022 by Simple Software
Unprecedented Control of Database Interactions Open database integration is a powerful feature of SimpleIndex® that furthers interoperability with custom programs. Instead of using a proprietary database, SimpleIndex allows you to map index fields to cells in any database table. It can be configured to create new records, update existing ones, or retrieve them for viewing.
CSVDatabaseDatabase AutofillDocument AutomationDocument Management SoftwareDocument RetrievalFile IndexingMS AccessODBCon-prem OCRon-site OCROracleServer OCRSharePoint ScanningSQL ServerSunshine Software OCRWorkflowWorkflow SoftwareXSLT
Read more
No Comments

Using alternate database schemas

Monday, 29 July 2019 by Simple Software
Please refer to the Wiki Documentation for the complete Database reference. In SQL Server, Oracle and MySQL (among others) user logons are associated with a default “schema” that determines which tables and views they can see. Users may have access to other tables and views that aren’t in their schema. When connecting to the database these tables will show up in the
DatabaseDatabase AutofillDocument RetrievalMS AccessMySQLODBCOracleSQL ServerWorkflow Software
Read more
No Comments

Access Database Connection String

Monday, 29 July 2019 by Simple Software
Please refer to the Wiki Documentation for the complete Access reference. If you would like to create a database string for an Access database that includes a password use this format: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path\database.mdb;Jet OLEDB:Database Password=db_password;
DatabaseDatabase AutofillDocument RetrievalMS AccessODBC
Read more
No Comments

How do I delete an image and it’s database entry?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Global Settings Wizard  reference. If your Job Settings Wizard configuration’s of Database mode setting is set to “Update Existing Records”, the database record and the image will be deleted when you delete an image from a batch. The Table Name must be an updateable query or table
DatabaseDocument RetrievalMS AccessMySQLODBCOracleSearchServer OCRSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval
No Comments

How do I use the Media Wizard to create searchable DVDs or thumb drives?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Send Menu reference. To enable the Media Wizard, you must first create a job configuration that exports index information to an Access database. Once you have scanned all the documents for the CD or DVD and attached them to the database, create a second job that uses “Retrieve
DatabaseDocument ManagmentDocument RetrievalExport
Read more
  • Published in Database & Retrieval, Export
No Comments

How do I export index data to a database?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Export reference. There are a variety of ways to connect to your database. Detailed instructions are provided in the Manual (check the Help menu). Here is a brief overview of the steps involved: -Create a job configuration to scan and index files -On the database tab, set the
CSVDatabaseDocument Capture SolutionDocument RetrievalMS AccessMySQLODBCOracleServer OCRSharePoint ScanningSQL ServerWorkflowWorkflow SoftwareXMLXSLT
Read more
  • Published in Database & Retrieval, Export
No Comments

How do i setup Simpleindex to use a Database table field as a list file when the table is not the same as the table i am using on the Database Tab.

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Database reference. All you will need to do is put the table and field name you want to pull from in the Dictionary Matching & List Fields Box. It should be formatted just like the example below. Example: Table Name|Field Name
Automatic Indexing SoftwareDatabaseDatabase Autofill
Read more
  • Published in Licensing & Installation
No Comments

Is it possible to have the scanned image itself added to a database and not just the image path?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Database reference. Yes. Image files can be inserted into binary fields in Access, SQL Server, Oracle, MySQL and other databases. Check the “Store files as binary objects” option on the Database tab and the “Output File Field” setting can be mapped to a binary field. If using PDF,
DatabaseDocument RetrievalMS AccessMySQLODBCOracleSharePoint ScanningSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval, Export
No Comments

When exporting to a database, I get the error “Multi-step operation generated errors”

Wednesday, 28 February 2018 by dwilder
or a text value that is longer than the maximum length of the f
DatabaseDocument RetrievalMS AccessMySQLODBCOracleSQL Server
Read more
  • Published in Database & Retrieval
No Comments

How do you configure a field to select from a list of possible values?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Index & Batch Logging reference. List fields are populated using a text file or database field containing the values for that list. The text file scenario will be described first. To configure a list field, go to the Index tab in the Job Options. Create a list field
Automatic Indexing SoftwareCSVDatabaseDatabase AutofillDocument AutomationDocument RetrievalFile IndexingKeyword IndexingMetadataMS AccessMySQLODBCOffice PDF Document IndexingOracleScanned Document IndexingServer OCRSharePoint ScanningSQL ServerWorkflowWorkflow Software
Read more
  • Published in Indexing & UI
No Comments

Is it possible to restrict user access to certain documents in Retrieval Mode?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Database Mode reference. If the database you use to store index information has security access features, you can use these to manage access to documents with SimpleIndex retrieval mode. In your database, create user accounts and groups and assign them the appropriate permissions to records in your document
DatabaseDocument Management SoftwareDocument RetrievalMS AccessMySQLODBCOraclePaperless OfficeServer OCRSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval
No Comments

How do you configure full text searching in Retrieval mode?

Wednesday, 28 February 2018 by dwilder
Please refer to the Wiki Documentation for the complete Database Settings reference. On the Database tab there dropdown in the lower portion of the panel for Full Text OCR Field. Put the name of the field that will store the full-text data there. This must be configured both for Insert and Retrieval mode configurations. The database field
DatabaseDocument Management SoftwareDocument RetrievalFile IndexingFull Text IndexingMS AccessMySQLOCROCR Form ProcessingOCR ScanningODBCOffice PDF Text ProcessingOraclePaperless OfficePDF Archive Scanning SoftwarePDF Data Extraction SoftwareQuickBooks Document ManagementSearchServer OCRSharePoint ScanningSQL ServerText ProcessingUnattended ProcessingWorkflow SoftwareZone OCR
Read more
  • Published in Database & Retrieval, OCR
No Comments

What is “Match & Attach” mode?

Wednesday, 28 February 2018 by dwilder
if you have a large backfile of documents that you want to scan and link to records in an existing database
DatabaseDatabase AutofillDocument AutomationDocument RetrievalMS AccessMySQLODBCOracleServer OCRSQL ServerWorkflow
Read more
  • Published in Database & Retrieval, Export
No Comments

How do you configure the Autofill feature?

Wednesday, 28 February 2018 by dwilder
The Autofill feature of SimpleIndex is an easy way to associate many index fields with one document without retyping data that already exists in another application. Autofill uses a database lookup to retrieve records that match a key value or values entered by the user or extracted with SimpleIndex. Blank index fields are then filled
DatabaseDatabase AutofillDocument AutomationDocument RetrievalMS AccessMySQLODBCOracleServer OCRSQL ServerWorkflow
Read more
  • Published in Database & Retrieval, Indexing & UI
No Comments
  • 1
  • 2

Search

Connect with Us!

What is 7+4?


Search Knowledge Base

Recent KB Articles

  • SimpleIndex Tips & Tricks - Document Separation
  • SimpleExport - Index Output Converter
  • SimpleIndex OCR Workstation
  • SimpleIndex Standard Server 1M
  • Compare SimpleIndex
  • SimpleIndex Tips & Tricks Handprint Recognition
  • SimpleIndex Walkthrough
  • How much do Simple Software products cost?

Feature Cloud

Batch Scanning Checkbox Recognition Automatic Indexing Software Barcode Recognition Software Bar Code Printing Barcode OCR Automatic Data Capture Archive Email to PDF Business Process Automation 1-Click Processing Barcode Reading Software Bar Code Scanning Automatic PDF Separation a generic barcode coversheet can be used to separate the scanned images into multi-page files 2 of 5 Bates Numbering Software accessability Aztec and QR Code</li> <li>Recognize 30 different 1D barcode formatsCode 39 Barcode Printing Bar Codes

Online Support Options

Check our Wiki Help, Knowledge Base and Training Videos, or Contact Support if you still need Help

How to Buy

Solutions start at just $500! Buy SimpleIndex online or from an Authorized Dealer in your area.

Authorized Dealers

Authorized DealersSimpleIndex is a great addition to any system integrator's product line. Become an Authorized Dealer.

Get a Web Demo

Get a free online demo with a scanning specialist who can configure SimpleIndex on your computer remotely.
Sign up for a demo now!

Download a Trial

SimpleIndex Trial30-day trial downloads are available for all Simple Software applications.
Download Now!

SimpleIndex Applications

SimpleIndex Applications Packaged apps built with SimpleIndex.
SimpleInvoice for AP
Sales Tax Manager
Mortgage LoanStacker
MSDS and Patents
SimpleIndex

© 2025 Meta Enterprises, LLC | Knoxville, Tennessee | A Family Owned Company
© 2025 SimpleSoftware | Consulting Services in the Field of Software as a Service

TOP
SimpleIndex
Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional cookies Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
View preferences
  • {title}
  • {title}
  • {title}
});