You are here

Full text search, faceted search & textmining in a database (SQL DB)

Connectors for Relational Database Management Systems (RDBMS) & Structured Query Lanaguage (SQL) to Solr or Elastic Search

To be able to use simple and powerful search user interfaces (UI) for full text search, faceted search, semantic search and ontology or thesaurus based text mining research tools on structured data from fields of a SQL database, import their tables to the search index:

Index SQL databases like MySQL or Postgresql

There are multiple ways or open source connectors for import SQL databases like MySQL, MariaDB, PostgreSQL and other SQL databases based on Structured Query Language (SQL) or supported by Open Database Connectivity (ODBC) or Java DataBase Connectivity (JDBC) to Apache Solr index:

Import SQL database to Solr search index

Free Software for indexing SQL to Apache Solr:

Import SQL database to Elastic Search index

Free Software for indexing SQL to Elastic Search: