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?

How do I connect to an SQL Server database?

by dwilder / Wednesday, 28 February 2018 / Published in Database & Retrieval

How do I connect to an SQL Server database?

Created OnFebruary 28, 2018
bydwilder
Print

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
Tags:
  • accdb
  • data source
  • Database
  • insert
  • mdb
  • microsoft access
  • odbc
  • ole db
  • query
  • sql
  • SQL Express
  • sql server
  • Tweet
Tagged under: Database, Database Autofill, SQL Server

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

Required Documents Auditing Barcode Recognition Software Patch Code PDF417 PDF Archive Scanning Software Microsoft Word Data Extraction ODBC PDF SimpleSend Scanning Coversheet RPA Workflow XML Workflow Software Scanning Software SQL Server PDF Compression 1-Click Processing Automatic Indexing Software Personal Document Management XSLT Read PDF Forms Metadata Database RegEx Oracle TIFF ISIS Driver PDF Barcode Recognition Optical Mark Recognition Screen Scraping OCR Scanned Document Indexing Robotic Process Automation Batch Scanning Bar Codes Business Process Automation Imprinting Unattended TIFF PDF Annotations File Indexing Bar Code Scanning MS Office QuickBooks Document Management TWAIN & ISIS Scanning Watermark

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