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

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: Apache Manifold JDBC Connector Apache Nifi - Read from ExecuteSQL and write to Solr index Setup the built in RDBMS data import handler for your database Export your database to a CSV format and use the build in CSV import of Solr Write a short Python script for database import based on Open Semantic ETL with a concrete SQL query, write the columns to the data variable (data type is a Python dictionary i.e. data['columnname'] = columnvalue and export/write it to index by calling etl.process(data=data) Other Extract Transform Load (ETL) - Frameworks like Talend Open Studio

Import SQL database to Elastic Search index

Free Software for indexing SQL to Elastic Search: Apache Manifold JDBC Connector Apache Nifi - Read from ExecuteSQL and write to Elastic Search index Elastic search JDBC Importer Export your database to a CSV format and use the build in CSV import of Solr Write a short Python script for database import based on Open Semantic ETL with a concrete SQL query, write the columns to the data variable (data type is a Python dictionary i.e. data['columnname'] = columnvalue and export/write it to index by calling etl.process(data=data) Other Extract Transform Load (ETL) - Frameworks like Talend Open Studio