Database Indexer

Database Indexer is an add-on for dtSearch Desktop/Network or dtSearch Web to search SQL type databases.

Works with local and cloud-based databases: SQL, MySQL, SQL on Azure, and SQL on AWS

Easily perform fuzzy, phonic, or field searches with stemming and WordNet expansion

Use dtSearch Desktop on your databases without constructing complex SQL Queries or impacting database performance with long running queries

Display ranked search results with a synopsis and field columns

Schedule index updates

Update the index when the database experiences low traffic

High availability search

Search during database failures or database upgrades; indexes created by Database Indexer are independent of the database

Localization enabled

Edit an external file to translate all visible text into any language supported by Unicode

New in Version 1.4

[DBi] : index name prefix for compatibility with dtSearch Desktop 2021.02 Index Groups, old indexes will automatically get renamed.
TreeView Index Rename and Delete options, shortcut uses Windows Menu key.
Added: Shortcut key for “Open Index in dtSearch Desktop” (Alt+O)

Features

Index all or selected fields, and/or extract documents (text, binary file or filepath)
Index from a table or Custom Query using SQL SELECT Statement
Indexes are automatically recognized and can be searched in dtSearch Desktop/Network or dtSearch Web/Engine
Indexes can be rebuilt or incremental updating based on a last modified date field
Index Options are saved per index
Built in index scheduler
dtSearch Desktop will list all the columns in the database as searchable fields, so that searches can be limited to chosen fields e.g., cheese and (Brand contains (Tesco ))
Configure enumerable fields to enable facet searching with Universal Search Clients
Data type of columns is detected and saved; Universal Search API will use this to determine when to show Date Picker in Universal Search Clients.
Select column to be ‘key’ to a value in another table; for example, when indexing a table that contains column ProductBrandID but not the brand name itself, you can select ProductBrandID as the key for the value to be found in the Brands table
Set user-friendly Display Name for database columns; dtSearch Desktop/Network and Universal Search Clients will use the display name instead of the column name for fields
Alphabetical sorting of all lists of tables & columns
Each Index can contain up to 1Tb of data.
OS: Windows 10, Windows Server 2012 R2 or later
Databases currently supported
- MS SQL – Windows Authentication or SQL Server Authentication.
  - MS SQL support for composite primary key (where the value is from two or more columns in that table)
- MySQL – Connection methods:
  - Standard TCP/IP
  - Local Socket Pipe
  - Standard TCP/IP over SSH

30 Day Trial version

Trial version is limited to 10,000 records per datasource.

License

Annual subscription license covers installations up to the number of dtSearch Desktop/Network user licenses and includes technical support & updates.

Inquiries invited for database types not listed or special requirements.

Please contact us if you want to access our demo Azure and AWS databases.

Annual license covers installation up to the number of licensed dtSearch Desktop/Network users:

Buy DBi-S

DBi-S $690/year for 50+ user license

Buy DBi-50

DBi-50 $495/year for 26-50 user license

Buy DBi-25

DBi-25 $249/year for 1 to 25 user license

For use with dtSearch Web or dtSearch Engine covered by a single-server license purchase DBi-25, for use with dtSearch Web/Engine three-server license purchase DBi-50, for larger installs purchase DBi-S.

30-day trial

All include a 30-day free trial for a single install.
Indexes can be searched by the number of dtSearch Desktop/Network licensed users

User Guide

User Guide for 1.4.8133
(Refresh your browser and ensure date in User Guide is 20 Apr 2022)

Release Notes
1.4.8133 (2022-04-08)

Must be installed on the same machine as a licensed dtSearch Desktop/Network 7.96 or later and be within your initial one year support period or have purchased an upgrade and are within your current support period.

Pricing is non-concurrent: e.g., the DBi-50 50 user license covers up to 50 machines in a single organization with the software running either in a shared network environment or separately for each end-user (e.g. for laptops).