Category: Elasticsearch ETL
-
ETL SQL into Elasticsearch
Low latency, complex data model SQL data synchronization with Elasticsearch Elasticsearch (ES) is a NoSQL databases optimized for the fuzzy logic of text search. SQL databases tend to struggle with text search. They are CPU and IO intensive and not as flexibility with the search logic. So there is a strong need for a SQL…
-
ETL NoSQL Best Practices
Mongo, Redis, Elasticsearch or Couch Legacy ETL tools are problematic for NoSQL databases. They assume tabular data and are not well suited for hierarchical Json data typically used in NoSQL databases. They also assume batch processing and JDBC style connection. ETL for NoSQL database use cases likely require a restful interface and streaming for low…