SIGN IN YOUR ACCOUNT TO HAVE ACCESS TO DIFFERENT FEATURES

Login with Google
CREATE AN ACCOUNT FORGOT YOUR PASSWORD?

FORGOT YOUR DETAILS?

AAH, WAIT, I REMEMBER NOW!

CREATE ACCOUNT

ALREADY HAVE AN ACCOUNT?

Login with Google

QUESTIONS? CALL: 865-637-8986
  • SIGN UP
  • LOGIN

SimpleIndex

  • LEARN MORE
    • GENERAL INFO
      • Getting Started
      • How To Scan Documents
      • Barcode Scanning Guide
      • Searching & Viewing
      • News & Updates
      • Schedule a Consultation
    • FEATURES
      • Streamlined Interface
      • TWAIN and ISIS Scanning
      • Zone OCR and Dynamic OCR
      • Database Integration
      • Required Documents Check
      • Automated Processing & 1-Click Interface
      • SharePoint Document Scanning
      • Convert Email to PDF
    • –
      • Document Classification
      • PDF & MS Office Text Parsing
      • Barcode Recognition
      • Handwriting Recognition Software
      • Optical Mark Recognition
      • Match Documents to Existing Data
      • Imprinting & Watermarking
      • Screenshot OCR
  • 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
    • Specific
      • Sales Tax Exemption Forms
      • Federal Tax Returns
      • Invoice Processing
      • Automatic Image Splitting
      • Material Safety Data Sheets (MSDS)
      • Patent ID and Title Extraction
      • Mortgage & Loan Documents
    • Feature Demos
      • Zone OCR with Template Matching
      • PDF Text Processing
      • Organize Office Documents
      • AP to QuickBooks Online with RPA
      • PDF Form Filling with XML & RPA
      • Full-Page OCR & Multi-User Workflow
      • CRM Integration with RPA
  • SUITE
    • SimpleCoversheet – Print Bar Codes
    • SimpleExport – Data File Converter
    • SimpleView – Search, View & Edit
    • SimpleQB – QuickBooks Integrator
    • SimpleOCR – Freeware OCR
    • Buy Suite Apps
    • Buy Suite Bundles
  • DOWNLOAD
  • SHOP
    • COMPARE VERSIONS
    • SIMPLEINDEX WORKSTATION
      • Machine License
      • Concurrent User
      • Subscription License
    • SIMPLEINDEX SERVER
    • SUITE APPLICATIONS
    • SUITE BUNDLES
    • MAINTENANCE & RENEWALS
    • MANAGE SUBSCRIPTIONS
    • FIND A DEALER
      • Dealer Locator
      • Become a Dealer
    • CONTACT SALES
  • SUPPORT
    • WIKI HELP
    • KNOWLEDGE BASE
    • SIMPLEINDEX UNIVERSITY
      • SimpleIndex University – 100 Series
      • SimpleIndex University – 200 Series
      • SimpleIndex University – 300 Series
    • PRIVACY POLICY
    • CONTACT SUPPORT
  • My Account
    • MANAGE SUBSCRIPTIONS
    • Downloads
  • MY CART
    No products in cart.
  • Home
  • Database Integration

Database Integration


Unprecedented Control of Database Interactions

Open database integration can be configured to interface with and operate on any database.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. Using these three basic database functions, SimpleIndex is able to interface with and operate on any database.

Automatic Indexing Using Existing Data

Simple Index simplifies database processing by Indexing  & autofilling existing dataSimpleIndex's Autofill feature is an easy way to associate many index fields with one document without retyping data that already exists in another database. Autofill uses a database lookup to retrieve records that match key values entered by the user. Then blank index fields are automatically filled with the lookup data. After entering only one field, data autopopulates, resulting in a document database.

The key field may be typed by the user or read from the document automatically using barcode recognition or ocr. The lookup is performed either when the user changes this field or when the index values are saved. If the lookup finds multiple matching records, the user will be notified and the first set of values will be used by default.

When used with pre-index batches, key information can be read automatically from barcodes or OCR and matched to database records with a single click.

Custom Code Extensions for Autofill and Export

Custom Autofill and Export functions  extend functionality to use APIs and web services, allowing users to directly interface with any application to populate and export document data.Customized  Autofill and Export functions extend this functionality to use APIs and web services to populate or export index data when a direct database connection is not possible. This allows you to directly interface with any application to populate and export document data.

An example is our ChatGPT document analysis service, which uses the same extension interface to provide AI document analysis results that can be used for classification and natural language data extraction.

      

Match and Attach Mode

SimpleIndex features “Match and Attach” mode, which combines the power of the Autofill feature with the ability to update existing records in your database. This lets you “attach” images to existing database records by “matching” them with values from SimpleIndex.

xml and JSON Data Sources

SimpleIndex also has the ability to read data directly from XML and JSON files. Many document management and cloud storage platforms provide document metadata in XML and JSON files whenever you attempt to migrate data, along with corresponding files that may or may not have logical filenames. Use SimpleIndex to extract the data from these files, organize the documents, and migrate the metadata to a database or new document management platform.

Output to XML or Any Text Format

SimpleExport outputs to XML orany text file that is integratable with third-party databases

SimpleIndex offers direct export to pre-formatted XML files, as well as the SimpleExport module that can output any XML schema or text file format.

SimpleExport makes it possible to integrate with any third party database, application, or document management systems (DMS) that accept an XML or text file import.

SimpleExport converts the index values from a SimpleIndex job to any output format through XSL Transformations (xslt). You may use one of the built-in scripts to export to a pre-defined system or design your own. SimpleExport runs automatically after each batch is exported, or it can run as an unattended Windows service.

SimpleExport can also be used as a standalone application for automating xslt transformations, converting csv or TSV (delimited text files) to XML, converting images to base64, or integrating other scanning applications with third party software.

Find Out More

  • Download or get an Online Demo
  • Database wiki page
  • Autofill wiki page
  • SimpleExport wiki page

Scan, file, and process document data quickly and efficiently with Simple Software's tailored OCR automation and one-click processing that fits your unique business needs
Use SimpleIndex OCR to convert scanned and digital images to searchable PDF files for automated sorting, filing, and export to applications such as Word, Excel, PowerPoint, etc.
Automatically and accurately convert scanned and digital documents with simple and complicated tables to PDF files, Excel, Google Sheets, CVS, and other spreadsheet formats with Simple Software's advanced document management suite including Abbyy FineReader, Simple Index, SimpleView, SimpleSearch, SimpleSend, SimpleExport, SimpleCoversheet, and AI components
SimpleIndex OCR automation analyzes, classifies, verifies, and exports digital data into searchable documents that can be stored and processed in a variety of SQL applications
Simple Software's Document management OCR (Optical Character Recognition)  uses smart machine-learning and AI (artificial intelligence) methods to convert handwritten and digital text and image data into machine-readable text, allowing users to search, index, and organize large volumes of document data
Simultaneously recognize, analyze, and export large volumes of documents and digital data with SimpleIndex batch OCR (Optical Character Recognition) for processes  dealing with large volumes of documents, such as digitizing paper and scanned archives or processing document data in a document management system
SimpleIndex Server enterprise OCR lets users automatically perform optical character recognition on thousands of documents at a time, scaling to meet the demands of the large volumes of document conversions and processes tailored to the user's specifications
SimpleIndex OCR data capture technology and page layout analysis automatically identifies common invoice data elements (vendor, date, amount, invoice number, line item data, etc.) to automate data entry, eliminate errors, automate retrieval, match POs (Purchase Orders), validate quantities and prices, automate electronic document management and storage

KB Articles for Database Integration

  • Oracle database is slow to respond
  • What is Document Imaging?
  • Using alternate database schemas
  • Multiple Sort Fields on Search
  • Access Database Connection String
  • How do I delete an image and it's database entry?
  • Is it possible to search for and retrieve documents with Windows desktop search?
  • Will your SimpleQB allow me to scan in old invoices or bank statements directly into QuickBooks?
  • How do I use the Media Wizard to create searchable DVDs or thumb drives?
  • How do I export index data to a database?

Search

Contact Us Today!

=

Search Knowledge Base

Recent KB Articles

  • How to test if ISIS drivers work properly?
  • How to test if TWAIN drivers work properly?
  • How to test if TWAIN/ISIS drivers work properly?
  • How do I purchase, register and activate Simple Software products?
  • Clear Recent Jobs List
  • Why are my barcodes not being recognized properly?
  • How do I configure SimpleIndex to scan documents?
  • Can SimpleIndex create searchable PDF Image+Text files with hidden text?

Feature Cloud

Mortgage Document Imaging Patch Code Watermark Barcode Printing Convert Email to PDF MS Office Office to PDF MySQL PDF Bookmarking XSLT Automatic Indexing Software TWAIN Scanning Software Self-hosted OCR Scanned Document Indexing Fill PDF Forms Search XSLT Data Conversion Software SimpleView TWAIN & ISIS Scanning Business Process Automation Zone OCR Document Numbering System TIFF PDF Archive Scanning Software Distributed Scanning Database Autofill Office PDF Document Indexing Cloud Storage Migration Workflow Software Clipboard OCR Document Capture Solution SharePoint Migration RegEx OCR PDF Data Extraction Software Document Management Software RPA XML Microsoft Word Data Extraction Personal Document Management Front End Scanning Watermark PDF Files Solution Database

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

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

TOP
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}
});