We want to create integrated search of similar databases / tables with similar fields and schema, e.g. United States real estate listings search of multiple real estate properties databases such as these:
Each of the 3 data sets above is a MySQL database query, joined by multiple tables.
You can see each of them has similar fields but also different fields. We are not familiar with Elasticsearch yet and we are thinking about switching to it but we are not sure if it can do this? Integrated search of multiple databases with similar fields?