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 Web Demo
    • 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
    • –
      • Document Classification
      • PDF & MS Office Text Parsing
      • Barcode Recognition
      • 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
    • Specific
      • Sales Tax Exemption Forms
      • Federal Tax Returns
      • Invoice Processing
      • Material Safety Data Sheets (MSDS)
      • Patent ID and Title Extraction
      • Mortgage & Loan Documents
    • Feature Demos
      • Zone OCR with Template Matching
      • Full-Page OCR & Multi-User Workflow
      • PDF Text Processing
      • Organize Office Documents
      • Integration with RPA Bots
      • Compare with Other Solutions
  • 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
    • 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
    • Downloads
  • MY CART
    No products in cart.
  • Home
  • Simple Software Knowledge Base - Article

How do I connect to an SQL Server database?

Wednesday, 28 February 2018 by dwilder

SimpleIndex has the ability to export, query or autofill from an SQL database.  This allows you to upload data that is indexed with SimpleIndex to a table or view, search against the database or pull information from the database based on a key value.

Insert New Data

  1. Open the Job Settings Wizard and go to the Database step
  2. Set the Database Mode to Insert New Records
  3. Click the “New Data  Source…: button
  4. Select the SQL Database radio button and click Next
  5. Fill in the “Server:”, “Database:”, “Username:” and “Password” for the SQL Database
  6. Click the “Build” button to generate the Database Connection String
  7. Click the “Test” button to confirm SimpleIndex is connected to the Database properly
  8. Click the “Load” button under “Table or View:” and then select the Table or View that needs to be Inserted to
  9. Link all of the fields in SimpleIndex to the columns in the database that they should Insert to

Search Existing Data

  1. Open the Job Settings Wizard and go to the Database step
  2. Set the Database Mode to Retrieve and View Records
  3. Click the “New Data  Source…: button
  4. Select the SQL Database radio button and click Next
  5. Fill in the “Server:”, “Database:”, “Username:” and “Password” for the SQL Database
  6. Click the “Build” button to generate the Database Connection String
  7. Click the “Test” button to confirm SimpleIndex is connected to the Database properly
  8. Click the “Load” button under “Table or View:” and then select the Table or View that needs to be Inserted to
  9. Link all of the fields in SimpleIndex to the columns in the database that they should Insert to

Autofill Based on Key Values

  1. Open the Job Settings Wizard and go to the Indexing & File Naming Step
  2. Click the “Autofill Settings…” button
  3. Select the SQL Database radio button and click Next
  4. Fill in the “Server:”, “Database:”, “Username:” and “Password:” for the SQL Database
  5. Click the “Build” button to generate the Database Connection String
  6. Click the “Test” button to confirm SimpleIndex is connected to the Database properly
  7. Click the “Load” button under “Table or View:” and then select the Table or View that needs to be Inserted to
  8. Select the key field for the database column in the “Database Key Field 1:”
  9. Select the key field for the SimpleIndex index field in the “Index Key Field 1:”
  10. Set-up the Autofill fields that need to be filled in based on the key field

Related Links

  • SimpleIndex.com – Database Integration
  • SimpleIndex.com – Automatic Indexing Using Existing Data
  • SimpleIndex Wiki – Database
  • SimpleIndex Wiki – SQL Server
  • SimpleIndex Wiki – Database or Spreadsheet
  • SimpleIndex Wiki – Data Source
  • SimpleIndex Wiki – ODBC
  • SimpleIndex Wiki – Autofill
DatabaseDatabase AutofillSQL Server
Read more
  • Published in Database & Retrieval
No Comments

I know nothing about databases. Can I still use the database and Retrieval Mode features?

Wednesday, 28 February 2018 by dwilder

Yes! We’ve made it simple to create a database that you can use to store index information and perform searches with SimpleIndex Retrieval Mode.

Once you have configured a SimpleIndex job to scan and store documents on your network, use these steps to create a database to store index information for searching:

  1. Go to the Database step in the Job Settings Wizard
  2. Click “New Data Source…”
  3. Select Default and then click Next
  4. Click Yes when asked to “Copy default database to config file folder and configure settings?”
  5. The database will be copied to the folder that the Job Configuration is saved in and the name of the database will be the same name as the Job Configuration with all of the fields in SimpleIndex

This creates a database and automatically links it to your SimpleIndex Job Configuration for uploading to or searching from.

Related Links

  • SimpleIndex.com – Database Integration
  • SimpleIndex Wiki – Database
  • SimpleIndex Wiki – Data Source
  • SimpleIndex Wiki – Database Mode
DatabaseDocument RetrievalMS AccessMySQLODBCOracleServer OCRSharePoint ScanningSQL ServerWorkflow Software
Read more
  • Published in Database & Retrieval
No Comments

Search

Contact Us Today!

=

Search Knowledge Base

Recent KB Articles

  • SimpleIndex Not Autorunning Jobs
  • Prompt Before Appending with Identical Filename
  • Error in Program Load: 481 - Invalid Picture
  • Order of Import
  • How do I purchase, register and activate Simple Software products?
  • What are SimpleIndex Specifications?
  • License Activation Issues
  • If it possible for index values to be keyed twice to ensure accuracy (double-key verification)?

Feature Cloud

Optical Character Recognition Bar Code Scanning PDF Forms SharePoint Scanning Front End Scanning MySQL Business Process Automation Document Classification Microsoft Word Data Extraction XSLT Data Conversion Software Scanned Document Indexing Watermark PDF Data Extraction Software Full-Text Search PDF Bookmarking Barcode OCR Office to PDF CSV Workflow Software PDF Compression Solution Watermark PDF Files SharePoint Migration Screenshot OCR Text Processing TIFF PDF Annotations Image Scanning XSLT Patch Code Screen Scraping OCR SimpleView Barcode Printing QuickBooks Online MS Office Required Documents Auditing PDF Archive Scanning Software Unattended Optical Mark Recognition Distributed Scanning 1-Click Processing Paperless Office Document Imaging Office PDF Document Indexing SimpleSend OCR Scanning

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

© 2022 Meta Enterprises, LLC | Knoxville, Tennessee | A Family Owned Company
© 2022 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 vendors Read more about these purposes
View preferences
{title} {title} {title}
});